Show/Hide Toolbars

Navigation: Using PHPRunner > Reports

PHPrunner32x32     PHPRunner manual

Creating report and setting parameters

Scroll Prev Next More


Quick jump

Grouping fields in report



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:


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

PHPRunner 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.