Managing reports

Managing reports

Tillypad XL Manager includes a set of system reports, which cannot be edited. The user can create his or her own reports by copying or inheriting from these system reports.

A configurable report includes:

  • an SQL query that is used to gather required data,

  • a filter (a set of filter wizard steps) to select data preliminarily,

  • a print layout,

  • functions to select a command from the context menu of the report.

Reports can be opened from the main menu, but they must be configured in the Report settings directory.

To create or edit a report query (in the Report settings directory), you need to have some knowledge of how to write queries in the Transact SQL language.

To make changes to the print layout design, use the FastReport editor. In some cases when creating or editing print layout designs, you might need to possess skills in the following languages: PascalScript, C++ Script, BasicScript, or JScript. By creating different print layouts that use the same data, you can generate a wide variety of possible reports.

When creating a report, you will need to specify the source data and the parameters by which these data need to be filtered. When configuring filter settings, you can save the preset parameters. Functions that are added to the context menu of the report data grids allow you to perform additional operations in the report window. You can specify the software modules from which the report will be printed. For more information on what actions you need to take to configure reports, please refer to the description of the Report settings directory.

Objects from reports can be copied into the program using the clipboard.

You can inherit both reports and their print layouts.

Inheritance proves a useful feature when you need to create reports and print layouts that differ from existing reports and layouts only in minor ways.

Each report only has one print layout. This means that if you would like to create a second print layout for the same report, you need to create a new report based on the original report (or, if the inheritance feature is not required for the new report, you can create a copy of the original report).

A print layout that is created based on another print layout will display any changes made to the original print layout. Creating print layouts based on other print layouts facilitates the operation of the FastReport editor.

When a report is inherited, the Based on field is filled out in the Properties panel; when a print layout is inherited, the Based on field is populated in the Print layouts panel.

You can store the entries for required parameters in the report (i.e. create preset parameters). These parameters are saved in the Filter panel in the report window. Then, when you create a new report, you can select the saved parameter values in one filter wizard step.

Figure 4.37. Preset parameters in the Filter panel in the report window


An SQL query can return multiple data sets. To manage the appearance of data from each data set, separate panels are generated for each data set. They are named Data set model (Data set name), e.g. Data set model Main.

Figure 4.38. Data set models in the report window


The Print from software modules panel in the report window is used to specify from which software modules this report can be printed.

Figure 4.39. Print from software modules panel in the report window