When you click on Server -> “Reporting” on the toolbar and then select “Edit Report Template”, you will see a list of all available report templates.
Select the report template you wish to edit and click “OK”.
You will now see the main view of Report Editor. On the left side you see a tree structure giving you access to the metadata/properties and the various chapters and sections in the report.
When the top node in the tree is selected you see 3 views on the left side, Properties, Appearance and Frontpage text as well as, the physical location of the report template file and where the automatic backups are placed.
In the Properties section, you can specify the report name, the default schedule, a short description, and the compatability for the report.
In the Appearance section you can specify a custom logo and company name for the report (which will appear on the frontpage of the report).
The “Hide databaselist” checkbox allows you to specify that the list of which database instances this report is generated for should not be shown. (This is normally page two of the report).
Format lets you choose the between PDF and HTML as the default format for this report.
And finally “Orientation” lets you specify if the report is in portrait or landscape mode by default.
Frontpage text is the text that will appear on the frontpage of the report.
A report can be divided into several chapters, each containing one or more sections.
When you click on a section, you can edit basic information like the title and a text that will appear at the start of the section. There is also a panel that lets you specify that this section should be a “Merged” section. (More on this later).
Each section defines an sql query that retrieves the data used to create a presentation.
The task editor allows you to execute the query to verify that it has the correct syntax and that it returns the data you expected.
When you click on Resultset you see a definition of the colums and datatypes the query produces. If this is empty, you can click on “Export to resultset” in the query view after you have generated a sample resultset by executing the query, and the resultset definition will be automatically genereated.
When you click on Presentation you can define how you want the result presented. The available presentation types are: Table, List, Category Chart – Series, Category Chart, Pie Chart and Dual Axis Chart