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