MENU
MySQL Reports

Products

Powerful PHP Reporting Library for MYSQL

The Smart Report Engine, a PHP reporting library, empowers developers to programmatically generate polished reports directly from MYSQL or MariaDB within their codebase. By integrating Smart Report Engine into your PHP project (either native PHP or Laravel), you unlock the capability to provide your users with the functionality to create professional reports enriched with advanced features. These encompass grouping, filtering, conditional formatting, appearance customization, security options, exporting capabilities, and beyond.

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

What makes Smart Report Engine a Proficient PHP Reporting Library?

Easy-To-Use Reporting Library in PHP

With its user-friendly API, Smart Report Engine allows you to effortlessly generate professional reports from your PHP code in a matter of moments.

Robust PHP Reporting Framework

Smart Report Engine offers extensive methods that you can easily manage and expand directly from your code.

Reduce Development Time

Smart Report Engine reduces development time by generating fully functional reports, which can save numerous hours of development, debugging, and maintenance.

Native PHP & Laravel

Each Smart Report Engine commercial license provides you with access to the product as both a native PHP engine and a Laravel package.

Mobile Friendly Reports

By setting the report's layout property to "mobile," you can swiftly generate mobile-friendly reports using this sturdy reporting framework.

Friendly Support Service

Our customers receive personalized and professional support from our experts by creating tickets through our support system
Documentation More Examples

Key Features of Smart Report Engine

  • Smart Report Engine allows you to create an unlimited number of reports for MYSQL and MariaDB databases with a wide range of data filtration methods. You can choose to select some or all columns of your MYSQL table, as well as single or multiple tables, views, or SQL queries as the data source for each report. The framework also supports multiple grouping levels, which enables you to generate more informative reports, such as grouping a sales report by region, country, and city.
 
  • Smart Report Engine offers dynamic filter functions, which are filtration functions that enable the creation of parameterized reports. These functions allow you to create, for instance, a sales report by date range where each user can define the date range they want to see with ease.
 
  • With Smart Report Engine, you can apply a data filtration function to filter reports by the currently logged-in user. This function ensures that each user sees only their records when multiple users access the same report.
   
  • With Smart Report Engine, you can add subtotals and grand totals to your generated report. This feature enables the addition of subtotals to your report to obtain the sum, average, minimum, maximum, or count of any column(s) for each group of records. Furthermore, at the end of the report, grand totals can be listed.
 
  • Using Smart Report Engine, you can generate reports that include calculated columns. These virtual columns are not stored physically in your database table but instead are calculated from one or more other columns.
 
  • Various conditional formatting methods are supported, enabling you to modify the appearance of any cell in your report based on its value. For example, you can display the available stock of a specific item in red font only when its quantity is lower than a certain number.
 
  • Many cell formatting functions are also supported in Smart Report Engine, which can help you customize the appearance of your cells. You can display all countries in your report with their flags or all rating numbers as star ratings, for instance. Additionally, you can label your columns and generate multilingual reports with ease.
 
  • Smart Report Engine further provides the option to choose the style and layout of your report and to add headers and footers to customize the appearance of your reports.
Documentation More Examples