Versions Compared

Version Old Version 3 New Version 4
Changes made by

Documentation Reviewer

Kimberly Onnen

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

You can customize the company logo that appears on some of your customer-facing reports, for example, invoices.
For each of the reports that display a logo, the .rdl file points to the subfolder Signature Images and the file Company Logo. The default logo is a transparent image that appears on the reports as blank.

If you want your own 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.

Image Modified


  1. In Report Manager, locate the company where reports are deployed, and open the folder Signature Images.
  2. Rename or delete the default Company Logo file by choosing Show Details, then Edit or Delete.
  3. 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.   

Image Modified

Image Modified

Step 3: Set up Signature SRS Reports to Print from GP

...

Info

About the WSRepts Table

The 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:

Image Modified

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 Procedure

The SQL procedure WS_SetReplacementReportsForSRS 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 to call on the stored procedure: exec WS_SetReplacementReportsForSRS
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.

...