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.

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.
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.
A: Yes. It is provided as pure PHP files you can add to your project. No command lines. No complex setup.
A: Yes, your license is valid for life for the specific version you purchased. To keep you updated, we provide:
  • Lifetime Access: Once purchased, you can use your specific version of Smart Report Maker indefinitely with no recurring subscription fees.
  • 6 Months Free Upgrades: Access to all new releases and patches.
  • Discounted Renewals: After 6 months, upgrade at 60% off or more.
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.
A: Yes. It includes security helpers for session-based login systems. Follow this tutorial for details.
A: Yes. Each user can see only their own records. This tutorial explains how.
A: Visit the examples section.
A: Yes. There are usually cross-product promotions between Smart Report Maker (SRM), Smart Form Maker (SFM), and Smart Report Engine (SRE). Currently, the discount is typically around 25%, but it may change over time. When purchasing any product, check the "We Also Recommend" section on the checkout page to see the latest discounts available on the other products.
More Examples