Run commands for Windowshttps://www.joellipman.com/articles/microsoft/windows-os/run-commands-for-windows.html

05 July 2011 Command Prompt cmd Component Services 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 Direct X...

• Type: Article
• Author: Joel Lipman
• Category: Windows OS
• Language: en-GB

Alternate row background colour in Reporting Serviceshttps://www.joellipman.com/articles/microsoft/ssrs/alternate-row-background-colour-in-reporting-services.html

04 February 2011 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 pane and scroll down to the "Fill > BackgroundColor" row and copy the value to your clipboard or notepad, etc. Then...

• Type: Article
• Author: Joel Lipman
• Category: SQL Server Reporting Services
• Language: *

SSIS Script: convert UPPERCASE to Mixed-Case using TitleCasehttps://www.joellipman.com/articles/microsoft/ssis/ssis-script-convert-uppercase-to-mixed-case-using-titlecase.html

04 October 2013 using System.Globalization; // for cultureinfo and textinfo using System.Reflection; // for looping through properties using System.Threading; // for threading [Microsoft.SqlServer.Dts.Pipeline.SSISScriptComponentEntryPointAttribute] public class...

• Type: Article
• Author: Joel Lipman
• Category: SQL Server Integration Services
• Language: en-GB

SSRS Hide results table if emptyhttps://www.joellipman.com/articles/microsoft/ssrs/ssrs-hide-results-table-if-empty.html

29 March 2011 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 "NoRowsMessage". This solution hides the entire Tablix which...

• Type: Article
• Author: Joel Lipman
• Category: SQL Server Reporting Services
• Language: en-GB

SSRS Parameters in Oracle Stored Procedurehttps://www.joellipman.com/articles/microsoft/ssrs/ssrs-parameters-in-oracle-stored-procedure.html

02 September 2011 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" and then browse the dropdown for the name of your stored procedure...

• Type: Article
• Author: Joel Lipman
• Category: SQL Server Reporting Services
• Language: en-GB

Restore MSSQL Error: Database is in usehttps://www.joellipman.com/articles/database/restore-mssql-error-database-is-in-use.html

08 March 2013 of the SQL Server Database Engine, and then expand that instance. Right-click the database to change, and then click Properties. In the Database Properties dialog box, click the Options page. From the Restrict Access option, select Single. If other...

• Type: Article
• Author: Joel Lipman
• Category: Databases
• Language: en-GB

SSIS Skip Rows in Excel Source filehttps://www.joellipman.com/articles/microsoft/ssis/ssis-skip-rows-in-excel-source-file.html

04 April 2013 have 38 columns ("A" to "AL"): In the data flow, click on the Excel datasource component so that it's selected. View the Properties panel for this. Under Custom Properties » OpenRowset, you should see the name of the Excel worksheet you specified as the...

• Type: Article
• Author: Joel Lipman
• Category: SQL Server Integration Services
• Language: en-GB

AutoHotkey: Get Media Information and Displayhttps://www.joellipman.com/articles/automation/autohotkey/autohotkey-get-media-information-and-display.html

07 August 2020 an app similar to the file explorer in the Microsoft Windows OS. Why? I had an app for use in MS Windows 7 to display the properties of sound files though this is also applicable to media files in general. How? So first I'm going to list a function I...

• Type: Article
• Author: Joel Lipman
• Category: AutoHotkey
• Language: *

Change Regional Settings for your Reporthttps://www.joellipman.com/articles/microsoft/ssrs/change-regional-settings-for-your-report.html

17 May 2010 to UK format (dd/MM/yyyy). You can override this in the report by: Go 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.

• Type: Article
• Author: Joel Lipman
• Category: SQL Server Reporting Services
• Language: en-GB

ZCRM Client Script: Correct Decimal Fields OnLoadhttps://www.joellipman.com/articles/crm/zoho/zcrm-client-script-correct-decimal-fields-onload.html

