Two SQL procedures allow you to globally replace Dexterity reports with the SSRS equivalent. The procedure for SSRS reports is WS_SetReplacementForSQL. Note:
| Note |
|---|
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