MENU
MySQL Reports

Products

Powerful PHP Reporting Library for MySQL

Smart Report Engine is a PHP reporting library for MySQL and MariaDB. It helps developers generate polished reports directly from code. Use it in native PHP or Laravel.

With Smart Report Engine, you can add reporting inside your app. Your users get professional reports with key features like grouping, filters, totals, and export. You can also control formatting, layout, and security.

Report generated by Smart Report Engine

Quick Code Example

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
use Sre\SmartReportEngine\src\CustomEngine;
use Sre\SmartReportEngine\src\ReportOptions;
class ReportService {
public function generatePublicReport()
{
$report = new ReportOptions('PUBLIC_REPORT');
$report->select_tables(array("items"))
->set_grouping(array("country"))
->set_layout("OUTLINE")
->select_all_fields();
$engine = new CustomEngine($report);
$report_path = $engine->create_report();
return $report_path;
}
}
Generate Report More Examples

Why Smart Report Engine is a Powerful PHP Reporting Library

Easy PHP Reporting API

Generate MySQL reports from PHP code in minutes. Use a clean API that is easy to learn.

Flexible Reporting Framework

Build reports with methods you can extend. Keep full control inside your codebase.

Save Development Time

Add reporting features faster. Reduce debugging, maintenance, and custom report code.

Native PHP and Laravel Package

Each commercial license includes both options. Use the pure PHP engine or the Laravel package.

Mobile-Friendly MySQL Reports

Set the layout to mobile. Generate reports that work well on small screens.

Friendly Support

Get direct help from our experts. Submit tickets through our support system.

More Examples

Key Features of Smart Report Engine

  • Create unlimited MySQL and MariaDB reports with multiple filter options. Choose columns, tables, views, or SQL queries. Add multi-level grouping (for example: region → country → city).
  • Build parameterized reports with dynamic filters. Example: let users pick a date range for a sales report.
  • Filter reports by the currently logged-in user. Each user sees only their own records.
  • Use built-in security functions to integrate with your login system. See the login integration tutorial.
  • Add subtotals and grand totals. Calculate sum, average, min, max, or count for groups and for the full report.
  • Create calculated columns. Show values computed from other columns without storing them in the database.
  • Use conditional formatting to style cells based on values. Example: show low stock in red.
  • Customize cells with formatting options. Add flags, star ratings, labels, and multilingual output.
  • Control the report layout and style. Add headers and footers to match your brand.

Frequently Asked Questions (FAQ)

Q: What is the difference between Smart Report Maker and Smart Report Engine?

A: Smart Report Maker is a complete reporting product. It includes reports, charts, dashboards, drill-down, and KPIs. Smart Report Engine is a PHP reporting engine. Developers integrate it into PHP or Laravel and generate reports by API.

Q: Is Smart Report Engine easy to install in my PHP project?

A: Yes. It is provided as pure PHP files you can add to your project. No command lines. No complex setup.

Q: What can Smart Report Engine do for me as a PHP developer?

A: It adds MySQL reporting inside your application. You generate professional reports from code (PHP or Laravel). This helps you ship reporting faster and reduce custom development.

Q: Can Smart Report Engine integrate with my login system?

A: Yes. It includes security helpers for session-based login systems. Follow this tutorial for details.

Q: Can I filter reports by the currently logged-in user?

A: Yes. Each user can see only their own records. This tutorial explains how.

Q: Where can I find tutorials and examples?

A: Visit the examples and tutorials section.

Q: If I buy Smart Report Maker, can I get a discount on Smart Report Engine?

A: Yes. There is usually a cross-product promotion between SRM and SRE. The discount is often around 25%, but it may change. Check the “We Also Recommend” section on the checkout page for current offers.

More Examples