Show/Hide Toolbars

Thereforeā„¢ Help

Tutorials > Solution Designer > Design > Reporting > Microsoft SQL Server Reporting Services > Defining Reports and Subscriptions

Customizing Reports

Scroll

Since the Reporting module is based on SQL Server Reporting, reports can be highly customized. In order to customize reports, an .rdl editor must be installed. We recommend downloading the free Microsoft SQL Report Builder compatible with your database version.

 

stepsHow can I customize a report or report template?

1.Right-click on a defined report or report template and select Edit Report. The report will open in Microsoft SQL Report Builder.

SD_T_Reports_Define_Customize_001

2.The report can be customized to suit your needs by changing parameters, images, styles, and other settings. While some SQL Report Builder functions are described in the Reference section, please refer to Microsoft's documentation for more details. This can easily be accessed by pressing F1 while the application is open.

SD_T_Reports_Define_Customize_002

Info

You can test your report at any time by selecting Run in the top-left corner. This requires access to the Report Server, and thus will not work in hosted systems such as Thereforeā„¢ Online. For hosted systems, we recommend editing the report offline and then uploading it using the Add Existing Report feature.

This will only work when editing a defined report, NOT a template.

Any parameters used in the Thereforeā„¢ Solution (for example The_Category) require the prefix: The_ in the report definition. The parameters bound to category and workflow reports (found in report templates) are:

The_Title

The_Category

The_WFProcessNo

The_WFTaskName

The_ReportStart

The_ReportEnd

The_Field_String_XXX

The_Field_Date_XXX

The_Field_Money_XXX

The_Select_XXX

Non-Therefore category parameters from custom reports can be used. Valid data types that can be used within these parameters: string, integer, decimal, date, boolean.

 

3.When you're finished editing the report, simply save it and close the Report Builder. The Thereforeā„¢ Solution Designer will detect the changes and a pop-up will be displayed where the changes can be confirmed and saved.

SD_T_Reports_Define_Customize_003