MENU
MySQL Reports

Products

The Ultimate MySQL Report Builder and PHP Dashboards Tool

Smart Report Maker (SRM) is an advanced PHP-based report builder and PHP dashboard tool for MySQL and MariaDB, supporting powerful features such as dynamic PHP dashboards, interactive pivot tables, scheduled reports, advanced charts, KPI monitoring, and more. SRM also introduces report relationships, allowing you to link reports together and build intelligent report networks for drill-down analysis and contextual insights across multiple datasets. To extend reports beyond SRM itself, the built-in Embed Manager enables you to securely embed reports, dashboards, KPIs, and other analytical resources into your own web applications, including WordPress through the integrated WordPress reports plugin. Whether you're creating detailed reports, tracking KPIs, or uncovering trends from historical data, SRM empowers you to transform raw MySQL data into professional, interactive analytics with full control, flexibility, and security.
PHP dashboard generated by Smart Report Maker

Try Demo Version Purchase


Transform your MySQL or MariaDB databases into powerful reports, charts, KPIs, dashboards and Pivot tables with actionable insights.

Smart Report Maker (SRM) empowers business teams to explore and answer their own data questions — no coding required! It delivers clarity and precision when analyzing data from MySQL and MariaDB databases. With a powerful suite of data analysis features, SRM helps you uncover valuable insights, monitor trends, and make informed decisions. Whether you're generating detailed reports or building PHP dashboards, SRM equips you with all the tools needed to effectively visualize and understand your data.
Smart Report Maker enables you to build PHP dashboards, reports, charts, pivot tables from your MYSQL and MariaDB databases.
The analytics capabilities of Smart Report Maker include date-series charts, comparative KPI tracking, MySQL and MariaDB pivot tables, and customizable PHP dashboards that display key metrics in a way that suits your needs. Whether you're exploring trends over time, comparing performance to previous periods, or drilling into specific datasets, SRM provides the flexibility and depth required to support comprehensive data analysis. Built for both technical and non-technical users, SRM ensures that transforming your MySQL and MariaDB data into actionable insights is straightforward and efficient.

Main features of Smart Report Maker


Easy-to-Use PHP Report Builder for MySQL and MariaDB


Smart Report Maker is the ultimate MySQL and MariaDB Report Builder, designed to generate reports directly from your MySQL and MariaDB databases. With its intuitive wizard-style interface, the tool makes report creation simple and accessible to everyone, allowing users to transform their data into meaningful insights effortlessly. Learn more about the PHP Report Builder Module in SRM.



Create Report Chains with Linked Reports


Reports no longer stand alone. You can now connect them by passing parameters and building report chains — even long, multi-step ones. This allows users to explore their data gradually, moving from one level to the next instead of viewing everything in a single flat report. Learn more about Report Relationships and Linking in SRM

A dedicated WordPress reports plugin is included to help you effortlessly embed reports, dashboards, and analytics into your WordPress site.


The Smart Report Maker Embed WordPress Plugin is a powerful WordPress reports plugin that lets you seamlessly embed dashboards, reports, charts, KPIs, and pivot tables—generated in Smart Report Maker from your MySQL or MariaDB databases—directly into your WordPress site while preserving full interactivity and control. Your users can drill down, filter, and export data right from your WordPress pages, while you remain in complete control of every detail. Find out more about the SRM WordPress Reports plugin


An Embed Manager to Easily and Securely Embed Reports and Dashboards in Your Own PHP Apps


The Smart Report Maker Embed Manager allows you to easily embed dashboards, reports, charts, KPIs, and pivot tables—built in SRM from your MySQL databases—directly into any PHP-based application. It provides secure, code-free embedding while maintaining full interactivity. Your users can drill down, filter information, and export results right from within your application. Learn more about Embedded Reports, Dashboards, and Analytics with the Embed Manager in SRM


MySQL and MariaDB Pivot Tables — No Code, Just Drag and Drop


Smart Report Maker includes a powerful module for creating MySQL and MariaDB pivot tables using an incredibly easy-to-use drag-and-drop editor. This module is designed to save you time and effort while giving you full flexibility. Whether you need to summarize sales data, analyze user activity, or break down performance by category, the pivot table builder helps you do it all — without writing a single line of SQL. Learn more about the Drag-and-Drop MySQL Pivot Table Builder in SRM



PHP Dashboards for MySQL and MariaDB


