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
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;
}
}Benifits of Smart Report Engine
Easy PHP Reporting API
Generate MySQL reports from PHP code in minutes. Use a clean API that is easy to learn and fully documented. You can even include Smart Report Engine inside your own commercial products without any restrictions.
Flexible Reporting Framework
Build reports with methods you can extend, keeping full control inside your codebase. It is powerful and supports many reporting features such as grouping, filtering, sorting, appearance customization, and integration with your existing login system. You can also combine mobile-friendly reports in the same framework.
Save Development Time and Effort
Add reporting features faster and reduce debugging, maintenance, and custom report code. You can create many reports easily, just by calling the API.
Native PHP and Laravel Package
Each commercial license includes both options. Use the pure PHP engine or the Laravel package, whichever fits your project best.
Mobile-Friendly MySQL Reports
Set the layout to mobile and generate reports that work well on small screens, giving your users a smooth experience on any device.
Friendly Support
Get direct help from our experts. Submit tickets through our support system and get the answers you need.
Key Features of Smart Report Engine
Unlimited MySQL & MariaDB Reports
Create unlimited reports with multiple filter options. Choose columns, tables, views, or SQL queries, and add multi-level grouping such as region → country → city.
Parameterized Reports
Build reports with dynamic filters that adapt to user input. For example, let users pick a date range for a sales report and instantly see the matching data.
Filter by Logged-In User
Filter reports by the currently logged-in user so each person sees only their own records, keeping data private and relevant.
Login System Integration
Use built-in security functions to integrate with your login system. See the login integration tutorial to get started.
Subtotals and Grand Totals
Add subtotals and grand totals to your reports. Calculate sum, average, min, max, or count for groups and for the full report.
Calculated Columns
Create calculated columns that show values computed from other columns, without storing them in the database.
Conditional Formatting
Use conditional formatting to style cells based on their values. For example, show low stock in red to highlight what matters.
Rich Cell Customization
Customize cells with formatting options. Add flags, star ratings, labels, and multilingual output.
Layout and Style Control
Control the report layout and style. Add headers and footers to match your brand and deliver polished, professional reports.
Frequently Asked Questions
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 Engine 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.