Report Examples

report1.name = /My Reports/Entity Distribution by Criticality

 report1.target = DataSheet1!$A$1:$B$6

 report2.name = /My Reports/Entities with Lowest 10 Compliance Scores

report2.target = Dashboard!$B$31:$E$40

 report3.name = /My Reports/Entities with High Criticality

 report3.target = DataSheet2!$A:$G

In the first example above (report1), the summary report will populate a bounded range in DataSheet1 that will be used to generate a pie chart or bar chart in the dashboard. Note that the first row of a data sheet is reserved for column headers and the actual data will start with the second row. In addition, eventhough normally there will be only 5 or 6 possible values for entity criticality, it is not necessary to use a bounded range.

In the second example above (report2), the 10-row table in the dashboard would be populated by the report directly. Note that the range does not include the row for the column headers because it does not start with the first row.

In the third example above (report3), the report will put data into an unbounded range in DataSheet2. The dashboard creator does not know how many entities have high criticality. You do not want to limit the number of entities shown. In this case, the dashboard creator could create a viewport (a table with a fixed size) in the dashboard and use a VBScript to page through the data in DataSheet2 interactively.