Smart Report Maker (SRM) provides fully customizable PHP Dashboards for MySQL and MariaDB, empowering users to monitor their data visually in real time. Dashboards are invaluable for decision-making, offering a centralized view of critical metrics, trends, and performance indicators. By consolidating key insights into one place, SRM dashboards enable decision-makers to quickly identify trends, track progress, and take informed actions. Learn more about the PHP MYSQL Dashboard Builder in SRM

php Dashboard generated by SRM


Advanced and Interactive PHP Charts for MySQL and MariaDB


Smart Report Maker simplifies data visualization with its robust PHP MySQL Chart Builder, making it easy to create professional and insightful PHP charts directly from your MySQL and MariaDB databases. Learn more about the PHP chart Builder for MySQL in SRM

Advanced PHP Charts for MySQL and MariaDB

Scheduled Reports via Email


Scheduled Reporting in Smart Report Maker automates generating reports from any MySQL and MariaDB databases and delivering them to designated recipients at specific times, such as daily, weekly, or monthly, eliminating manual effort and ensuring timely access to essential data.
  • Custom Schedules
    Set up flexible delivery schedules to automatically generate and email reports daily, weekly, or monthly. Define specific times for delivery to ensure reports arrive exactly when needed.
  • Multiple Formats and Recipients
    Configure reports to be emailed to specific individuals or groups in formats such as PDF, making them easy to access and share.
  • Timely Delivery of Reports
    Ensure teams and stakeholders consistently receive up-to-date reports on schedule, whether it’s a daily update or a monthly performance summary.

KPI and Metrics Monitoring


Smart Report Maker enables businesses to track performance and monitor progress effectively with tailored Key Performance Indicators (KPIs) and metrics derived directly from the stored data in your MySQL or MariaDB databases. These KPIs can be filtered based on specific timeframes, such as data from the last month, last quarter, this week, or any custom-defined range, allowing users to focus on the most relevant data for their analysis.
  • Custom Metrics Aligned with Business Objectives
    Define KPIs based on your specific business goals. For example, track total sales, unique customer counts, or the number of transactions meeting a particular condition.
  • Comparative Insights with Historical Data
Gain deeper insights by comparing KPIs against:
      • The Same Time Last Year
        Compare performance during a similar period in the previous year, such as sales in Q1 of this year versus Q1 of last year.
      • The Preceding Period
        Analyze changes between consecutive periods, such as this quarter versus the previous quarter.
      • Fixed Targets
        Measure progress toward predefined goals or benchmarks, providing clarity on whether targets have been met or exceeded.
    • Conditional Functions for Advanced Calculations
Smart Report Maker allows you to create KPIs and metrics using powerful conditional functions that let you calculate values based on specific criteria. For example, you can count all entries, count unique values (distinct), or count only those entries that meet a particular condition, such as orders exceeding $100. Similarly, you can apply conditions to other functions, such as summing the revenue from high-value transactions, calculating the maximum sale amount in a specific category, or determining the average order value for a particular region. These conditional calculations give you the flexibility to tailor metrics to your unique business needs, providing deeper insights and precise measurements for decision-making.
    • Versatile Display Formats for KPIs
KPIs can be displayed in multiple formats to suit your needs, including:
    • Compact Currency
      Show financial data in abbreviated forms (e.g., $1.2K).
    • Standard Currency
      Display full financial values (e.g., $1,200)
    • Percentage
      Represent data as percentages, useful for metrics like growth rates or proportions.
    • Custom Units
      Add custom units to KPIs, such as "Kg" for weight or "Hours" for time.
    • Percentage of Total Column
      Easily calculate and display data as a percentage of the total for a given column, providing insights into proportions and contributions (e.g., Percentage of female employees relative to total employees)
  • Versatile KPI Display Formats
    Present KPIs in visually appealing ways, such as info boxes, gauge charts, or trend charts, making it easier to interpret data at a glance.
  • Filter Options for Relevant Data
    Apply filters to focus on specific timeframes or conditions, such as KPIs for a specific month, quarter, or week, ensuring the displayed data is always relevant to your analysis.

Comprehensive PHP Data Analysis for MySQL and MariaDB


SRM is a powerful PHP data analysis tool for MySQL and MariaDB that delivers advanced capabilities to uncover insights and trends. It lets you drill down into detailed data from reports, charts, and KPIs, visualize patterns over time with time-series charts, and compare current metrics to past periods or targets. You can automatically generate subtotals and grand totals, apply dynamic or static filters to focus on specific conditions, and even create calculated columns for custom metrics — all designed to help you turn raw data into actionable intelligence. Learn more about the MySQL Data Analysis in SRM.

