Display name

The name of the table shown in the user interface.

Code name

Name used in your code.

Enable export

If enabled, users who view the table will be able to export the displayed data to external files using the Microsoft Excel (XLSX), CSV or XML format. The data export feature may be accessed by right‑clicking the table in the report, which will open a context menu with possible export actions.

Query

Here you can add the SQL query used to retrieve data to be displayed by the table.

For security reasons, the Edit SQL queries permission for the Reporting module is necessary to edit this property.

Is stored procedure

Indicates if the query is a stored procedure or not.

No record text

Text to be displayed if the query doesn't return any data.

Skin ID

ID of the .NET skin (stored in the .skin files in ~/AppThemes/<theme name>) which will be used for the table.

Enable paging

If enabled, paging will be enabled when the report table is displayed. The paging can be configured by the two properties below.

Page size

Number of table rows per page.

Paging mode

Type of paging controls displayed below the table. The following options are available:

•Previous-next buttons - displays buttons leading to the previous and next page

•Page numbers - displays page numbers leading to the corresponding pages

•Previous-next-first-last buttons - displays buttons leading to the first, last, previous and next page

•Page numbers-first-last buttons - displays page numbers leading to the corresponding pages and buttons leading to the first and last page