13 December 2023 and will sometimes return numbers with more than 6 decimal places. As this is more than specified on the ZohoCRM field properties, as soon as the staff user tries to save the record, they will get a validation error on the decimal field even if that's...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Error during processing - Converting Date/Timehttps://www.joellipman.com/articles/database/t-sql/error-during-processing-converting-datetime.html

13 July 2010 parameters into my query. Once 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 enclosing the parameters. Before: After:

• Type: Article
• Author: Joel Lipman
• Category: Transact-SQL
• Language: *

Create Read-Only Database User in SQL Serverhttps://www.joellipman.com/articles/database/create-read-only-database-user-in-sql-server.html

09 November 2010 > 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 have access to. Tick the boxes for role membership next to...

• Type: Article
• Author: Joel Lipman
• Category: Databases
• Language: *

Connection Strings for SQL Serverhttps://www.joellipman.com/articles/microsoft/sql-server/connection-strings-for-sql-server.html

05 January 2011 team Standard Location=myServerAddress;Data Source=myDataBase;User ID=myUsername;Password=myPassword;Port=3306;Extended Properties=""""; This is a free simple .NET compliant MySQL driver. Project space at SourceForge. MySQL OLEDB Type: OLE DB Provider...

• Type: Article
• Author: Joel Lipman
• Category: SQL Server
• Language: *

SQL Calendar in Business Intelligence Development Studiohttps://www.joellipman.com/articles/database/t-sql/sql-calendar-in-business-intelligence-development-studio.html

14 January 2011 Note that I've asked it to return the full date of the parameter, this is because I will format it via the text-box properties instead of getting the expression to return it exactly (there seem to be issues with this - error textbox1[0]...). You will...

• Type: Article
• Author: Joel Lipman
• Category: Transact-SQL
• Language: en-GB

URL passed settings in Reporting Serviceshttps://www.joellipman.com/articles/microsoft/ssrs/url-passed-settings-in-reporting-services.html

11 February 2011 &rc:Stylesheet=Htmlviewer_copy.css Customize 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 button...

• Type: Article
• Author: Joel Lipman
• Category: SQL Server Reporting Services
• Language: en-GB

Checklist for the local computer repairshttps://www.joellipman.com/hardware/checklist-for-the-local-computer-repairs.html

28 April 2011 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 for increased performance during troubleshooting Note background and visual...

• Type: Article
• Author: Joel Lipman
• Category: IT Support
• Language: *

SSRS Querying on either of 2 Parametershttps://www.joellipman.com/articles/microsoft/ssrs/ssrs-querying-on-either-of-2-parameters.html

19 July 2011 who don't have an AD account. Using the 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 after the report...

• Type: Article
• Author: Joel Lipman
• Category: SQL Server Reporting Services
• Language: en-GB

Sort order a dropdown list in MS InfoPath without programminghttps://www.joellipman.com/articles/microsoft/infopath/sort-order-a-dropdown-list-in-ms-infopath-without-programming.html

21 July 2011 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 "List box entries" select Look up values from an external data source Next to "Data source" click on Add Select...

• Type: Article
• Author: Joel Lipman
• Category: Infopath
• Language: *

Returning Oracle Stored Procedure Resultset in SSRShttps://www.joellipman.com/articles/microsoft/ssrs/returning-oracle-stored-procedure-resultset-in-ssrs.html

19 January 2012 of arguments in call - Fixed this by double-checking the parameters. Input variable 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...

• Type: Article
• Author: Joel Lipman
• Category: SQL Server Reporting Services
• Language: en-GB

Administrator Program Shortcut without Prompthttps://www.joellipman.com/articles/microsoft/windows-os/administrator-program-shortcut-without-prompt.html

25 February 2013 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 was created to run. Related Link(s): Elevated Program Shortcut without UAC Prompt Avoid UAC...

• Type: Article
• Author: Joel Lipman
• Category: Windows OS
• Language: *