Home > Advanced Functions > Page Objects > Report
Report
The built in report designer allows administrators to design summart reports which pull information from various dataset tables and other tables within the project database. A report could be created to display a list of user accounts for the project. Follow the steps below to create a simple report listing user accounts:
1. Select the page that you want to add the report to.
2. Click 'Edit Page'
3. Click the 'Insert Page Object' icon.
4. Select 'Report' and then click 'Insert'
5. Click anywhere on the report panel to display properties.
6. For 'SQL Query' enter "select * from [_users]"
7. You should then see a list of fields that can be added to the report.
8. Click 'Username', 'Full Name' and 'Security Group' to add them to the report. The field will be added as a column and a matching parameter field will also be added. If the parameter field is not required, you can simply delete the textbox and label.
9. Click the 'Save' button to save the page and switch to live mode.
10. By default, all records will be listed. You can filter the report by entering a parameter and then clicking 'Run Report'.
Note: When the report is printed, the 'Run Report' button will not be displayed.
Page Names in Reports
The 'Page Name' field is not located in any table in the project database, however it is possible to include page names in your reports by entering an SQL Query with PageID with the alias "PageNameFromID". For example, to create a report that lists page names and associated page views, the SQL Query would be: SELECT PageID AS PageNameFromID, Views FROM [_Page Views]
See also