|
To create a report:
1. Proceed to the Datasource
tables page and click Add
Report button.
2. Select datasource table and report name. Click OK.
On the next several pages (use Next button to navigate) you can:
|
·
|
make necessary changes to SQL query. More info about editing
SQL queries; |
Grouping
fields in report
On the Report: Group
fields page you can choose group fields, grouping types,
what summary types to show etc.
You can choose between standard and cross-tab reports.
Standard reports
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.
Cross-tab
reports
PHPRunner6.0 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.
|
