WSRepts Table

A table called WSRepts stores the path location for reports. This table is created in each company database during the Signature installation or upgrade process.

The ReportLocation column stores the full path and filename of the report being referenced. This could be a local SSRS report or the URL of a remote SSRS report. A blank column assumes the system is running the Dexterity version of the report.

Below is an example of updating the WSRepts table with a replacement report than what is currently specified. You can determine the name of the Dexterity report by printing that report from within the system. Our examples will use the SV_Service_Audit_Cost_Report. For SSRS reports, you also need to know the machine name on which your report server resides.

UPDATE WSRepts Set ReportLocation = 'http://localhost/ReportServerNew/TWO/Signature Service/Service Cost Audit'where ReportReference ='SV_Service_Cost_Audit_Report'