Show/Hide Toolbars

Navigation: Using ASPRunnerPro > Reports

PHPrunner32x32     ASPRunnerPro manual


Report totals and layout

Scroll Prev Next More

Report: Totals

On the Report: Totals screen, you can choose the fields to display on the report/search pages.

report_totals

 

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.

report_aggregate_functions

Report: Miscellaneous

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.

report_misc

 

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:

report_misc_settings

 

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.

Displaying lookup values in reports

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).