Create Custom Reports

The custom report is based on the settings from the audit view you created. Be sure your report server is already configured to be used with Auditor. For more information, please see Deploy Reports.

Set the Layout

You can customize the look of your reports, choosing color palettes, report logo, and report output sizes.

To set up the layout for a report:

  1. Open the Audit Viewer.

An image of Layout Theme on the Audit View screen in Auditor for SQL Server.

  1. Select an Audit View and click Layout Themes.
  1. Click the Themes tab.
  2. Click Create Theme link.
  3. On the Images page, click Add Custom Image to add your report logo. The maximum image size is 255x65 pixels.
  4. On the Colors page, select the color palette for your report display.
  5. Click Show Preview to see the changes in a demo report. You can have the Preview page open at the same time as you select colors from the palette to see the changes dynamically.
  6. Click the Layouts tab.
  7. Click the Create Layout link.
  8. On the General page, enter a name and description.
  9. On the Report Size page, click the Web Display tab to set online viewing properties.
  10. Select a screen size from the list.
  11. Alternatively, click the Show Advanced Options to set a custom size width and height for your display.
  12. Select the Print Display tab to set print viewing properties.
  13. On the Columns page, select the columns that you want to display in the report.

Publish the Report

  1. Select the Audit View and click Publish.
  2. The Custom SSRS Report Publisher dialog box opens.
  3. On the General page, enter a report name and description.
  4. Select the Sync with Audit View check box. Synchronize the audit view and the custom report to republish the report when the audit view data changes.
  5. Select a layout and theme if you created custom settings for the report properties. For more information, please see Set the Layout.
  1. On the Analytics page, select the graph data you want to see in the report.
  2. On the Overview page, select the report server.
  3. Click the Change Folder link to save the report to an alternate location.
  4. Select the Publish print report check box to publish the report to SSRS using the print sizes selected on the Layout page. Click the Change Folder link to set another location in SSRS (if needed).
  5. Click Publish.
  6. A message is displayed indicating the report is generated and available in SSRS.
  7. After the report is generated, click Open to view the report results in SSRS.