On this page, you can specify options to generate the report layout.
- Check the tick-box beside the view name under Select queries for the report and it’s detail Reports.
- Choose data fields from the Dataset View in the Select data fields to display in the report to display them in the report.
If you do not need group fields and/or display summaries you can click Next to Specify Page Settings or Finish to display the report with default page settings and the resulting report will look as follows:
Table Report with no Group Summaries:
Vertical Report with no Group Summaries:
Add Group Fields
To group your data by one of the selected fields from the Dataset View, click Add Group and select data fields in the drop-down list.:
Use the arrow buttons to change the group order if you have added more than one level of grouping to the report. The following image demonstrates grouping types:
You can stop the wizard at this step and get the report layout similar to the image below.
Table Report with Grouping:
Vertical Report with Grouping:
Add Summary Fields
To add a summary, select a data field (Numeric, Datetime or Boolean) and the summary function desired.
- Table Reports display summaries in the Report Footer and Group Footers.
- Vertical Reports display summaries in the Vertical Total band.
Select the Ignore null values checkbox to not take data fields’ empty values into account. Otherwise, these values are treated as zeros for numeric and Boolean fields and the earliest system date is used for date-time fields.
Table Report with Group Summary:
Vertical Report with Group Summary: