Build PHP and MySQL Reports with PHPRunner

PHPRunner is commercial application-building software with a full-featured 21-day free trial. It can create grouped, summary, and pivot reports from MySQL data, including reports based on queries that combine more than one table.

Want to build reports from your own database? Start the full-featured 21-day PHPRunner trial.

How to create a MySQL report in PHPRunner

  1. Connect PHPRunner to the MySQL database.
  2. Select a table or create a query for the data the report should use.
  3. Create a report for that data source.
  4. Choose grouping fields and configure subtotals, totals, and the report layout.
  5. Preview the report, then publish the application to your web server.

See the official documentation for detailed steps: Creating and configuring reports in PHPRunner.

Grouped MySQL orders report showing order details and summary totals

Grouped reports

Group records by one or more fields so readers can move from a summary to the underlying detail. For example, an orders report can group sales by customer, salesperson, region, or month.

PHPRunner report grouping records by the first letter of a field

Totals and summary calculations

Add subtotals for each group and totals for the complete report. PHPRunner can calculate values such as sums, counts, minimums, maximums, and averages without requiring a separate hand-coded reporting page.

MySQL summary report with grouped subtotals and a grand total

Pivot and cross-tab reports

Use a cross-tab report when the reader needs to compare one category against another, such as monthly sales by product or orders by region and status. Rows and columns summarize the selected dimensions while the cells display the calculated values.

Cross-tab report comparing summarized values across rows and columns

Learn how to improve report and dashboard performance as datasets and usage grow.

Build reports from your own MySQL database. Try PHPRunner free for 21 days.