Logo
My activities

Create a Basic Custom Report

Using a previously saved query (or queries) from Analysis Expert, you can create custom reports that make it easy to review, print, save, and share important activity and incident information. 

Add Text & Images to the Report

  1. Log into Perspective.

  2. Click Analyze and Report > Custom Reports > Add.

  3. Enter a Report Name and Report Category.

  4. Optional: Enter a description in the Report Description field.

  5. Under Please select a query or queries for your report, select a query.

    To select multiple queries, press and hold the Ctrl key on your keyboard while using your mouse to select the queries.

  6. Click Design.

  7. Click Insert > Text. 

  8. Click and drag to select a text area. 

  9. Click the Text tab.

  10. Enter a title for the report in the text box.

  11. Click Insert. 

    If you need to edit the report title, click the  Undo icon, enter your changes then click Insert.

  12. Click OK.

  13. Use the settings in Font and Alignment from the Text tab to adjust the size, position, and appearance of the report title. 

  14. Complete steps 7-14 to add additional text (e.g. subtitles or company address). 

  15. Click Insert > Picture to add a company logo.

  16. Click and drag to select an area for the image. 

  17. Click File

  18. Navigate to the location of the file.

  19. Select the Embed image in project file checkbox to ensure other users will be able to view the image. 

  20. Click the image to select it then click Open.

  21. Click and drag the logo to reposition on the page as needed.

Note: Click the Preview tab at the bottom of the screen at any time to see a preview of your report.

Insert the Report Container

The Report Container is the object that will display the data in your report. Report Containers can hold tables, charts, and crosstabs. The steps below provide instructions for adding a table only.

  1. Click Insert > Report Container.

  2. Click and drag to select the area where you’d like the table to appear. 

  3. Click Table from the Choose Element Type window.

  4. Select the previously saved Analysis Expert query and click OK

  5. Expand the nodes in the Variables or fields that can be inserted section to reveal the variables or fields that can be added into the table as columns. 

  6. Double-click a field or variable to add it as a column.

  7. Click the  icon to remove a column or click the  icons to rearrange the columns.

  8. Click OK.

Configure Objects & Layers

  1. Ensure the Layout Preview tab is selected.

  2. Right-click an object and click Assign to Layer.

  3. Select First Page for objects that should appear on the cover page or select Following Pages for objects that should not appear on the cover page. 

  4. Click OK.

  5. Repeat steps 1-4 for each object.

  6. Click the Report Container object to select it.

  7. Scroll down in the Properties section to locate Pagebreak Before.

  8. Select Yes from the drop-down menu.

  9. Click a blank area within the report to show the General Settings in the Properties pane.

  10. In the Minimum Page Count field, delete 1 and enter 2

  11. Click the Preview tab to preview your report. 

  12. Click File > Save.

  13. Click the X in the upper-right corner to close Perspective Report Designer.

Your new custom report will now appear in the Custom Reports section of Analyze and Report. Click the Execute button to view the report.

 

See also:

Follow
Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request
Powered by Zendesk