Effortless Exporting, Sharing, and Printing


Smart Report Maker makes it easy to share insights and resources across various formats and platforms:
  • Export in Multiple Formats
    Export reports, charts, KPIs, and their drill-down views in formats like PDF, CSV, or XML for seamless distribution and documentation.
  • Printer-Friendly Layouts
    Generate optimized layouts for printing, ensuring that reports, charts, and KPIs are presented clearly in physical formats.
  • Sharing Public Resources
    Share public resources, such as reports, charts, and KPIs, outside the system by embedding them in external webpages or platforms, making them accessible to a wider audience without requiring authentication.
 

Enhanced Security and User Management


Smart Report Maker provides comprehensive tools to control access and secure your data, ensuring that resources are only accessible to authorized users.
  • Role-Based Permissions
    Assign roles to define who can view, edit, or create resources such as reports, charts, and KPIs. Permissions can be set at a granular level, determining exactly what actions users can perform.
  • Group Management
    Group users together and assign specific permissions to each group. Groups can control access to resources, such as defining whether users can view, add, or edit reports, charts, or KPIs. This makes it easy to manage permissions for large teams or organizations.
  • User Subscriptions
    Manage whether individual users are subscribed to access the system, providing additional control over who can log in and interact with resources.
  • Public and Private Resources
    • Public Resources
      Create resources that can be accessed by anyone, even without authentication, making them ideal for embedding charts, reports, or KPIs into external webpages or public-facing platforms.
    • Private Resources
      Restrict access to specific groups, ensuring that sensitive resources are only accessible to authorized users. Permissions for private resources are strictly defined by the group they belong to.
  • Admin Privileges
    Admins have full visibility and control, with access to all resources in the system. Regular users can only see and interact with resources their group has permission to access.
 

Quick and Easy Setup with Support for cPanel, Plesk & CWP


Unlike many similar tools that require command-line access, Docker, or complex server configuration, Smart Report Maker introduces a brand-new installation method starting with version 11.0. This method requires no command-line usage and no complex setup—you simply upload the package and launch a web-based installer directly from your browser. This new approach, called Direct Upload of the Pre-Installed Package , was introduced in response to extensive customer feedback and is now the recommended, easiest, and fastest way to install Smart Report Maker.

Direct Upload Installation Method — Fast, Simple, and Hassle-Free
  • ✅ Simply upload the files, launch the web installer in your browser, and it works out of the box.
  • ✅ No terminal required.
  • ✅ No shell commands.
  • ✅ No server or DevOps expertise required.
  • ✅ Open-source PHP code — you can view and inspect the files.
You simply upload Smart Report Maker to your website, open a web-based installer in your browser, and complete the setup in just a few clicks. The Direct Upload method works perfectly with: Shared hosting or dedicated servers Any Operating system (windows or Linux)  Any control panel, including cPanel, Plesk, or others As long as your hosting supports PHP, Smart Report Maker can be installed easily, transparently, and reliably.

 

Comprehensive Documentation and Support


Smart Report Maker provides a robust set of resources and assistance to ensure you get the most out of the system, whether you're setting it up or managing it long-term:
  • Clear Documentation
    Access detailed, step-by-step documentation that covers everything from installation to advanced features, making it easy to use and configure SRM.
  • Friendly Free Support
    Enjoy free, friendly support through our ticketing system. Our team is ready to assist with any issues or questions to ensure your experience is smooth and successful.
  • Free Upgrade Period
    Receive free upgrades for six months after purchase, ensuring you have access to the latest features and enhancements. After this period, enjoy significant discounts on new versions to keep your system up-to-date.
  • No Renewal Payments
    With a one-time payment model, there are no recurring fees. The system will run securely on your own server, ensuring complete ownership and cost-efficiency.

Frequently Asked Questions (FAQ)

Q: Why should I choose Smart Report Maker as my PHP reporting tool for MySQL and MariaDB?

