Please enable JavaScript to view this site.

Navigation: Using PHPRunner > 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.



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:


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



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:


Cross-tab reports

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.


See also:

Report totals and layout

Datasource tables

Master-details relationship between tables

SQL query screen

Creating charts

Creating dashboards


Created with Help+Manual 7 and styled with Premium Pack Version 3 © by EC Software