On the Report Totals page you can choose what fields to display on the report/search pages.

Also you can apply aggregate functions like MIN, MAX, SUM and AVERAGE. The results of these calculations will be displayed after each group and at the end of page/report.

The Report: Miscellaneous page allows you to choose report layout. If you use grouping you can choose between Stepped, Block, Outline and Align layouts. If you don't use grouping you can only use Tabular layout which is very similar to the basic List page.

You can also change the way your data is sorted. Note that you can only control data sort order inside the group, as groups are sorted by Group fields.

Number of lines per page option determines where to insert the page break, when you print the whole report.

Additional info on reports setup

If you need to display a value from a lookup table instead of ID on the Report page, you have two options:

1. Modify SQL query to include fields from joined tables.

2. Enable report search page, proceed to Visual Editor, open Search page, double-click the field and make it Lookup Wizard.

Either option allows you to display a value from another table on the Report page (i.e. Customer Name instead of Customer ID).