On the Report: Totals screen, you can choose the fields to display on the report/search pages.
You can also apply the aggregate functions like MIN, MAX, SUM, and AVERAGE. The results of these calculations are displayed after each group and at the end of the page/report.
The Report: Miscellaneous screen allows you to select the layout of the report. If you use grouping, you can choose between Stepped, Block, Outline, and Align layouts.
If you don't use grouping, you can only use the Tabular layout, which is similar to the basic List page.
Use the Printer-friendly page and PDF View options to make the report printer and PDF friendly. Click the Settings button to configure these options:
•Fit to page width/Scale. You can choose to fit the report to page width or to scale it to a set percentage.
•Orientation. Select the portrait or landscape orientation for the report pages.
•The Display N groups per page option determines where to insert the page break when you print the whole report.
If you need to display a value from a lookup table instead of the ID on the Report page, you have two options:
1. Modify the SQL query to include the fields from joined tables.
2. Enable the report search page, proceed to the Editor screen, open the Search page, double-click the field and turn it into a Lookup Wizard.
Either option allows you to display values from another table on the Report page (i.e., a Customer Name instead of a Customer ID).