| Table of Contents |
|---|
This page details the process of creating a report using the Asamco B.V. Report Module.
...
The "Clear" option can be chosen to clear the input value. Be aware that the substitution of empty values in the SQL query can have unpredictable results.
Layout
...
Tab
The next page in the Wizard is the Layout page. The content of this page depends on the type of the report that was chosen on the Settings page of the Wizard.
DataGrid
The DataGrid layout editor displays the output of the query specified in the Query tab in a Devextreme DataGrid, using the default parameters specified on the Defaults tab.
Changes can be made to the layout of this grid by interacting with its elements, for example, by dragging the border of a column to change its width. Any changes that are made in this way are saved and loaded again when the report is shown. The datagrid that will be shown to the user in the actual report will have any such changes applied to it.
The Edit Settings buttons at the bottom of the page can be used to edit the technical Devexpress configuration settings of the grid or the fields of the grid respectively. Consult the Devexpress DataGrid documentation for information on what each definable property means.
To edit the settings of a column field, select a field in the dropdown box on the lower left and click Edit Settings on the lower right. Consult the Devexpress DataGrid Columns documentation for information on what each definable property means.
PivotGrid
The PivotGrid layout editor displays the output of the query specified in the Query tab in a Devextreme PivotGrid, using the default parameters specified on the Defaults tab.
Click the icon at the top left of the grid to open the Field Chooser, which will enable you to select and categorize fields to be displayed in the grid:
At the bottom of the page, the properties of the Grid, or of a selected column Field, can be edited. This works the same way as in the DataGrid. See the DataGrid section above for more information on this.
For information on definable Grid and Field properties, consult the Devextreme PivotGrid configuration documentation and the Devextreme PivotGrid Fields configuration documentation.
For fields that are marked as Data Fields in the Field Chooser, a summary type can be specified. This will determine how the values of this field from the collection of records associated with the Row Fields of the row in question will be displayed in a summarized format.
Consult the Devextreme Pivot Grid documentation for more information on how the Pivot Grid works and how it can be configured.
BIC/Excel
The BIC/Excel layout page allows you to upload an excel file that will serve as a template for the report excel output file:
The PDF layout page lets you download a layout editor desktop application, export a layout XML file and import a layout XML file again after editing it with the editor:
The instructions on this page speak for themselves. For more information on how to design PDF layouts, consult this Report Designer How-to article.
| Expand | ||||||
|---|---|---|---|---|---|---|
| ||||||
|
Finish Wizard Tab
The Finish Wizard page notifies you that your report has been created and gives you the ability to navigate to various pages related to different aspects of the report:
...
The report settings page allows you to change any of the properties that were input during the creation of the report. You can additionally specify a category based on which reports can be filtered. The category is not currently relevant for any other purpose.
Layouts Tab
The layouts page gives you the ability to define multiple layouts for the report. When more than one layout exists, a layout can be selected from the list by the user when s/he views the report.
...