To create a report:
1. Proceed to the Datasource tables page and click Create Report.
2. Select datasource table and report name. Click OK.
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:
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.
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.
ASPRunner.NET 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.
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.