SQL Procedures

Two SQL procedures allow you to globally replace Dexterity reports with the SSRS equivalent. The procedure for SSRS reports is WS_SetReplacementForSQL.

Running either of these procedures DOES NOT update a ReportLocation that already contains a value; it only applies to blank ReportLocation columns, which assumes that the Dexterity report is being used.

You run these procedures against the company database, as in the example below:

exec WS_SetReplacementForSQL