You can place a single query in a report, or you can insert multiple queries. Each query can be on a separate page, or you can divide a single page into sections and insert one query in each section. You can also insert other elements, such as text and graphics. Reports are limited to 1000 pages. If the report is longer than 1000 pages, the results are truncated.
If you plan to publish and distribute the report to other users, you must select a query from Published Queries. In the Query Chooser window, you can drag a query from My Queries to Published Queries.
When you create a custom report, you have the formatting options described in . The options appear on a menu when you right-click in the report template. Each menu option has a corresponding icon on the report design toolbar.
Table: Report building options
This option inserts a horizontal line in the center of the selected area of the report.
In the Query Chooser window, navigate to the name of the desired query, and then select it. Click Insert. (This option is not available when the cursor is in the header or footer area.)
If the query that you want is not available, you can use the Query Wizard on the Events page to create a query. See the section on managing event archives for more information.
Select the number of rows and columns, and then click OK. An empty grid appears in the selected area. You can select any section of the grid and insert text, images, and so on. You can also size any section of the grid by dragging the borders of the section.
This option subdivides the selected area by inserting a blank row. You can also size the row by dragging its borders.
This option subdivides the selected area by inserting a blank column. You can also size the column by dragging its borders.
When the cursor is in the header or footer area, you can select this option to toggle the header or footer on and off.
This option changes the orientation of the report to Portrait mode.
This option changes the orientation of the report to Landscape mode.
To create a custom report
If you insert a query, the available properties depend on whether the data displays as a graphical chart or as a table. If the query is graphical, you can select the type, for example, bar or pie. If the query is tabular, you can select the columns that you want to include in the table as well as the desired font and type size of the text.