Please enable JavaScript to view this site.

Navigation: Using ASPRunnerPro > Reports

Creating and configuring reports

Scroll Prev Next More

Creating a report

To create a report:

 

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

 

2. Select the table, type in the report name, and click OK.

report_create

 

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

 

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

 

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

choose group fields and grouping types;

set up the report totals and layout.

 

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

 

A report as a details table:

report_as_details

Group fields

On the Report: Group fields screen you can select the group fields, grouping intervals, and summary types.

 

You can choose between standard and cross-tab reports.

Standard reports

report_parameters

 

Clear the Show details and summary checkbox to make the report page show only the summary.

 

You can choose the Interval for the group field. Available interval types are different for each type of data.

 

Here is an example of a report with a text group field using the 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 assign them to the X or Y-axis. You can assign more than one variable to the axis and switch between them in the generated report.

crosstab_report_setup

 

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

 

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

crosstab_report_web

See also:

Report totals and layout

Datasource tables

Master-details relationship between tables

SQL query screen

Creating charts

Creating dashboards