Introduction

This article explains how to adapt a graphical report so that it displays less data on a single page. 

Overview

The graphical reports are a great way for representing data in a form that can easily be understood. When a report is run, it will display whatever data has been filtered in the main grid. If you have no filters active, then the report will try and load all data from the workspace. This may not always have the desired end effect if you have a large number of records to display.

One option for reducing the amount of records in the report is to filter on a smaller time frame or filtering out records based on some other criteria. 

Filtering History Records

To filter only history records, open the Filter Manager and create a new filter (right click » New Filter). Click on the text tab and paste the following code:

[Entry Type] In ('Archived', 'History', 'Master', 'Daily', 'Weekly')

Provide a name for the filter and save it. When this filter is run, only history records will be shown. You can then run the Template by Host report. 

If this still results in too many entries per page, we can make some adjustments to the actual report.

Editing the Report

Open the report and click on the scripts tab. You should see the following code:

This C# code contains the parameters which are run before the report prints. Changing the values in this function will change the way the report is displayed. Try changing the height value for the code on line 30 to the following:

ChartVisitsByHost.Height = 20200;

This line changes the height of the report when there are more than 400 records.