Building PHP/MySQL reports with PHPRunner

PHPRunner is a low-code web application builder that lets you create database-driven reports as part of your web applications. Reports can present data in detailed or grouped formats, calculate subtotals and totals automatically, and use data from single-table or multi-table queries. Users can also search and filter report data.

Want to build reports from your own database? PHPRunner lets you create reports visually and include them as part of a complete web application. Learn more about PHPRunner.

Grouped reports

Reports are often used to represent data in a grouped, hierarchical format. On the Group Fields tab you can choose group fields, grouping types, and the summaries to display. You can show both details and summaries, or display only a summary on the report page.

Besides standard grouping, where a new group starts when the group field value changes, PHPRunner supports additional interval types depending on the field type. For example, a text field can be grouped by its first letter.

Totals and summary calculations

On the Report Totals tab you can choose which fields to display and apply aggregate functions such as MIN, MAX, SUM, and AVERAGE. The calculated values can be displayed after each group and at the end of the page or report.

Pivot and cross-tab reports

Sometimes report data is easier to analyze when values are reorganized across rows and columns. PHPRunner can create pivot or cross-tab reports that summarize and present database data in this format.

Build reports as part of your own web application with PHPRunner. Try PHPRunner free.