Administration Guide › Queries and Reports › How to Create a Report › Design Report Layout

Design Report Layout

You can design your report structure by specifying the grid size and dimensions and then selecting queries to display in each grid section. A report can contain either internal CA User Activity Reporting Module queries, or queries directed to an external ODBC database, but not both.

To design a report layout

1. Open the report design wizard. If this is a new report, enter a name, select a tag, and advance to the Layout step.
2. Select or enter the number of rows and columns you want to appear in your report, using the Grid Rows and Columns areas in the Report Layout pane. These settings control the number of query display areas the report contains. You can include up to ten rows and/or columns.

   The appropriate number of rows, columns, and corresponding query displays appears in the report layout pane.

   Note: You can use the arrows at the right side and bottom of individual query display areas to expand or shrink them horizontally or vertically.

3. (Optional) Enter or select a minimum pixel size for the query display areas in the Min. Width and Min. Height areas.
4. Drag the query you want to display in each display area from the Query List to the appropriate area in the report layout:
   • If you are creating a standard report, event and incident queries appear in the list.
   • If you are creating an ODBC report, queries that target the database you selected in the first wizard screen appear in the list.
5. (Optional) Click Edit at the top of each query display area to edit the query you have placed there or create a custom query.
6. Click Save and Close.

   The Report Design wizard closes. The new report appears in the Report List under the User folder.

More information:

Add Report Details