Search - Joel Lipman .Com

21. Fix Oracle Tnsping 3511 without Windows Registry: / Oracle PL/SQL /; ... Setting environment variables using the Command prompt (DOS) wouldn't stick (session only). My Fix Right-click on "My Computer" > select "Properties" Click on "Advanced System Settings" Click ...; Created on 04 March 2013
22. Administrator Program Shortcut without Prompt: / Windows OS /; ... to display as (eg. "Visual Studio 2010") Click on OK to complete your shortcut. Additional: You can change the icon for the shortcut using the shortcut properties and browsing to the program it ...; Created on 25 February 2013
23. Returning Oracle Stored Procedure Resultset in SSRS: / SQL Server Reporting Services /; ... has to be listed in the "dataset properties" > "query parameter values" under "Parameter Name" and then the SSRS parameter value (eg. "[@my_ssrs_parameter]"). Internal .Net Framework Data Provider error ...; Created on 19 January 2012
24. SSRS Parameters in Oracle Stored Procedure: / SQL Server Reporting Services /; ... in the next screenshot. Note how all our variables are hidden and cannot be NULL. If you're unsure, right-click on your dataset and bring up its properties... Specify the query type as "Stored Procedure" ...; Created on 02 September 2011
25. Sort order a dropdown list in MS InfoPath without programming: / Infopath /; ... the above it would all work: Open your form in InfoPath Go into Design mode Go to "Controls" and add a Drop-down List Box to your form Right-click it and select "Drop-down List Box Properties" Under ...; Created on 21 July 2011
26. SSRS Querying on either of 2 Parameters: / SQL Server Reporting Services /; ... revisited solution below -> Just leave the "allow blank" option in the parameter properties unchecked SSRS Report Revisted: Had an issue where SSRS report parameters were not resetting to blank ...; Created on 19 July 2011
27. Run commands for Windows: / Windows OS /; ... dcomcnfg Computer Management compmgmt.msc Control Panel control Date and Time Properties timedate.cpl DDE Shares ddeshare Device Manager devmgmt.msc Direct X Control Panel (if installed)* directx.cpl ...; Created on 05 July 2011
28. Checklist for the local computer repairs: / IT Support /; ... documents/programs to do this? Same errors on another computer? What are your workarounds? Protocol for Troubleshooting: Check system properties for RAM and CPU speeds Reduce visual effects ...; Created on 28 April 2011
29. SSRS Hide results table if empty: / SQL Server Reporting Services /; Update August 2011 So I don't know how many people were just saying why don't you do the following: Bring up the "Tablix Properties" of the dataset Look for the section "No Rows" Put in a value for ...; Created on 29 March 2011
30. URL passed settings in Reporting Services: / SQL Server Reporting Services /; ... the Toolbar (Advanced) To enter custom code for a report, view the report properties, the first field in Report Builder or Business Intelligence Development Studio (BIDS) is "Code". Click on the browse ...; Created on 11 February 2011
31. Alternate row background colour in Reporting Services: / SQL Server Reporting Services /; ... is what I use most frequently]. Additional: Suppose you have lots of columns, you don't want to have to click on each cell to specify this so just do it to the first column then bring up the properties ...; Created on 04 February 2011
32. SQL Calendar in Business Intelligence Development Studio: / Transact-SQL /; ... properties instead of getting the expression to return it exactly (there seem to be issues with this - error textbox1[0]...). You will need this expression to set the font color of days that are in ...; Created on 14 January 2011
33. Connection Strings for SQL Server: / SQL Server /; ... Properties=""""; This is a free simple .NET compliant MySQL driver. Project space at SourceForge. MySQL OLEDB Type: OLE DB Provider Usage: Provider=MySQLProv Manufacturer: MySQL ...; Created on 05 January 2011
34. Create Read-Only Database User in SQL Server: / Databases /; ... > Logins. Right-click on the user who will be set as having read-only access (in this example "adventureworksro"). Select Properties. Select User Mapping. Map the login to the database they will ...; Created on 09 November 2010
35. Error during processing - Converting Date/Time: / Transact-SQL /; ... you've added your parameters (date/time type): Right-click on the DataSet. Select 'DataSet Properties. Find your parameters in the Query. Check that there are no apostrophes ...; Created on 13 July 2010
36. Change Regional Settings for your Report: / SQL Server Reporting Services /; ... to Design Select the View tab Check that the "Properties" pane is displayed/ticked Change Language under Report Properties > Localization to en-GB Save the report and test. ...; Created on 17 May 2010
37. Report Builder 2.0 - Hide Series1: / SQL Server Reporting Services /; ... interface (F8) Right-click on your dataset (in my case: DataSet1) Select 'Dataset Properties' Add a condition to the WHERE clause Specify that the field name in the series fields ...; Created on 06 May 2010
38. SSRS Report Builder 2.0 - Error during processing: / SQL Server Reporting Services /; ... Properties' Select 'Parameters' and click on the duplicated field Click on the 'Delete' button and you should be left with just: ...; Created on 06 May 2010
39. Windows 7 and Google Chrome incognito mode by default: / Google /; ... Chrome option in the context menu Left-click on Properties Add the word -incognito (including the hyphen/dash) to the end of the Target value Ok that and see if it works Note ...; Created on 24 March 2010
40. How to run a .RUN file: / Linux /; ... Through the Gnome GUI Right-click on the file you downloaded Select 'Properties' Select the 'Permissions' tab Tick the 'Execute' checkbox Conclusion The solution using ...; Created on 19 September 2009