A: Smart Report Maker is a powerful PHP reporting tool that has been on the market since 2007 and is trusted by thousands of users worldwide. It allows you to create reports, charts, pivot tables, KPIs, and PHP dashboards from any MySQL or MariaDB database without writing code. The tool is easy to install using a web-based installer that runs directly from your browser, works smoothly on shared hosting, VPS, and dedicated servers, and runs entirely on your own server for full data privacy. Smart Report Maker is available with a one-time payment model—no subscriptions and no hidden fees—and generated reports and PHP dashboards can be easily and securely embedded into PHP applications and WordPress websites. For more details on why to choose Smart Report Maker, please click here

Q: Can Smart Report Maker be used by non-technical users without coding experience?

A: Yes, Smart Report Maker is designed for both technical and non-technical users. Its intuitive, wizard-based interface allows business users, analysts, and managers to build reports, PHP dashboards, charts, pivot tables, and KPIs without writing SQL or PHP code. Additionally, unlike many similar tools that require command-line access or complex server configuration, Smart Report Maker uses a web-based installer that runs directly from your browser, making both installation and daily usage simple, fast, and accessible for everyone.

Q: Does Smart Report Maker work with cPanel, Plesk, and other hosting control panels?

A: Yes, you can use SRM with hosting control panels such as cPanel, Plesk, CWP, DirectAdmin, Webmin, Virtualmin, ISPConfig, CyberPanel, HestiaCP, CloudPanel, VestaCP, or any other control panel that supports PHP hosting.

Q: Can I automatically schedule reports to be sent to my end users on a daily, weekly, or monthly basis?

A: Yes. Smart Report Maker (SRM) includes powerful scheduled reporting that automates both report generation and delivery—so your end users receive the right reports at the right time without any manual effort. With SRM, you can:

  • Set custom schedules – Automatically generate and send reports daily, weekly, or monthly, with full control over the delivery time.
  • Email reports automatically – Deliver reports directly to designated individuals or groups via email.
  • Choose output formats – Send reports in formats such as PDF, making them easy to view, download, and share.
  • Ensure timely access to data – Keep teams and stakeholders consistently informed with up-to-date data, whether it’s a daily operational report or a monthly performance summary.
Scheduled reporting works with any MySQL or MariaDB database, helping you eliminate repetitive manual tasks while ensuring reliable and timely data delivery.

Q: Can I display barcodes, Google Maps, QR codes, images, and rich visual elements inside my reports?

A: Yes. Smart Report Maker (SRM) allows you to transform raw data into rich, visual report cells without custom coding. You can display and format many data types directly inside your reports, including:

  • Barcodes – Generate and display barcodes directly from your data for tracking and inventory use cases.
  • QR Codes – Automatically convert values into QR codes for quick access, sharing, or scanning.
  • Google Maps – Visualize geographic data by displaying interactive Google Maps directly within report cells.
  • Images – Display image URLs as actual thumbnails (e.g., product photos).
  • Checkboxes – Represent Boolean values (true/false) as checked or unchecked boxes.
  • Star Ratings – Show numeric ratings (e.g., 4/5) as visual star indicators.
  • Country Flags – Convert country codes into recognizable flag icons.
  • Clickable Links – Turn URLs or email addresses into interactive hyperlinks.
  • Financial Cells – Format numeric values as currencies, percentages, or accounting-style figures with proper symbols and alignment.
All of these options can be configured visually inside SRM, allowing you to create professional, interactive, and presentation-ready reports directly from your database.

Q: Can report linking be used to navigate from customers to their accounts and invoices?

A: Yes. You can link a single Customers Report to multiple related reports. For example, the customer report can be linked to an Accounts Report to view each customer’s balance, and also to an Invoices Report to display all invoices for that customer. From there, users can drill down further into invoice details or any other relevant reports you choose. Learn more about report linking here.

Q: Can I embed Smart Report Maker reports and dashboards into my own PHP applications or WordPress site?

A: Yes, Smart Report Maker includes a built-in Embed Manager and a dedicated WordPress plugin that allow you to securely embed reports, PHP dashboards, charts, KPIs, and pivot tables into PHP applications and WordPress websites. Embedded content remains fully interactive, supporting filtering, drill-down, and exporting, while maintaining full control and security.

Q: How can I see Smart Report Maker in action before purchasing?

A: You can explore Smart Report Maker through our online demo and video tutorials , which showcase real reports, PHP dashboards, pivot tables, KPIs, and drill-down features in action. These resources help you understand how SRM works in real-world scenarios and what you can build with it before making a decision.

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 there a promotion if I purchase Smart Report Maker? Can I get a discount on Smart Form Maker and Smart Report Engine?

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.

Try Demo Version