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.
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;
}
}
|
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
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.
Frequently Asked Questions (FAQ)
Q: What is the difference between Smart Report Maker and Smart Report Engine?
A: The difference between Smart Report Maker and Smart Report Engine is that Smart Report Maker is a complete product for creating professional reports, charts, dashboards, drill-down charts, and KPIs using an easy-to-use interface, while Smart Report Engine is a reporting engine that PHP developers can integrate into their projects to generate reports by calling its API within their code.
Q: Is Smart Report Engine easy to install in my PHP project?
A: Yes. Smart Report Engine is provided as pure PHP files that can be easily added to your project. No command lines, no complex installation steps, and no special setup are required.
Q: What can Smart Report Engine do for my project as a PHP developer?
A: Smart Report Engine allows you to generate professional reports programmatically from your MySQL or MariaDB data by calling a developer-friendly PHP API inside your codebase (native PHP or Laravel). This helps you add reporting features faster, reduce development time, and deliver polished, feature-rich reports inside your application.
Q: Can Smart Report Engine be integrated with my existing login system?
A: Yes. Smart Report Engine provides security functions that can be integrated with your project’s existing login system. You can follow this tutorial for detail.
Q: Can I filter a report based on the currently logged-in user using Smart Report Engine?
A: Yes. Smart Report Engine supports filtering reports by the currently logged-in user so each user sees only their own records. This tutorial explains how
Q: Where can I find tutorials and examples for Smart Report Engine?
A: You can find tutorials and working examples for Smart Report Engine in the tutorials section
Q: If I purchase Smart Report Maker, can I get a discount on Smart Report Engine if I need both?
A: Yes. There is usually a cross-product promotion between Smart Report Maker (SRM) and Smart Report Engine (SRE). Currently, the discount is typically around 25%, but it may change over time. When purchasing, check the “We Also Recommend” section on the checkout page to see the current discounts available on other products.
