...
If you want your company logo to appear on the reports, you can replace this image; however, DO NOT delete the default logo unless you are replacing it. If the .rdl cannot locate Signature Images\Company Logo, the logo appears on the report as a missing image.
To set up the company logo:
- In Report Manager, locate the company where reports are deployed, and open the folder Signature Images.
- Rename or delete the default Company Logo file by choosing Show Details, then Edit or Delete.
- Return to the Signature Images folder and select Upload File. Before uploading, change the name of your new logo to Company Logo (no file extension), then select OK.
...
| Info |
|---|
About the WSRepts TableThe table WSRepts stores the path location for replacement reports. This table is created in each company database during the Signature installation or upgrade process. A select statement on this table yields something like the following:
The ReportReference column identifies the name of the report you want to replace, most likely a Dexterity report name. The ReportLocation column stores the full path and file name of the report being referenced. This could be a local SSRS report or the URL of a remote SRS report. A blank column assumes the system is running the Dexterity version of the report. To replace the Dexterity report with the SSRS report, you must populate this column with the SSRS report location. In the example below, an existing Dexterity report is replaced with an SSRS report using the stored procedures. UPDATE WSRepts Set ReportLocation = 'http://localhost/ReportServerNew/TWO/Signature Service/Service Cost Audit' where ReportReference ='SV_Service_Cost_Audit_Report' If you are replacing reports individually, you can determine the name of the Dexterity report by printing that report from within the Signature system. For SSRS reports, you also need to know the machine name on which your report server resides. Running the SQL Stored ProcedureThe SQL procedure WS_SetReplacementReportsForSRS globally globally replaces all applicable Dexterity reports with the SSRS report equivalent. Running this procedure 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. If you already have a custom report specified to replace the Dexterity report, it will not be overwritten. To replace Dexterity reports, run the following command against the company database database to call on the stored procedure:
The common printing DLL Signature.ReportControl.dll provides the WSRepts table and the two SQL procedures that can be used to set up SQL reporting. For more information on this DLL, refer to the user manual. |
...