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.
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.
A report as a details table:
On the Report: Group fields screen you can select the group fields, grouping intervals, and summary types.
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:
PHPRunner 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.
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.