Show/Hide Toolbars

Navigation: Using ASPRunnerPro > Reports

ASPrunnerPro32x32     ASPRunnerPro manual


Creating report and setting parameters

Scroll Prev Next More

 

To create a report:

1. Proceed to the Datasource tables page and click Create Report.

2. Select datasource table and report name. Click OK.

report_create

Note that you can create a copy of existing report (right-click the report and select Copy).

On the next several pages (use Next button to navigate) you can:

make necessary changes to SQL query. More info about editing SQL queries;

choose group fields and grouping types;

set report totals and layout.

Note that you can use reports as both master and details tables. For more information, see Master-details relationship between tables.

Report as details table:

report_as_details

Grouping fields in report

On the Report: Group fields page you can choose group fields, grouping types, what summary types to show etc.

The following picture explains how each option works.

report_parameters

If you clear the Show details and summary check box only summary will be shown on report page.

Besides standard intervals (new group starts when group field value changes) you can use other interval types. Available interval types are different for each data type.

Here is the example of text group field using first letter as an interval.

report_first_letter

Cross-tab reports

ASPRunnerPro supports cross-tab reports (often called pivot tables). On the Group fields screen you can choose two or more variables (columns) and assigned them to either X axis or to Y axis. You can assign more than one variable to the axis and switch between them in runtime.

crosstab_report_setup

On Report: Totals screen you can choose totals options like Min, Max, Sum and Average.

Here is how cross-tab reports looks in generated application. You can select variables, totals types and data fields to display.

crosstab_report_web