# Consolidated Markdown for https://mysqlreports.com/

Generated at: 2026-01-26 08:28:37

---

## Page: https://mysqlreports.com

# Web Report Tools by Webuccino

## Overview

Webuccino has been creating user-friendly reporting tools since 2007. The suite includes advanced PHP-based solutions for MySQL that enable users to generate professional reports, dashboards, KPIs, pivot tables, charts, and scheduled reporting, all with minimal coding. The tools support seamless integration with WordPress, PHP applications, and allow for secure embedding and data analysis.

---

## Products

### 1. **Smart Report Maker**
- An all-in-one PHP report builder for MySQL.
- Features:
  - No-code report and dashboard creation.
  - Support for scheduled reports (PDF, email delivery).
  - Data analysis with drill-down and linking.
  - Embedding into WordPress via plugin.
  - Full control over data, compatible with shared hosting, VPS, dedicated servers.

### 2. **Smart Form Maker**
- A PHP AJAX form generator.
- Features:
  - Create advanced forms for MySQL with subforms, validation, multiple form types.
  - Supports inserting, updating, deleting records.
  - Customization of form styles and layout.
  - AJAX-based submission for improved performance.
  - Create master-detail (subform) layouts.
  - Mobile-friendly forms.

### 3. **Smart Report Engine**
- Developer-focused PHP library.
- Features:
  - Generates reports directly from MySQL within your codebase.
  - No built-in UI; integrates into existing projects.
  - Suitable for advanced and custom reporting needs.

---

## Key Features of Smart Report Maker

- **No-Code Designer:** Build reports, pivot tables, dashboards visually.
- **Flexible Data Analysis:** Drill-downs, custom date ranges, historical comparison.
- **Charting:** Extensive chart types with filters, export options.
- **Scheduled Reporting:** Automate delivery via email.
- **Security & User Management:** Role-based access, user permissions.
- **Embedding Options:** WordPress plugin and Embed Manager for PHP apps.
- **Compatibility:** Installation via cPanel, Plesk, CWP, Composer, Docker.
- **Support for Advanced Analysis:** KPIs, cross-report linking, multi-level drill-down.

---

## Key Features of Smart Form Maker

- **Multiple Form Types:** Editable grids, columnar, master-detail, mobile forms.
- **Record Management:** Insert, update, delete operations with validation.
- **Advanced Customization:** Custom headers, footers, styles, messages.
- **AJAX Functionality:** Asynchronous data submission without page refresh.
- **Subforms & Master/Detail Layout:** Create complex relational forms.
- **Validation & Security:** Enforce rules, customize error messages.
- **Flexible Design:** Layout options, record pagination.
  
---

## Latest News & Updates
- **12 Oct:** Release of Smart Report Maker 11.0 with new features.
- **17 Jun:** MySQL Pivot Tables with drag-and-drop in SRM 10.0.
- **03 Dec:** Upgrade to SRM9 with power enhancements.
- **10 Feb:** Smart Report Engine Version 2.2.
- **26 Jun:** Version 8.2.0.
- **18 Jun:** Calculated columns addition.
- **01 Oct:** Reporting integration guides.
- **21 Jul:** Version 8.1.0.
- **10 May:** Smart Report Engine release.

---

## About Webuccino
- Company creating simple reporting tools since 2007.
- Offers PHP reports, link and chaining, WordPress embedding, PHP app integration, pivot tables, dashboards, and charts.
- Supports comprehensive data management and visualization solutions.

[Read more about Webuccino](https://mysqlreports.com/about/)

---

## Highlights & Support

### Highlights
- PHP Reports for MySQL
- Report Linking & Chaining
- WordPress Reports & Dashboards
- Embedding in Applications
- MySQL Pivot Tables
- PHP Dashboards & Charts
- Data Analysis Tools
- Manage & Customize Dashboards
- PHP Form Builder
- PHP Reporting Library

### Support
- Customer Support via [Open Ticket](https://mysqlreports.com/open-ticket/)
- Frequently Asked Questions ([FAQ](https://mysqlreports.com/faq/))
- Documentation ([Docs](https://mysqlreports.com/mysql-report-generator-manual/))
- Video Tours and Demos
- Demo Version Access

---

## Notes
- All tools are designed to be flexible, suitable for various hosting environments.
- No API endpoint documentation is provided on this page.
- If you are interested in generating reports programmatically or via an API, review the PHP libraries or contact support for custom integrations.

---

*End of Document.*

---

## Page: https://mysqlreports.com/

# Webuccino Overview

Webuccino has been creating easy-to-use reporting tools since 2007. Their suite of products includes powerful PHP reporting tools designed for MySQL databases, enabling users to generate professional reports, dashboards, KPIs, pivot tables, charts, and scheduled reports. They also support report linking, embedding in WordPress, and integration into custom PHP applications.

---

# Core Products

## Smart Report Maker
An advanced PHP report builder for MySQL that allows creating professional reports, PHP dashboards, KPIs, MySQL pivot tables, and charts with scheduling options.

### Features
- No-code report and dashboard creation
- Supports advanced analysis, linking, and chaining
- WordPress plugin for embedding reports
- Embed reports into PHP applications
- Fully self-hosted with flexible deployment options

### Highlights
- All-in-one solution: reports, dashboards, pivot tables, charts
- Easy-to-use interface for building reports with filters, calculations, and formatting
- Customizable dashboards with real-time metrics
- Report linking and chaining for drill-down analysis
- Support for pivot tables and data analysis
- Advanced PHP charting with various chart types
- Scheduled reporting with email delivery
- User roles, permissions, and security features
- Compatible with cPanel, Plesk, CWP, Composer, Docker

> [Learn more about Smart Report Maker](https://mysqlreports.com/mysql-reporting-tools/the-best-mysql-report-builder/)  
> [Try Demo](https://demo.mysqlreports.com/login)  
> [Purchase Now](https://mysqlreports.com/buy/)

---

## Smart Form Maker
A tool for creating advanced PHP AJAX forms to manage MySQL database records seamlessly.

### Features
- Supports subforms, validation, and multiple form types
- Insert, update, delete database records
- Advanced validation rules (e.g., numerical ranges)
- Customization options for form appearance
- AJAX-based form submission for enhanced performance
- Creation of master/Detail (subforms) layouts
- Compatible with mobile devices

> [Learn more about Smart Form Maker](https://mysqlreports.com/mysql-reporting-tools/php-mysql-form-generator/)  
> [Try Demo](https://mysqlreports.com/mysql-forms-demo/wizard/step_2.php)  
> [Purchase Now](https://mysqlreports.com/buy/)

---

## Smart Report Engine
A PHP library aimed at developers to generate reports from MySQL databases without a built-in user interface.

### Features
- Direct integration into application code
- Advanced reporting capabilities
- Suitable for developers needing custom reporting solutions

> [Learn more about Smart Report Engine](https://mysqlreports.com/mysql-reporting-tools/smart-report-engine/)  
> [Purchase Now](https://mysqlreports.com/buy/)

---

# Feature Exploration

## Smart Report Maker
A comprehensive, no-code report and dashboard creator supporting multi-level drill-down reporting and analytics:

- Generate detailed reports, charts, and KPIs.
- Build dashboards with real-time tracking.
- Schedule reports for automatic delivery.
- Supports report linking and chaining.
- Embeds securely into WordPress and PHP applications.
- Supports pivot tables and advanced data analysis.
- Role-based security, user management.
- Compatible with hosting panels like cPanel, Plesk, Docker, etc.

## Smart Form Maker
Build advanced dynamic forms with features including:

- Multiple form types: editable grids, master-details, mobile forms
- Validation, custom layouts, headers, footers
- Insert, update, and delete records
- AJAX for fast, seamless submissions
- Subforms and master/details layout
- Data validation rules (e.g., numeric ranges)
- Full customization options

---

# Latest News Highlights
- **Oct 12:** [Smart Report Maker 11.0 Release: Powerful New Features](https://mysqlreports.com/blog/smart-report-maker-11-0-release-powerful-new-features/)
- **Jun 17:** [Build MySQL Pivot Tables with Drag-and-Drop in SRM 10.0](https://mysqlreports.com/blog/mysql_pivot_tables/)
- **Dec 3:** [Upgrade to SRM9 – Our Most Powerful Release Yet!](https://mysqlreports.com/blog/php-dashboard-builder-and-php-report-writer-for-mysql/)
- **Feb 10:** [Smart Report Engine Version 2.2 Released](https://mysqlreports.com/blog/smart-report-engine-2-0-has-been-released/)
- **Jun 26:** [Smart Report Maker Version 8.2.0 Released](https://mysqlreports.com/blog/smart-report-maker-version-8-2-0-has-been-released/)
- **Jun 18:** [Add Calculated Columns to Your Reports](https://mysqlreports.com/blog/create-calculated-columns-in-your-reports/)
- **Oct 1:** [Integrate Reports into Your Software Projects](https://mysqlreports.com/blog/integrate-created-reports-with-smart-report-maker-into-your-software-project/)
- **Jul 21:** [Smart Report Maker Version 8.1.0 Released](https://mysqlreports.com/blog/smart-report-maker-version-8-0-0-has-been-released/)
- **May 10:** [Smart Report Engine Released](https://mysqlreports.com/blog/smart-report-engine/)

---

# About Webuccino
Webuccino has been creating user-friendly reporting tools since 2007. Their offerings include PHP-based reporting solutions for MySQL, report linking, embedding tools for WordPress, and integration modules for custom applications.

**Follow on YouTube:** [MrStarsoft2011](https://www.youtube.com/user/MrStarsoft2011)  
**Follow on Vimeo:** [Webuccino](https://vimeo.com/115685915)

---

# Highlights & Resources
- [PHP Reports for MySQL](https://mysqlreports.com/php-reports/)
- [Report Linking & Chaining](https://mysqlreports.com/report-linking/)
- [Embedding Reports & Dashboards in WordPress](https://mysqlreports.com/srm-embed-smart-report-maker/)
- [Embedding Reports in Applications](https://mysqlreports.com/srm-modules-embed-manager/)
- [MySQL Pivot Tables](https://mysqlreports.com/php-mysql-pivot-tables/)
- [PHP Dashboards](https://mysqlreports.com/php-dashboards-for-mysql/)
- [PHP Charts](https://mysqlreports.com/php-charts/)
- [MySQL Data Analysis](https://mysqlreports.com/mysql-data-analysis/)
- [Manage Dashboards](https://mysqlreports.com/smart-report-maker-docs/docs/dashboards/mysql-dashboards-managing-and-customizing-your-data-insights/)
- [PHP Form Builder](https://mysqlreports.com/mysql-reporting-tools/php-mysql-form-generator/)
- [PHP Reporting Library](https://mysqlreports.com/mysql-reporting-tools/smart-report-engine/)

---

# Support & Legal
- [Customer Support](https://mysqlreports.com/open-ticket/)
- [FAQ](https://mysqlreports.com/faq/)
- [Documentation](https://mysqlreports.com/mysql-report-generator-manual/)
- [Video Tours](https://mysqlreports.com/webuccino-screencasts/)
- [Demo Version](https://demo.mysqlreports.com/login)
- [Privacy Policy](https://mysqlreports.com/privacy-policy/)
- [About Webuccino](https://mysqlreports.com/about/)
- [Sitemap](https://mysqlreports.com/web-sitemap/)

---

**Copyright © 2007-2025 Webuccino.**

---

## Page: https://mysqlreports.com/about

# About Webuccino

Webuccino is a software development company operating since 2007, focused on delivering affordable and efficient reporting solutions. The company has a proven track record of successful project completions and prioritizes customer support and high-quality software to help businesses gain a competitive edge.

## Company Overview

- **Founded:** 2007
- **Specialization:** Reporting solutions, custom software development, product customization, and dedicated development teams.
- **Target Audience:** Small to medium-sized businesses, freelance teams, and individuals.
- **Approach:** User-friendly, accessible software designed for users without technical expertise. Personalized support from an experienced team.

## Services

### 1. Software Development
- Over 15 years of experience.
- Implements best practices for fast, cost-efficient processes.
- Converts business needs into scalable software solutions using mainly open-source technologies.

### 2. Product Customization
- Custom features tailored to specific business needs.
- To request customization, open a support ticket and specify the required features.

### 3. Hiring Development Teams
- Assemble dedicated, skilled teams to turn product ideas into professional tools.
- Teams are fully committed and have the necessary technical expertise.

### 4. Visualize Your Idea
- System analysts and product designers assist in transforming your ideas into prototypes.
- Conduct research, develop prototypes, and present concepts systematically.
- Accelerates bringing products to market.

## Contact Information
- To inquire or request support, open a support ticket [here](https://mysqlreports.com/support/index.php?a=add).

---

## Highlights and Resources
- [PHP Reports for MySQL](https://mysqlreports.com/php-reports/)
- [Report Linking & Chaining](https://mysqlreports.com/report-linking/)
- [Reports & Dashboards in WordPress](https://mysqlreports.com/srm-embed-smart-report-maker/)
- [Reports & Dashboards in Your Application](https://mysqlreports.com/srm-modules-embed-manager/)
- [MySQL Pivot Tables](https://mysqlreports.com/php-mysql-pivot-tables/)
- [PHP Dashboards for MySQL](https://mysqlreports.com/php-dashboards-for-mysql/)
- [PHP Charts for MySQL](https://mysqlreports.com/php-charts/)
- [MySQL Data Analysis](https://mysqlreports.com/mysql-data-analysis/)
- [Manage Dashboards](https://mysqlreports.com/smart-report-maker-docs/docs/dashboards/mysql-dashboards-managing-and-customizing-your-data-insights/)
- [PHP Form Builder for MySQL](https://mysqlreports.com/mysql-reporting-tools/php-mysql-form-generator/)
- [Easy-to-Use PHP Reporting Library](https://mysqlreports.com/mysql-reporting-tools/smart-report-engine/)

## Support and Documentation
- Customer Support: [Open a support ticket](https://mysqlreports.com/support/index.php?a=add)
- FAQs: [Visit FAQ page](https://mysqlreports.com/faq/)
- Documentation: [Smart Report Maker Docs](https://mysqlreports.com/smart-report-maker-docs/smart-report-maker-docs/)
- Video Tours: [Watch screencasts](https://mysqlreports.com/webuccino-screencasts/)
- Demo Version: [Access Demo](https://demo.mysqlreports.com/login)
- Privacy Policy: [Read Privacy Policy](https://mysqlreports.com/privacy-policy/)
- Sitemap: [Visit Sitemap](https://mysqlreports.com/web-sitemap/)

---

## Contact and Follow Us
- YouTube: [Webuccino YouTube Channel](https://www.youtube.com/user/MrStarsoft2011)
- Vimeo: [Webuccino Vimeo](https://vimeo.com/115685915)

*Copyrights Reserved 2007 - 2025 © Webuccino.*

---

## Page: https://mysqlreports.com/blog

# Webuccino Blog and Product Overview

## Blog Highlights and Articles

### January 18, 2026
**[One Smart Report Maker Installation for Multiple PHP Client Applications](https://mysqlreports.com/blog/one-smart-report-maker-installation-for-multiple-php-client-applications/)**  
*Category: Smart Report Maker, Tutorials*  
As a PHP developer or solution provider, managing multiple applications for different clients is common. Each client often has their own database, users, and settings. This article discusses how to install Smart Report Maker in a way that supports multiple PHP client applications efficiently.  

**Read more:** [Continue Reading](https://mysqlreports.com/blog/one-smart-report-maker-installation-for-multiple-php-client-applications/)

---

### December 28, 2025
**[How to Securely Embed Reports, Dashboards, Charts, and Pivot Tables in WordPress Using a WordPress Reports Builder Plugin](https://mysqlreports.com/blog/how-to-securely-embed-reports-dashboards-and-charts-in-wordpress-using-the-srm-embed-plugin/)**  
*Category: Articles, Report Builder WordPress plugins, Tutorials*  
WordPress powers a large part of the web, and modern businesses rely on data analytics like dashboards, KPIs, pivot tables, and reports to monitor performance. This article explains how to securely embed these elements using the SRM Embed plugin in WordPress.  

**Read more:** [Continue Reading](https://mysqlreports.com/blog/how-to-securely-embed-reports-dashboards-and-charts-in-wordpress-using-the-srm-embed-plugin/)

---

### October 12, 2025
**[Smart Report Maker 11.0 Release: Powerful New Features You’ll Love](https://mysqlreports.com/blog/smart-report-maker-11-0-release-powerful-new-features/)**  
*Category: News, Tutorials*  
The latest version of Smart Report Maker (11.0) introduces major enhancements, including a new WordPress plugin for embedding reports, charts, and dashboards.  

**Read more:** [Continue Reading](https://mysqlreports.com/blog/smart-report-maker-11-0-release-powerful-new-features/)

---

### October 10, 2025
**[Top 5 WordPress Report Builder Plugins Worth Considering](https://mysqlreports.com/blog/top-5-wordpress-report-builder-plugins-worth-considering/)**  
*Category: Articles, Report Builder WordPress plugins*  
Transforming a WordPress site into a data-driven platform requires more than raw data display. This article presents the top WordPress report builder plugins to help understand data insights effectively.  

**Read more:** [Continue Reading](https://mysqlreports.com/blog/top-5-wordpress-report-builder-plugins-worth-considering/)

---

### September 19, 2025
**[Adding Smart Report Maker Reports and Dashboards to an AppGini Application](https://mysqlreports.com/blog/adding-smart-report-maker-reports-and-dashboards-to-an-appgini-application/)**  
*Category: Tutorials*  
AppGini facilitates rapid PHP application development with built-in user management. This guide explains integrating Smart Report Maker reports and dashboards into AppGini applications for enhanced data visualization.  

**Read more:** [Continue Reading](https://mysqlreports.com/blog/adding-smart-report-maker-reports-and-dashboards-to-an-appgini-application/)

---

### June 17, 2025
**[Build MySQL Pivot Tables with Drag-and-Drop in SRM 10.0](https://mysqlreports.com/blog/mysql_pivot_tables/)**  
*Category: Articles, News*  
Smart Report Maker 10.0 introduces a Pivot Table module allowing users to create MySQL pivot tables via drag-and-drop interfaces, simplifying complex data analysis tasks.  

**Read more:** [Continue Reading](https://mysqlreports.com/blog/mysql_pivot_tables/)

---

### December 3, 2024
**[Upgrade to SRM9 – Our Most Powerful Release Yet!](https://mysqlreports.com/blog/php-dashboard-builder-and-php-report-writer-for-mysql/)**  
*Category: News*  
Smart Report Maker 9.0 offers significant improvements, including effortless report scheduling and more powerful features to streamline report management.  

**Read more:** [Continue Reading](https://mysqlreports.com/blog/php-dashboard-builder-and-php-report-writer-for-mysql/)

---

### April 20, 2023
**[A Guide to Dimensional Modeling with MySQL](https://mysqlreports.com/blog/dimensional-modeling-with-mysql/)**  
*Category: Articles*  
This article discusses the differences between transactional and analytical databases, exploring benefits and drawbacks of using MySQL for analytical purposes, including dimensional modeling concepts.  

**Read more:** [Continue Reading](https://mysqlreports.com/blog/dimensional-modeling-with-mysql/)

---

### April 14, 2023
**[Scheduling MY SQL Backups](https://mysqlreports.com/blog/scheduling-of-mysql-backups/)**  
*Category: Articles*  
Emphasizes the importance of regular backups for MySQL databases and provides strategies for scheduling backups to ensure data safety.  

**Read more:** [Continue Reading](https://mysqlreports.com/blog/scheduling-of-mysql-backups/)

---

### April 11, 2023
**[MYSQL JSON Data Type](https://mysqlreports.com/blog/mysql-json-data-type/)**  
*Category: Articles*  
Explains the JSON data type in MySQL, highlighting its advantages for web applications, how to use it, and best practices for data storage and retrieval.  

**Read more:** [Continue Reading](https://mysqlreports.com/blog/mysql-json-data-type/)

---

## Tags
- [API For developers 2](https://mysqlreports.com/tag/api-for-developers/)
- [Data analysts for MYSQL 8](https://mysqlreports.com/tag/data-analysts-for-mysql/)
- [Graphs for MYSQL 6](https://mysqlreports.com/tag/mysql-graphs/)
- [MYSQL 6](https://mysqlreports.com/tag/mysql/)
- [PHP Dashboards 5](https://mysqlreports.com/tag/php-dashboards/)
- [PHP MYSQL Forms 2](https://mysqlreports.com/tag/php-mysql-forms/)
- [Pivot Tables For MySQL 7](https://mysqlreports.com/tag/mysql-pivot-table/)
- [Report Builder WordPress Plugin 3](https://mysqlreports.com/tag/report-builder-wordpress-plugin/)
- [Reports For MYSQL 15](https://mysqlreports.com/tag/php-mysql-report-builder/)
- [Tutorials 7](https://mysqlreports.com/tag/tutorials/)

## Demo and Video
- [Try Demo Version](https://demo.mysqlreports.com/login)  
- [Watch Video](https://www.youtube.com/watch?v=HLy5ciY4weg)

---

## About Webuccino
**Webuccino** has been creating easy-to-use reporting tools since 2007.  
[Read more](https://mysqlreports.com/about/)

### Social Links
- [YouTube](https://www.youtube.com/user/MrStarsoft2011)
- [Vimeo](https://vimeo.com/115685915)

---

## Highlights of Webuccino Products
- [PHP Reports for MySQL](https://mysqlreports.com/php-reports/)
- [Report Linking & Chaining](https://mysqlreports.com/report-linking/)
- [Reports & Dashboards in WordPress](https://mysqlreports.com/srm-embed-smart-report-maker/)
- [Reports & Dashboards in Your Application](https://mysqlreports.com/srm-modules-embed-manager/)
- [MySQL Pivot Tables](https://mysqlreports.com/php-mysql-pivot-tables/)
- [PHP Dashboards for MySQL](https://mysqlreports.com/php-dashboards-for-mysql/)
- [PHP Charts for MySQL](https://mysqlreports.com/php-charts/)
- [MySQL Data Analysis](https://mysqlreports.com/mysql-data-analysis/)
- [Manage Dashboards](https://mysqlreports.com/smart-report-maker-docs/docs/dashboards/mysql-dashboards-managing-and-customizing-your-data-insights/)
- [PHP Form Builder for MySQL](https://mysqlreports.com/mysql-reporting-tools/php-mysql-form-generator/)
- [Easy-to-Use PHP Reporting Library](https://mysqlreports.com/mysql-reporting-tools/smart-report-engine/)

---

## Support and Documentation
- [Customer Support](https://mysqlreports.com/open-ticket/)
- [FAQ](https://mysqlreports.com/faq/)
- [Docs](https://mysqlreports.com/mysql-report-generator-manual/)
- [Video Tours](https://mysqlreports.com/webuccino-screencasts/)
- [Demo Version](https://demo.mysqlreports.com/login)

---

## Legal and Miscellaneous
- [Privacy Policy](https://mysqlreports.com/privacy-policy/)
- [About Webuccino](https://mysqlreports.com/about/)
- [User Testimonials](https://mysqlreports.com/smart-report-maker-testimonials/)
- [Sitemap](https://mysqlreports.com/web-sitemap/)

---

*This document reflects the main content sections focused on updates, articles, product features, and support resources provided by Webuccino and related tools.*

---

## Page: https://mysqlreports.com/blog/create-calculated-columns-in-your-reports

# Add Calculated Columns to Your Reports with Smart Report Maker

## Overview
Calculated columns are virtual, non-stored columns that derive their values from other columns within a report. They are useful for displaying computed data such as totals, averages, or other derived metrics, and they can be included alongside physically stored database columns.

---

## Features of Calculated Columns
- **Virtual Columns**: Not physically stored in the database; their values are computed dynamically.
- **Multiple Calculated Columns**: You can add as many as needed in a report.
- **Subtotals and Grand Totals**: Supported for calculated columns within reports.
- **Configuration File**: Each report has a `calculated_columns.php` file where calculations are defined.

---

## The `calculated_columns.php` Configuration File

### Location
Replace `{Smart-Report-Maker-PATH}` with your actual installation path and `{report-name}` with your specific report name:

```
/{Smart-Report-Maker-PATH}/SRM8/SRM/Reports8/rep{report-name}/calculated_columns.php
```

### Structure
The core of this file is an array called `$calculated_columns`. You define your calculated columns within this array, linking each column name to a validation function.

```php
$calculated_columns = array(
    // Add calculated columns here
);
```

---

## How to Add a Calculated Column

### Example: Adding a 'total_price' Column

Suppose you have the following scenario:
- **Tables**:
  - `products`: contains `ProductName`
  - `order_details`: contains `OrderId`, `UnitPrice`, and `Quantity`
- **Goal**: Add a calculated column `total_price` computed as `UnitPrice * Quantity`.

### Step-by-step Instructions

1. **Create the report**:
   - Launch the Smart Report Maker wizard.
   - Enter MySQL connection parameters.
   - Select the `products` and `order_details` tables.
   - Define the relationship between tables.
   - Choose the columns to include (initially only physical columns).
   - Group by `ProductName`.

2. **Finalize the report**:
   - Complete report creation.
   - Locate the generated report directory:
   
   ```
   /{Smart-Report-Maker-PATH}/SRM8/SRM/Reports8/rep{your-report-name}/
   ```
   
3. **Locate and edit `calculated_columns.php`**:
   - Find the file in the report directory.
   - Open it with a text editor.

4. **Define the calculated column**:
   - Inside the `$calculated_columns` array, add the following:

```php
$calculated_columns = array(
    "total_price" => function($row) {
        return $row["UnitPrice"] * $row["Quantity"];
    }
);
```

**Note:**  
- `$row` parameter represents each row in the report.
- Refer to columns as `$row["ColumnName"]`.

5. **Save changes** and refresh the report in your browser.  
   The `total_price` column will now appear in your report.

---

## Adding Additional Calculated Columns

To add more calculated fields, include additional entries in the `$calculated_columns` array. For example, to compute `total_price_after_vat` assuming VAT is 15%, add:

```php
$calculated_columns = array(
    "total_price" => function($row) {
        return $row["UnitPrice"] * $row["Quantity"];
    },
    "total_price_after_vat" => function($row) {
        return $row["total_price"] * 1.15;
    }
);
```

**Note:**  
- In the function, use `$row["ColumnName"]` to access other calculated or physical columns.
- Make sure to recalculate or adjust dependencies if your calculated columns depend on each other.

---

## Summary
- Calculated columns are dynamically generated, virtual columns based on expressions involving existing data.
- They can be added by editing the `calculated_columns.php` file in the report directory.
- Usage involves defining the column name and providing a function that returns its value for each row.
- Subtotals and grand totals for these columns are supported.

---

## Additional Resources
- [Smart Report Maker Documentation](https://mysqlreports.com/mysql-reporting-tools/)
- [Sample Configuration Snippet](https://sites.fastspring.com/mysqlreportsengine/product/smartreportmaker810offer)

---

## About Webuccino
Webuccino has been creating easy-to-use reporting tools since 2007.  
[Read more](https://mysqlreports.com/about/)

### Follow Us:
- [YouTube](https://www.youtube.com/user/MrStarsoft2011)
- [Vimeo](https://vimeo.com/115685915)

---

## Highlights of Our Products and Solutions
- PHP Reports for MySQL
- Report Linking & Chaining
- Reports & Dashboards in WordPress and Applications
- MYSQL Pivot Tables
- PHP Dashboards and Charts for MySQL
- Data Analysis Tools
- Form Builders
- Easy-to-Use PHP Reporting Library

### Support & Documentation
- [Customer Support](https://mysqlreports.com/open-ticket/)
- [FAQs](https://mysqlreports.com/faq/)
- [Documentation](https://mysqlreports.com/mysql-report-generator-manual/)
- [Video Tours](https://mysqlreports.com/webuccino-screencasts/)

---

**Copyrights Reserved 2007 - 2025 © Webuccino**

---

## Page: https://mysqlreports.com/blog/integrate-created-reports-with-smart-report-maker-into-your-software-project

# Blog: Integrate Created Reports with Smart Report Maker into Your Software Projects

## Overview
This tutorial explains how to embed reports generated by Smart Report Maker into your software application, ensuring they are secured and accessible via your existing login system without requiring users to log in twice.

---

## Step-by-Step Instructions

### 1. Generate Public Reports
- When creating reports in Smart Report Maker, set the report security to **"public"**.
- To do this, during report creation:
  - Navigate to the settings step of the report wizard.
  - Select **"This report is public"** from the security tab.
  
### 2. Move the Reports into Your Product
- The latest version (v8) stores reports in:
  ```
  /SRM8/SRM/Reports8/
  ```
- To integrate reports:
  - Copy the entire `Reports8` directory into your software project directory, renaming it as needed.
  - For specific reports, copy only the subdirectories of the reports you need along with the shared directory:
    ```
    /SRM8/SRM/Reports8/shared/
    ```
  - Ensure that the `shared` directory and report subdirectories are placed together within your project.

### 3. Integrate Reports with Your Security System
- Add code to your project to secure report access, matching your project’s login mechanism.
- Typically, configure security checks in the following files:
  - For all reports:
    ```
    /SRM8/SRM/Reports8/shared/helpers/lib.php
    ```
  - For individual reports:
    ```
    /SRM8/SRM/Reports8/rep{Your-report-name}/auto_load.php
    ```
- Example: Assuming session-based security where your system checks session keys:
  - `$_SESSION["user_id"]`
  - `$_SESSION["group_id"]`
  
- Example code snippet to restrict access:
```php
if ( !isset($_SESSION["user_id"]) || !isset($_SESSION["group_id"]) || !in_array($_SESSION["group_id"], array(5,6)) ) {
    header('Location: https://some-domain/your-project/your-login-page');
    exit();
}
```

- Adjust the session key checks and redirect URL to match your security logic.

### 4. Test the Integration
- Verify that:
  - Users without an active session are redirected to your login page.
  - Users with a valid session can access and view reports seamlessly.

### 5. Additional Capabilities
- Smart Report Engine supports programmatic report generation and control, enabling integration directly from your application code for dynamic report handling.

---

## Summary
To successfully embed Smart Report Maker reports into your application:
1. Generate reports with **public** access.
2. Move the reports and shared resources to your project.
3. Incorporate security checks aligning with your login system in relevant report files.
4. Test access controls thoroughly.

---

## About Webuccino
Webuccino has been creating user-friendly reporting tools since 2007.  
[Read more](https://mysqlreports.com/about/)

### Follow Us
- [YouTube](https://www.youtube.com/user/MrStarsoft2011)
- [Vimeo](https://vimeo.com/115685915)

---

## Highlights of Our Products
- [PHP Reports for MySQL](https://mysqlreports.com/php-reports/)
- [Report Linking & Chaining](https://mysqlreports.com/report-linking/)
- [Reports & Dashboards in WordPress](https://mysqlreports.com/srm-embed-smart-report-maker/)
- [Reports & Dashboards in Your Application](https://mysqlreports.com/srm-modules-embed-manager/)
- [MySQL Pivot Tables](https://mysqlreports.com/php-mysql-pivot-tables/)
- [PHP Dashboards for MySQL](https://mysqlreports.com/php-dashboards-for-mysql/)
- [PHP Charts for MySQL](https://mysqlreports.com/php-charts/)
- [MySQL Data Analysis](https://mysqlreports.com/mysql-data-analysis/)
- [Managing Dashboards](https://mysqlreports.com/smart-report-maker-docs/docs/dashboards/mysql-dashboards-managing-and-customizing-your-data-insights/)
- [PHP Form Builder for MySQL](https://mysqlreports.com/mysql-reporting-tools/php-mysql-form-generator/)
- [Easy PHP Reporting Library](https://mysqlreports.com/mysql-reporting-tools/smart-report-engine/)

## Support Resources
- [Customer Support](https://mysqlreports.com/open-ticket/)
- [FAQ](https://mysqlreports.com/faq/)
- [Documentation](https://mysqlreports.com/mysql-report-generator-manual/)
- [Video Tours](https://mysqlreports.com/webuccino-screencasts/)
- [Demo Version](https://demo.mysqlreports.com/login)

---

---

## Page: https://mysqlreports.com/blog/mysql_pivot_tables

# Blog: Build MySQL Pivot Tables with Drag-and-Drop in SRM 10.0

## Overview
Smart Report Maker (SRM) version 10.0.0 introduces a powerful new module for building MySQL Pivot Tables using an intuitive drag-and-drop interface. This feature allows users to analyze and summarize data from any database easily, with no coding required. Users can apply filters, define parameters, and customize table layouts dynamically.

## Features of the New Pivot Table Editor in SRM 10.0.0

### Drag-and-Drop Interface
- Easily assign fields to "Rows," "Columns," and "Values" sections.
- No programming or coding expertise needed.
- Provides a user-friendly experience for creating complex pivot tables quickly.

### Automatic Relationship Detection
- Detects relationships between multiple tables automatically.
- Allows manual adjustments to relationships if necessary.

### Static Filters for Precision
- Define fixed filters via drag-and-drop for precise data selection.
- Filters limit data to specific records before visualization.

### Dynamic Filtering with Parameters
- Create interactive parameters for end-users.
- Allows real-time filtering, enabling personalized data views.

### Intuitive Parameter Display for End Users
- Display parameters in user-friendly formats such as:
  - Calendar date pickers
  - Time sliders
  - Multi-select dropdowns
  - Numeric range sliders
  - Search boxes
- Facilitates easy and interactive filtering experiences.

### Smart Date Handling
- When using date fields as headers, choose grouping options:
  - Year, quarter, month, weekday, time, or full date
- Supports generating summaries at various time granularities.

### Subtotals for Periodic Summaries
- Display subtotals within grouped periods.
- For example, show quarterly data with annual totals.

### Grand Total Visibility Control
- Toggle display of grand totals for rows and columns as needed.

### Customizable Styles and Templates
- Select from multiple pre-designed templates.
- Further customize with:
  - Titles
  - Numeric formats
  - Currencies
  - Custom measurement units

### Access Control
- Set pivot tables as public or restrict to specific user groups based on permissions.

### Flexible Aggregation Functions
- Support for various summarization methods:
  - Sum
  - Count
  - Count Distinct
  - Average
  - Min
  - Max
  - First Value

### Export Capabilities
- Export pivot tables in multiple formats for sharing or offline use.

### Column Visibility Management
- Hide or show specific columns to focus on key metrics.

### Dashboard Integration
- Embed pivot tables as widgets within SRM dashboards.
- Combine with other reports and KPIs for comprehensive data insights.

### User-Friendly and Performance-Optimized
- Designed for usability and speed.
- Handles large datasets efficiently, with quick load and update times.

## Summary
Smart Report Maker 10.0.0 now offers a robust module for creating MySQL Pivot Tables with an easy-to-use drag-and-drop interface. Users can analyze and summarize database data, apply multiple filters and parameters, and customize reports visually—all without coding.

## Useful Links
- [Try Smart Report 10](https://demo.mysqlreports.com/pivot-tables/create)
- [Smart Report Maker Home Page](https://mysqlreports.com/mysql-reporting-tools/the-best-mysql-report-builder/)
- [Start Using SRM 10](https://mysqlreports.com/buy/)
- [Pivot Table Module of SRM](https://mysqlreports.com/php-mysql-pivot-tables/)
- [Dashboard Module of SRM](https://mysqlreports.com/php-dashboards-for-mysql/)
- [Charts Module of SRM](https://mysqlreports.com/php-charts/)
- [Reports Module of SRM](https://mysqlreports.com/php-reports/)
- [Data Analysis Module of SRM](https://mysqlreports.com/mysql-data-analysis/)

---

# About Webuccino
Webuccino has been creating easy-to-use reporting tools since 2007.  
[Read more](https://mysqlreports.com/about/).

Follow us on:
- [YouTube](https://www.youtube.com/user/MrStarsoft2011)
- [Vimeo](https://vimeo.com/115685915)

## Highlights of Webuccino Products
- PHP Reports for MySQL
- Report Linking & Chaining
- Reports & Dashboards in WordPress
- Reports & Dashboards in Your Application
- MySQL Pivot Tables
- PHP Dashboards for MySQL
- PHP Charts for MySQL
- MySQL Data Analysis
- Manage Dashboards
- PHP Form Builder for MySQL
- PHP Reporting Library

## Help and Support
- [Customer Support](https://mysqlreports.com/open-ticket/)
- [FAQ](https://mysqlreports.com/faq/)
- [Docs](https://mysqlreports.com/mysql-report-generator-manual/)
- [Video Tours](https://mysqlreports.com/webuccino-screencasts/)
- [Demo Version](https://demo.mysqlreports.com/login)

---

*Copyrights Reserved 2007 - 2025 © Webuccino.*

---

## Page: https://mysqlreports.com/blog/php-dashboard-builder-and-php-report-writer-for-mysql

# Web Report Tools and Features Overview

## Main Sections

### Products
- **Smart Report Maker**: The top MySQL report builder.
- **Smart Form Maker**: PHP form generator for MySQL.
- **Smart Report Engine**: PHP reporting library.

### Support and Resources
- **Open Ticket**: Submit support tickets.
- **FAQ**: Frequently Asked Questions.
- **User Testimonials**: Feedback from users.
- **Video Tours**: Screencasts demonstrating features.
- **Demo**: Live demonstrations.
- **Purchase**: Buy the software.

### Blog & News
- Announcements, updates, and guides.

---

# Latest Release: Upgrade to SRM9 – Our Most Powerful Release Yet!

**Posted December 3, 2024**

## Key Features of Smart Report Maker 9.0 (SRM 9.0)

- **Automated Scheduling of Reports**
  - Schedule reports to generate and deliver at specified times (daily, weekly, monthly).
  - Simplifies keeping team members updated with minimal effort.
   
- **Enhanced Data Visualization**
  - Create interactive PHP dashboards for KPI tracking.
  - Design eye-catching charts and perform data analysis.
  - Managed through a unified control panel for quick editing and refinenement.

- **Compatibility and Performance**
  - Fully compatible with the latest PHP versions.
  - Offers seamless performance and easy integration.
  - Online demo available [here](https://demo.mysqlreports.com/login).

## User Testimonials

- **Steven Thefaine** — Solutions Engineer at [EnTelegent Solutions](https://entelegent.com/)
  - "Great Product. Easy to use and integrate into existing sites."
  - [More Testimonials](https://mysqlreports.com/smart-report-maker-testimonials)

## Why Upgrade to SRM 9.0?

### 1. **A Unified Control Panel**
Manage reports, charts, dashboards, KPIs, and scheduled reports all from a single interface.

### 2. **Scheduled Reports**
- Automate report delivery via email or other methods.
- Set delivery frequency (daily, weekly, monthly).
- Ensures timely updates, eliminates manual work.

### 3. **Advanced MySQL Dashboard Builder**
- Create customizable dashboards.
- Add widgets for key metrics, reports, KPIs.
- Monitor performance and compare data over time.

### 4. **Interactive Charts**
- Create unlimited charts: bar, pie, donut, line, time series, and more.
- Customize size, colors, axes.
- Turn data into insightful visuals.

### 5. **Drill-Down Insights**
- Explore detailed data within charts.
- Export views to PDF for sharing.

### 6. **Time-Series Charts**
- Visualize data trends over custom date ranges.
- Filter by daily, weekly, monthly, or yearly scales.

### 7. **Customizable KPIs**
- Create tailored performance metrics.
- Display in info boxes or gauges.
- Compare with historical data or targets.

### 8. **Multiple Data Connections**
- Seamlessly report from various MySQL databases.

### 9. **Security & User Management**
- Role-based permissions, group management.
- User subscriptions for access control.

### 10. **Compatibility**
- Fully compatible with current PHP versions.
- Future-proof and performance optimized.

## Summary

SRM 9.0 offers a comprehensive solution for MySQL data visualization and reporting. Key features include scheduled reports, a unified management interface, advanced dashboards, customizable charts, and seamless database connectivity. Upgrade today to enhance your reporting capabilities.

## Demo and Purchase

- **Try Demo:** [https://demo.mysqlreports.com/login](https://demo.mysqlreports.com/login)
- **Purchase:** [https://mysqlreports.com/buy/](https://mysqlreports.com/buy/)

---

# Useful Links
- [Try Smart Report 10](https://demo.mysqlreports.com/pivot-tables/create)
- [Smart Report Maker Home Page](https://mysqlreports.com/mysql-reporting-tools/the-best-mysql-report-builder/)
- [Start Using SRM 10](https://mysqlreports.com/buy/)
- [Pivot Table Module](https://mysqlreports.com/php-mysql-pivot-tables/)
- [Dashboard Module](https://mysqlreports.com/php-dashboards-for-mysql/)
- [Charts Module](https://mysqlreports.com/php-charts/)
- [Reports Module](https://mysqlreports.com/php-reports/)
- [Data Analysis Module](https://mysqlreports.com/mysql-data-analysis/)

---

# About Webuccino

Webuccino has been creating easy-to-use reporting tools since 2007.  
[Read more](https://mysqlreports.com/about/).

Follow us on:
- [YouTube](https://www.youtube.com/user/MrStarsoft2011)
- [Vimeo](https://vimeo.com/115685915)

## Highlights of Our Products
- PHP Reports for MySQL
- Report Linking & Chaining
- Reports & Dashboards for WordPress
- Application Embedding
- MYSQL Pivot Tables
- PHP Dashboards
- PHP Charts
- Data Analysis
- Dashboard Management
- PHP Form Builder
- Easy PHP Reporting Library

## Support
- [Customer Support](https://mysqlreports.com/open-ticket/)
- [FAQ](https://mysqlreports.com/faq/)
- [Docs](https://mysqlreports.com/mysql-report-generator-manual/)
- [Video Tours](https://mysqlreports.com/webuccino-screencasts/)
- [Demo Version](https://demo.mysqlreports.com/login)

---

# Copyright & Legal
- © Webuccino 2007 - 2025
- [Privacy Policy](https://mysqlreports.com/privacy-policy/)
- [About Webuccino](https://mysqlreports.com/about/)
- [User Testimonials](https://mysqlreports.com/smart-report-maker-testimonials/)
- [Sitemap](https://mysqlreports.com/web-sitemap/)

---

## Page: https://mysqlreports.com/blog/php-reporting-framework

# Blog

## Smart Report Engine Has Been Released

### Category: [News](https://mysqlreports.com/category/news/)  |  Posted: May 10, 2020

It’s our pleasure to announce the release of the [Smart Report Engine](https://mysqlreports.com/mysql-reporting-tools/smart-report-engine/). It’s a robust PHP reporting framework with an intuitive API. This product allows PHP developers to add the same reporting capabilities of Smart Report Maker into their products.

---

## Top Five Reasons to Choose [Smart Report Engine](https://mysqlreports.com/mysql-reporting-tools/smart-report-engine/)

If you are looking for a PHP reporting framework, here are five compelling reasons:

1. **Clear, intuitive API** that is easy to follow.
2. **Unlimited report generation**, enabling dynamic reports from your code.
3. **Minimal coding required** to customize data and appearance of each report.
4. **Well-documented API** with extensive manuals and tutorials; friendly support.
5. **Affordable pricing**, offered as a one-time fee with no hidden costs or renewals.

---

## Differences Between Smart Report Maker and Smart Report Engine

- **Smart Report Maker** is a user-friendly end product for creating professional reports via a visual interface.
- **Smart Report Engine** is a developer-focused framework, providing a well-documented API to integrate reporting capabilities into custom PHP or Laravel projects.

---

## Simple Code Example for Using the PHP Reporting Framework

[Generate Report](https://mysqlreports.com/engine/demo/sre_reports/rep1659165261820424/rep1659165261820424.php)

---

## How to Use the PHP Reporting Framework

Smart Report Engine can be integrated into native PHP projects or Laravel applications.

### Basic Workflow:

1. **Define report options**:

   Use the `ReportOptions` class to specify data, appearance, and security settings for your report.
   
2. **Create the report**:

   Instantiate the `CustomEngine` class by passing the `ReportOptions` object to generate the report as per your configurations.

### Step-by-step:

- Create a `ReportOptions` object and set desired options.
- Instantiate `CustomEngine`, passing the `ReportOptions` object.
- Call the appropriate method to generate or display the report.

---

## Useful Links

- [Home Page](https://mysqlreports.com/mysql-reporting-tools/smart-report-engine/)
- [Tutorials](https://mysqlreports.com/examples/)

---

# About Webuccino

Webuccino has been creating easy-to-use reporting tools since 2007. [Read more](https://mysqlreports.com/about/).

### Follow us on:
- [YouTube](https://www.youtube.com/user/MrStarsoft2011)
- [Vimeo](https://vimeo.com/115685915)

---

## Highlights of Webuccino’s Products

- [PHP Reports for MySQL](https://mysqlreports.com/php-reports/)
- [Report Linking & Chaining](https://mysqlreports.com/report-linking/)
- [Reports & Dashboards in WordPress](https://mysqlreports.com/srm-embed-smart-report-maker/)
- [Reports & Dashboards in Your Application](https://mysqlreports.com/srm-modules-embed-manager/)
- [MySQL Pivot Tables](https://mysqlreports.com/php-mysql-pivot-tables/)
- [PHP Dashboards for MySQL](https://mysqlreports.com/php-dashboards-for-mysql/)
- [PHP Charts for MySQL](https://mysqlreports.com/php-charts/)
- [MySQL Data Analysis](https://mysqlreports.com/mysql-data-analysis/)
- [Manage Dashboards](https://mysqlreports.com/smart-report-maker-docs/docs/dashboards/mysql-dashboards-managing-and-customizing-your-data-insights/)
- [PHP Form Builder for MySQL](https://mysqlreports.com/mysql-reporting-tools/php-mysql-form-generator/)
- [Easy-to-Use PHP Reporting Library](https://mysqlreports.com/mysql-reporting-tools/smart-report-engine/)

---

## Help & Support

- [Customer Support](https://mysqlreports.com/open-ticket/)
- [FAQ](https://mysqlreports.com/faq/)
- [Docs](https://mysqlreports.com/mysql-report-generator-manual/)
- [Video Tours](https://mysqlreports.com/webuccino-screencasts/)
- [Demo Version](https://demo.mysqlreports.com/login)

---

## Copyright and Legal

Copyright Reserved 2007 - 2025 © Webuccino.

### Footer Links:
- [Privacy Policy](https://mysqlreports.com/privacy-policy/)
- [About Webuccino](https://mysqlreports.com/about/)
- [User Testimonials](https://mysqlreports.com/smart-report-maker-testimonials/)
- [Sitemap](https://mysqlreports.com/web-sitemap/)

---

## Page: https://mysqlreports.com/blog/smart-report-engine-2-0-has-been-released

# Web Reports and Smart Report Engine Documentation

## Overview

Webuccino has been creating easy-to-use reporting tools since 2007. The platform offers various products for database reporting, including the Smart Report Engine (version 2.2), which introduces new features aimed at enhancing report customization and data filtration.

---

## Latest Release: Smart Report Engine Version 2.2

**Release Date:** February 10, 2023

### Key Features and Highlights
- **Filter reports by the currently logged-in user:** Enables filtering reports to show only records relevant to the active user.
- **Calculated columns:** Allows addition of virtual columns computed from existing data.
- **Subtotals and grand totals:** Facilitates adding subtotal and total rows for grouped or entire reports.
- **Dynamic filters:** Supports parameterized reports with user-defined variables (e.g., date ranges).
- **Time filters:** Adds options like "Is Today," "Is Current Month," and "Is Current Year" for easy period-based reporting.

### Learning Resources
- Filtering report by logged-in user: [Example](https://mysqlreports.com/examples/filter-with-current-logged-in/)
- Creating calculated columns: [Example](https://mysqlreports.com/examples/creating-calculated-columns/)
- Reports with subtotals and grand totals: [Example](https://mysqlreports.com/examples/creating-reports-with-subtotals-and-grand-totals-using-smart-report-engine/)

---

## Features of Smart Report Engine

### 1. Filter reports by the current logged-in user

This feature ensures that each user views only their own data in a report, even when multiple users access the same report.

**How it works:**
- Uses the current user’s ID to filter dataset dynamically.
- Ideal for multi-user environments needing data privacy per user.

**Learn more:** [Filtering reports by logged-in user](https://mysqlreports.com/examples/filter-with-current-logged-in/)

---

### 2. Calculated Columns

Enables the addition of virtual columns that are computed from existing data, not stored physically in the database.

**Use case:**
- Show values like total prices (quantity × price).
- Derived metrics such as percentages or ratios.

**Learn more:** [Creating calculated columns](https://mysqlreports.com/examples/creating-calculated-columns/)

---

### 3. Subtotals and Grand Totals

Provides the capability to add subtotals for groups of records based on sum, average, minimum, maximum, or count. Also supports grand totals at the end of reports.

**Benefits:**
- Summarize grouped data efficiently.
- Present comprehensive report totals.

**Learn more:** [Creating reports with subtotals and grand totals](https://mysqlreports.com/examples/creating-reports-with-subtotals-and-grand-totals-using-smart-report-engine/)

---

### 4. Dynamic Filters

Supports parameterized, interactive reports where users can define input criteria, such as date ranges, at runtime.

**Example:**
- Generate a sales report filtered by user-selected date range.

### 5. Time Filters

Including built-in options for common date-based filters:
- **Is Today:** Filters for current day.
- **Is Current Month:** Filters for ongoing month.
- **Is Current Year:** Filters for the current year.

These simplify creation of daily, monthly, and yearly reports.

---

## Support and Resources

- **Support Ticket:** [Open Support Ticket](https://mysqlreports.com/open-ticket/)
- **FAQ:** [Frequently Asked Questions](https://mysqlreports.com/faq/)
- **Documentation:** [Smart Report Maker Documentation](https://mysqlreports.com/smart-report-maker-docs/smart-report-maker-docs/)
- **Video Tutorials:** [Video Tours](https://mysqlreports.com/webuccino-screencasts/)

---

## About Webuccino

Webuccino has been providing user-friendly reporting tools since 2007.  
**Learn more:** [About Webuccino](https://mysqlreports.com/about/)

### Social Media
- YouTube: [MrStarsoft2011](https://www.youtube.com/user/MrStarsoft2011)
- Vimeo: [Video Tour](https://vimeo.com/115685915)

---

## Additional Product Highlights
- PHP Reports for MySQL: [Link](https://mysqlreports.com/php-reports/)
- Report Linking & Chaining: [Link](https://mysqlreports.com/report-linking/)
- WordPress Reports & Dashboards: [Link](https://mysqlreports.com/srm-embed-smart-report-maker/)
- Application Reports & Dashboards: [Link](https://mysqlreports.com/srm-modules-embed-manager/)
- MySQL Pivot Tables: [Link](https://mysqlreports.com/php-mysql-pivot-tables/)
- PHP Dashboards: [Link](https://mysqlreports.com/php-dashboards-for-mysql/)
- PHP Charts: [Link](https://mysqlreports.com/php-charts/)
- Data Analysis for MySQL: [Link](https://mysqlreports.com/mysql-data-analysis/)
- Dashboard Management: [Link](https://mysqlreports.com/smart-report-maker-docs/docs/dashboards/mysql-dashboards-managing-and-customizing-your-data-insights/)
- PHP Form Builder: [Link](https://mysqlreports.com/php-mysql-form-generator/)
- PHP Reporting Library: [Link](https://mysqlreports.com/mysql-reporting-tools/smart-report-engine/)

---

## Support and Legal

- Customer Support: [Support Ticket](https://mysqlreports.com/open-ticket/)
- Privacy Policy: [Link](https://mysqlreports.com/privacy-policy/)
- About Webuccino: [Link](https://mysqlreports.com/about/)
- User Testimonials: [Link](https://mysqlreports.com/smart-report-maker-testimonials/)
- Sitemap: [Link](https://mysqlreports.com/web-sitemap/)

---

**Copyrights Reserved 2007 - 2025 © Webuccino.**

---

## Page: https://mysqlreports.com/blog/smart-report-maker-11-0-release-powerful-new-features

# Webuccino - Reporting Tools and Updates

## News
**Smart Report Maker 11.0 Release: Powerful New Features You’ll Love**  
*Posted October 12, 2025*

Smart Report Maker 11.0 is now available, featuring significant enhancements:

- **New WordPress Plugin**: Easily embed reports, charts, dashboards, pivot tables, and metrics into your website.
- **Embed Manager for PHP Applications**: Integrate analytics into PHP-based apps with resource linking and access keys.
- **Linked Reports (Report Chains)**: Pass parameters between reports for comprehensive data exploration.
- **Additional Features**:
  - Include barcodes and maps in reports
  - New layout options for better presentation
  - Duplicate existing reports quickly
  - Various other improvements for flexibility and efficiency

---

## Benefits of the New Version
- Embed dashboards and reports directly into PHP applications.
- Add reports and analytics to WordPress pages using the new plugin.
- Create report chains by linking related reports through parameter passing.
- Save time with duplicate-report and column-reordering features.
- Enhance data presentation with new layouts, barcodes, and maps.

---

## Smart Report Maker 11.0 Highlights
### WordPress Plugin
- Embed reports, charts, dashboards, pivot tables, and metrics directly into your WordPress website.  
[More details](https://mysqlreports.com/srm-embed-smart-report-maker/)

### Embed Manager for PHP Applications
- Integrate both public and private resources by specifying resources, generating access keys, and deploying PHP scripts.  
[More details](https://mysqlreports.com/srm-modules-embed-manager/)

### Linked Reports (Report Chains)
- Link multiple reports by passing parameters, enabling in-depth data exploration across connected reports.  
[More details](https://mysqlreports.com/report-linking/)

### Barcodes & Maps in Reports
- Support for barcode and map visuals enhances interactivity and location tracking in reports.

### New Report Layouts
- Diverse layout options for improved structure and presentation.

### Duplicate Reports
- Quickly duplicate reports to streamline report creation.

### Other Enhancements
- Various improvements to enhance speed, ease of use, and functionality.

---

## Demonstrations of New Features
### Example 1: Embedded Linked Invoices Per Customer Report in WordPress
- Users can navigate from a summarized invoice report to detailed invoice items, product info, and supplier data.
- Demonstrates report linking, layouts, barcodes, and WordPress embedding.
[View example](https://demo.mysqlreports.com/wordpress/?page_id=67)

### Example 2: Embedded Sales Dashboard in WordPress
- Interactive dashboard with multiple charts, metrics, pivot table, and reports.
[View example](https://demo.mysqlreports.com/wordpress/?page_id=93)

### Example 3: Product Catalog in WordPress  
- Linked reports allow view of product details, associated invoices, customers, and sales reps.  
[View example](https://demo.mysqlreports.com/wordpress/)

### Video Guides
- Detailed tutorials for each new feature.  
[View video tours](https://mysqlreports.com/webuccino-screencasts/)

---

## Related Links
- [More about Report Linking](https://mysqlreports.com/report-linking/)
- [More about WordPress Plugin](https://mysqlreports.com/srm-embed-smart-report-maker/)
- [More about Embed Manager](https://mysqlreports.com/srm-modules-embed-manager/)
- [Video Tutorials](https://mysqlreports.com/webuccino-screencasts/)
- [Try the Demo Version](https://demo.mysqlreports.com/)

---

## About Webuccino
Webuccino has been creating easy-to-use reporting tools since 2007.  
[Read more](https://mysqlreports.com/about/)

### Connect with Webuccino
- [YouTube](https://www.youtube.com/user/MrStarsoft2011)
- [Vimeo](https://vimeo.com/115685915)

---

## Webuccino Highlights (Select)
- [PHP Reports for MySQL](https://mysqlreports.com/php-reports/)
- [Report Linking & Chaining](https://mysqlreports.com/report-linking/)
- [WordPress Reports & Dashboards](https://mysqlreports.com/srm-embed-smart-report-maker/)
- [Application Reports & Dashboards](https://mysqlreports.com/srm-modules-embed-manager/)
- [MySQL Pivot Tables](https://mysqlreports.com/php-mysql-pivot-tables/)
- [PHP Dashboards](https://mysqlreports.com/php-dashboards-for-mysql/)
- [PHP Charts](https://mysqlreports.com/php-charts/)
- [MySQL Data Analysis](https://mysqlreports.com/mysql-data-analysis/)
- [Manage Dashboards](https://mysqlreports.com/smart-report-maker-docs/docs/dashboards/mysql-dashboards-managing-and-customizing-your-data-insights/)
- [PHP Form Builder](https://mysqlreports.com/mysql-reporting-tools/php-mysql-form-generator/)
- [Reporting Library](https://mysqlreports.com/mysql-reporting-tools/smart-report-engine/)

---

## Help & Support
- [Customer Support](https://mysqlreports.com/open-ticket/)
- [FAQ](https://mysqlreports.com/faq/)
- [Documentation](https://mysqlreports.com/mysql-report-generator-manual/)
- [Video Tours](https://mysqlreports.com/webuccino-screencasts/)
- [Demo Version](https://demo.mysqlreports.com/)

---

## Legal & Contact
- © Webuccino 2007 - 2025
- [Privacy Policy](https://mysqlreports.com/privacy-policy/)
- [About Webuccino](https://mysqlreports.com/about/)
- [User Testimonials](https://mysqlreports.com/smart-report-maker-testimonials/)
- [Sitemap](https://mysqlreports.com/web-sitemap/)

---

## Page: https://mysqlreports.com/blog/smart-report-maker-version-8-0-0-has-been-released

# Main Content

## Blog Post: Smart Report Maker Version 8.1.0 Has Been Released!

**Category:** News  
**Posted:** July 21, 2021

We are excited to announce the release of **Smart Report Maker 8.1.0**, which introduces new features and bug fixes.

### New Report Designs
- Enhanced design and themes for generated reports.
- Demo report available [here](https://mysqlreports.com/SRM7-demo/SRM/Reports8/repitems/repitems.php).

### Subtotals and Grand Totals
- Ability to include subtotals and grand totals in reports.
- Calculations include sum, average, minimum, maximum, and count for columns.
- Example: Create an ‘orders per region’ report with subtotals at the end of each section and a grand total at the end.
- To add subtotals: select the desired summary function and columns as shown in the report generator wizard.

*Note:* Grand totals are calculated from detailed rows—not from subtotals.

### Improved Exporting Options (especially for eastern languages)
- Export to PDF enhancements:
  - Export headers and footers on all report pages.
  - Export grouping and subtotal information.
- PDF exports now support languages like Arabic, Hebrew, and Chinese.

### Create Daily Reports
- New data filters such as `is_today` for generating daily reports.
- Supports combining multiple filters with AND/OR operators.

### PHP Compatibility
- Fully compatible with PHP 7.4 or earlier.

### Bug Fixes
- Addressed all reported issues in previous versions.

### Upgrade
- [Upgrade to version 8.1.0](https://sites.fastspring.com/mysqlreportsmysql-reporting-tools/smart-report-engine/product/smartreportmaker810offer)

### Demo Reports
- [Stock Report](https://mysqlreports.com/SRM7-demo/SRM/Reports8/repitems/repitems.php)
- [Stock Per Item – Parameterized](https://mysqlreports.com/SRM7-demo/SRM/Reports8/repitems2/repitems2.php)
- [Orders Per Country](https://mysqlreports.com/SRM7-demo/SRM/Reports8/repOrders/repOrders.php)
- [Employees Per Branch](https://mysqlreports.com/SRM7-demo/SRM/Reports8/repEmployees/repEmployees.php)

---

## About Webuccino

Webuccino has been creating easy-to-use reporting tools since 2007.  
[Read more](https://mysqlreports.com/about/).

Follow us on YouTube and Vimeo:
- ![YouTube](https://img.icons8.com/ios-filled/24/000000/youtube-play.png) [YouTube Channel](https://www.youtube.com/user/MrStarsoft2011)
- ![Vimeo](https://img.icons8.com/ios-filled/24/000000/vimeo.png) [Vimeo](https://vimeo.com/115685915)

---

## Highlights of Webuccino's Products

- [PHP Reports for MySQL](https://mysqlreports.com/php-reports/)
- [Report Linking & Chaining](https://mysqlreports.com/report-linking/)
- [Reports & Dashboards in WordPress](https://mysqlreports.com/srm-embed-smart-report-maker/)
- [Reports & Dashboards in Your Application](https://mysqlreports.com/srm-modules-embed-manager/)
- [MYSQL Pivot Tables](https://mysqlreports.com/php-mysql-pivot-tables/)
- [PHP Dashboards for MYSQL](https://mysqlreports.com/php-dashboards-for-mysql/)
- [PHP Charts for MYSQL](https://mysqlreports.com/php-charts/)
- [MySQL Data Analysis](https://mysqlreports.com/mysql-data-analysis/)
- [Manage Dashboards](https://mysqlreports.com/smart-report-maker-docs/docs/dashboards/mysql-dashboards-managing-and-customizing-your-data-insights/)
- [PHP Form Builder for MySQL](https://mysqlreports.com/mysql-reporting-tools/php-mysql-form-generator/)
- [Reporting Library](https://mysqlreports.com/mysql-reporting-tools/smart-report-engine/)

---

## Help & Support

- [Customer Support](https://mysqlreports.com/open-ticket/)
- [FAQ](https://mysqlreports.com/faq/)
- [Docs](https://mysqlreports.com/mysql-report-generator-manual/)
- [Video Tours](https://mysqlreports.com/webuccino-screencasts/)
- [Demo Version](https://demo.mysqlreports.com/login)

---

## Footer Links

- [Privacy Policy](https://mysqlreports.com/privacy-policy/)
- [About Webuccino](https://mysqlreports.com/about/)
- [User Testimonials](https://mysqlreports.com/smart-report-maker-testimonials/)
- [Sitemap](https://mysqlreports.com/web-sitemap/)

---

*Note: The above content is a direct extraction and organization of the main content of the web page, focusing on textual information and links relevant to the site's offerings, updates, and resources. No API endpoint reference or technical API documentation was present in the main content section.*

---

## Page: https://mysqlreports.com/blog/smart-report-maker-version-8-2-0-has-been-released

# Web report tools and updates

## Overview

This document provides updates and features related to Smart Report Maker and other reporting tools developed by Webuccino. It includes recent release highlights, descriptions of new features, and useful links for documentation, support, and tutorials.

---

## Latest Release of Smart Report Maker

### Version 8.2.0 — Released June 26, 2022

Webuccino announced the release of **Smart Report Maker 8.2.0**, which introduces several new features, enhancements, and bug fixes to improve reporting capabilities.

#### Key Highlights

### Calculated Columns
- **Description**: Virtual columns not physically stored in the database. Their values are calculated dynamically from one or more other columns.
- **Features**:
  - Add calculated columns to your reports.
  - Compute subtotals and grand totals for these columns.
- **Additional Resources**: For detailed instructions, see the [tutorial on creating calculated columns](https://mysqlreports.com/blog/create-calculated-columns-in-your-reports/).

### Enhanced Date Filters
- **Description**: New filters to simplify report creation for specific timeframes.
- **New Options**:
  - **Is Today**: Filters data for the current day.
  - **Is Current Month**: Filters for data in the current month.
  - **Is Current Quarter**: Filters for data in the current quarter.
  - **Is Current Year**: Filters for data in the current year.
- **Benefit**: Enables easy building of daily, monthly, quarterly, and annual reports.

### PHP Compatibility
- **Tested with PHP 8.1.7**: Both versions 8.1 and 8.2 of Smart Report Maker are confirmed to work with the latest PHP version, ensuring compatibility and security.

### Additional Information
- For more details or to purchase, visit: [Smart Report Maker 8.2.0 Offer](https://sites.fastspring.com/mysqlreportsengine/product/smartreportmaker810offer).

---

## About Webuccino

- **Duration**: Since 2007
- **Focus**: Creating user-friendly reporting tools.
- **Learn More**: [Read about Webuccino](https://mysqlreports.com/about/).

### Social Media & Video Resources
- [YouTube Channel](https://www.youtube.com/user/MrStarsoft2011)
- [Vimeo Channel](https://vimeo.com/115685915)

---

## Product Highlights and Links

### Reporting Tools & Modules
- [PHP Reports for MySQL](https://mysqlreports.com/php-reports/)
- [Report Linking & Chaining](https://mysqlreports.com/report-linking/)
- [WordPress Reports & Dashboards](https://mysqlreports.com/srm-embed-smart-report-maker/)
- [Application Reports & Dashboards](https://mysqlreports.com/srm-modules-embed-manager/)
- [MySQL Pivot Tables](https://mysqlreports.com/php-mysql-pivot-tables/)
- [PHP Dashboards for MySQL](https://mysqlreports.com/php-dashboards-for-mysql/)
- [PHP Charts for MySQL](https://mysqlreports.com/php-charts/)
- [MySQL Data Analysis](https://mysqlreports.com/mysql-data-analysis/)
- [Manage Dashboards](https://mysqlreports.com/smart-report-maker-docs/docs/dashboards/mysql-dashboards-managing-and-customizing-your-data-insights/)
- [PHP Form Builder for MySQL](https://mysqlreports.com/mysql-reporting-tools/php-mysql-form-generator/)
- [Reporting Library](https://mysqlreports.com/mysql-reporting-tools/smart-report-engine/)

### Help & Support
- [Customer Support Tickets](https://mysqlreports.com/open-ticket/)
- [FAQ](https://mysqlreports.com/faq/)
- [Documentation](https://mysqlreports.com/mysql-report-generator-manual/)
- [Video Tours](https://mysqlreports.com/webuccino-screencasts/)
- [Demo Version](https://demo.mysqlreports.com/login)

---

## Summary

Webuccino continues to improve and expand its reporting tools, with the latest release (8.2.0) featuring highly requested functionalities such as calculated columns and improved date filtering. These updates facilitate the creation of more versatile and insightful reports, compatible with the latest PHP versions.

---

*All URLs provided are official resources for further reading, support, or purchase.*

---

## Page: https://mysqlreports.com/buy

# Webuccino Main Content Summary

The webpage primarily promotes products related to MySQL reporting and data visualization tools, including purchasing options, and provides some company background and highlights. Below is a structured summary focusing on the main content:

---

## Purchase Options for Webuccino Products

### Smart Report Engine
- **Price:** $64
- **Description:** A PHP reporting library designed for creating reports from MySQL databases.
- **Purchase Link:** [Purchase Smart Report Engine](https://sites.fastspring.com/mysqlreportsengine/product/smartreportengineregularlicense)

### Smart Form Maker
- **Price:** $48
- **Description:** A tool for generating web forms connected to MySQL databases.
- **Purchase Link:** [Purchase Smart Form Maker](https://sites.fastspring.com/mysqlreportsengine/product/smartformmaker)

### Payment Processing
- Orders are processed through **FastSpring**, a trusted platform serving global software sales.
- **More info:** [FastSpring](https://fastspring.com/)

---

## About Webuccino
- Creating easy-to-use reporting tools since 2007.
- **Read more:** [Webuccino About Page](https://mysqlreports.com/about/)

## Social Media & Video Tours
- YouTube: [Webuccino YouTube Channel](https://www.youtube.com/user/MrStarsoft2011)
- Vimeo: [Webuccino Vimeo](https://vimeo.com/115685915)

---

## Highlights of Webuccino Products and Services
- PHP Reports for MySQL
- Report Linking & Chaining
- Embedding Reports & Dashboards in WordPress
- Embedding Reports & Dashboards in Applications
- MYSQL Pivot Tables
- PHP Dashboards for MySQL
- PHP Charts for MySQL
- MySQL Data Analysis
- Managing Dashboards
- PHP Form Builder for MySQL
- Easy-to-Use PHP Reporting Library

### Support & Documentation
- Customer Support: [Open a Ticket](https://mysqlreports.com/open-ticket/)
- FAQ: [Frequently Asked Questions](https://mysqlreports.com/faq/)
- Docs: [Report Generator Manual](https://mysqlreports.com/mysql-report-generator-manual/)
- Video Tutorials: [Webuccino Screencasts](https://mysqlreports.com/webuccino-screencasts/)
- Demo Version: [Demo Login](https://demo.mysqlreports.com/login)

---

## Legal & Contact
- © Webuccino 2007 - 2025
- Privacy Policy: [Privacy Policy](https://mysqlreports.com/privacy-policy/)
- About Webuccino: [About Webuccino](https://mysqlreports.com/about/)
- User Testimonials: [Testimonials](https://mysqlreports.com/smart-report-maker-testimonials/)
- Sitemap: [Sitemap](https://mysqlreports.com/web-sitemap/)

---

**Note:** The webpage content does not describe any API endpoint, tutorials or how-to guides. The focus is on product marketing, purchasing options, and company information.

---

## Page: https://mysqlreports.com/faq

# FAQ - Smart Report Maker

## Introduction
Smart Report Maker is a no-code, self-hosted application that enables users to generate reports, charts, pivot tables, dashboards, KPIs, and scheduled reports directly from MySQL and MariaDB databases without writing any code. It is easy to install, supports embedding into PHP applications and WordPress sites, and offers a range of powerful features for both technical and non-technical users.

---

## Main Features and Benefits

- Secure connection to MySQL/MariaDB databases
- Visual report, chart, pivot table, and dashboard creation
- Report chaining and linking for drill-down analysis
- Automated report scheduling and delivery
- Secure embedding into PHP applications and WordPress
- Support for rich visual elements (barcodes, maps, images, etc.)
- Unlimited dashboard creation
- Support for multiple database connections
- User-friendly, wizard-based interface
- One-time purchase model with no subscription fees
- Compatibility with shared hosting, VPS, dedicated servers
- Easy installation via web-based installer or Docker

---

## Installation and Hosting Compatibility

### How to Install
- **Direct Upload Method**: Upload files, launch web installer in browser, no command-line needed.  
  Suitable for shared hosting, Windows, Linux, cPanel, Plesk, etc.  
  [Installation guide](https://mysqlreports.com/smart-report-maker-docs/docs/getting-started/installing-smart-report-maker-via-direct-upload-easiest-option/)

- **Docker-Based Installation**: Supports creating a new Docker Compose stack or adding to existing Docker environments.  
  [Docker installation details](https://mysqlreports.com/smart-report-maker-docs/docs/getting-started/docker-installation/)

### System Requirements (for Direct Upload)
- Operating System: Windows or Linux
- Web Server: Apache or Nginx
- PHP Version: 7.4 or later
- Database: MySQL or MariaDB
- Supported Control Panels: cPanel, Plesk, DirectAdmin, Webmin, Virtualmin, ISPConfig, CyberPanel, HestiaCP, VestaCP, aaPanel, Ajenti, Froxlor, SolidCP, CloudPanel, RunCloud, ServerPilot, Laravel Forge, and others.

### Supported Hosting Platforms
- Compatible with all hosting control panels supporting PHP
- Works on Linux and Windows servers
- Fully compatible with shared hosting, VPS, dedicated servers

---

## Why Choose Smart Report Maker
- Trusted since 2007 by thousands globally
- No coding skills required
- Easy web-based installation
- Full data privacy — runs on your own server
- One-time payment, no hidden fees
- Secure and private report embedding
- Supports multiple databases and concurrent applications
- Can be branded with your business identity

---

## New Features (Latest Version)
- Embedding dashboards into PHP apps
- WordPress plugin for reports
- Advanced report linking and report chains
- Productivity tools (duplicate reports)
- Improved visual layouts, barcode, and map visuals
- Trend analysis with time-series charts
- Filtering reports and charts dynamically
- Comparing metrics over time (KPIs)
- Embed Manager for secure report integration

[More about new features](https://mysqlreports.com/blog/smart-report-maker-11-0-release-powerful-new-features/)

---

## Usage and Demos

- **Online demo**: [https://demo.mysqlreports.com/](https://demo.mysqlreports.com/)
- **Feature walkthrough videos**: [https://mysqlreports.com/webuccino-screencasts/](https://mysqlreports.com/webuccino-screencasts/)
- **WordPress plugin**: [https://wordpress.org/plugins/srm-embed-smart-report-maker/](https://wordpress.org/plugins/srm-embed-smart-report-maker/)
- **Embedded examples**: [WordPress reports](https://demo.mysqlreports.com/wordpress/?page_id=93)

---

## Embedding Reports and Dashboards
- Securely embed into PHP apps/websites using Embed Manager  
- Generate secure embed codes that display only the report, without SRM menus  
- Supports multiple domains via origin restrictions  
- Customizable embed scripts  
- No extra costs on traffic or views; unlimited usage  
- Embed into WordPress via dedicated plugin  

[Learn more about Embed Manager](https://mysqlreports.com/srm-modules-embed-manager/)

---

## Visual Elements and Interactivity
- Supports rich visual report cells: barcodes, QR codes, maps, images, checkboxes, star ratings, flags, clickable links, formatted currency/percentages
- Interactive dashboards with drill-down and filtering
- Combine widgets from multiple databases into single dashboards
- Dynamic filters: date ranges, dropdowns, sliders
- Support for time-series trending charts
- Filter charts and reports by multiple criteria
- Interactive, clickable charts for detailed analysis

---

## Report Linking & Drill-Down
- Link reports (e.g., Customers → Accounts → Invoices)
- Parent and Linked reports: parent sends parameters, linked filters data accordingly
- Support for report chains across multiple levels
- Passing URL parameters for embedded or external report navigation
- Compatible with embedded reports in websites and applications

[Learn about report linking](https://mysqlreports.com/report-linking/)

---

## User Management and Security
- Manage multiple database connections and multiple applications
- Restrict embedding using origin policies and access keys
- Secure tokens stored with WordPress salts
- Fully configurable access permissions
- Branding with your logo

---

## Dashboard and Chart Building
- Unlimited PHP dashboards
- Multiple widget types: reports, KPIs, charts, pivot tables
- Drill-down capabilities
- Combine data from different sources
- Create advanced time-series and filtered charts
- Export reports in formats like PDF

---

## Forms and Data Management
- Create various forms: columnar, editable grids, mobile-friendly, master-detail
- Support for AJAX submission for smooth, real-time data entry
- Build pivot tables visually
- Group date fields into months, quarters, weekdays
- Dynamic filtering for end-user customization

---

## Support for Developers
- Smart Report Engine: API for integration into custom PHP projects
- Create PHP pivot tables without SQL coding
- Build interactive, filterable, drill-down charts
- Suitable for large datasets and complex reporting workflows

---

## Pricing, Licensing, and Support
- One-time payment, no subscription fees
- Secure purchase via FastSpring
- Support is free, with priority for paid users
- Support tickets for assistance  
  [Open a support ticket](https://mysqlreports.com/open-ticket/)

---

## Additional Resources
- Documentation and tutorials available at: [Docs](https://mysqlreports.com/mysql-reporting-tools/)
- Video tutorials: [Webuccino screencasts](https://mysqlreports.com/webuccino-screencasts/)
- Blog with updates and features: [Blog](https://mysqlreports.com/blog/)
- About Webuccino: [About Webuccino](https://mysqlreports.com/about/)

---

## Summary
Smart Report Maker provides a comprehensive, easy-to-use solution for creating, embedding, and managing reports and analytics from MySQL/MariaDB databases. Its flexible architecture, extensive features, and straightforward installation make it suitable for developers, analysts, and business users alike. With a one-time purchase model, security-focused embedding, and support for custom dashboards and KPIs, it is an ideal choice for self-hosted reporting needs.

---

## Page: https://mysqlreports.com/mysql-data-analysis

# MySQL Data Analysis with SRM Modules

## Overview
Smart Report Maker (SRM) is a powerful PHP-based data analysis tool tailored specifically for MySQL databases. It transforms raw data into actionable insights through intuitive visualizations, dynamic filtering, and advanced calculations. Whether you're a data analyst, business owner, or developer, SRM provides the tools to understand your data and improve performance.

## Key Features
### 1. Drill-Down Insights
- Interactively explore data.
- Click through dashboards to detailed reports.
- Uncover root causes of trends and anomalies.

### 2. Date-Series Analysis
- Visualize data over time with sophisticated time-series charts.
- Identify seasonality, growth trends, and spikes.
- Facilitate quick reactions and planning.

### 3. Historical Data Comparison
- Compare performance across timeframes:
  - Same period last year (e.g., Q2 2025 vs Q2 2024).
  - Preceding periods (e.g., last month vs this month).
  - Fixed targets to assess KPI achievement.

### 4. Pivot Tables for Dynamic Exploration
- Summarize, group, and rearrange large datasets.
- Deepen analysis with pivot table functionality.
- Learn more about MySQL Pivot Tables in SRM: [Learn more](https://mysqlreports.com/php-mysql-pivot-tables/)

### 5. Dynamic Data Filters
- Apply static and dynamic filters.
- Filter by day, week, month, quarter, or custom periods.
- Focus on relevant data segments.

## KPI Management
### 1. Define Business-Centric KPIs
- Customize KPIs to match business goals.
- Examples:
  - Total sales this month.
  - Number of high-value orders.
  - Unique customer counts by region.

### 2. Comparative Insights with Flexible Timeframes
- Track performance vs last year.
- Monitor quarter-over-quarter trends.
- Compare against strategic targets.

### 3. Advanced Conditional Calculations
- Incorporate conditional logic to refine metrics:
  - Count transactions over $100.
  - Calculate average order size in a city.
  - Sum revenue for a category.
  - Calculate percentage of female employees.

### 4. Flexible KPI Display & Formats
- Customize presentation:
  - Currency formats (e.g., $1.2K / $1,200).
  - Percentages.
  - Custom units (e.g., Kg, Hours).
  - Contribution percentages.
- Display using:
  - Info boxes.
  - Gauge charts.
  - Line/trend charts.
- Ensure insights are easy to interpret and share.

### 5. Smart Filtering for Focus
- Filter KPIs/charts by:
  - Specific months, quarters.
  - Custom date ranges.
  - Other business conditions.
- Maintain targeted, meaningful analysis.

## Frequently Asked Questions (FAQ)
### Q1: How does SRM help analyze MySQL and MariaDB data with dashboards and visualizations?
**A:** SRM converts MySQL and MariaDB data into clear insights using interactive dashboards, charts, pivot tables, and KPIs. Users can visualize metrics, explore trends, and drill down for detailed understanding.

### Q2: Does SRM support historical data comparisons like year-over-year analysis?
**A:** Yes. It enables comparisons across different timeframes, including same period last year, previous periods, and against fixed KPIs.

### Q3: Can I define custom KPIs and metrics based on my business?
**A:** Absolutely. You can create KPIs such as total sales, high-value orders, or unique customer counts aligned with your business rules.

### Q4: Does SRM support gauge charts for KPIs?
**A:** Yes. It supports various display formats, including gauge charts.

### Q5: Where can I find documentation and tutorials for building KPIs?
**A:** Documentation is available in the [Smart Report Maker Docs](https://mysqlreports.com/smart-report-maker-docs/docs/kpis/comprehensive-kpi-methods-for-php-data-analysis/).  
You can also follow this [step-by-step tutorial](https://mysqlreports.com/smart-report-maker-docs/docs/kpis/30-days-orders-count-kpi-example-for-mysql-data-analysis/) to create KPIs tracking sales over the last 30 days.

## Conclusion
SRM simplifies MySQL data analysis by providing a feature-rich, intuitive platform for transforming data into actionable insights. Its dynamic filters, drill-down capabilities, historical comparisons, and flexible KPI engine empower businesses to make smarter, faster decisions using their own MySQL data.

---

**About Webuccino**  
Webuccino has been creating easy-to-use reporting tools since 2007. [Read more](https://mysqlreports.com/about/).

## Additional Resources
- [PHP Reports for MySQL](https://mysqlreports.com/php-reports/)
- [Report Linking & Chaining](https://mysqlreports.com/report-linking/)
- [Reports & Dashboards in WordPress](https://mysqlreports.com/srm-embed-smart-report-maker/)
- [Embed Reports & Dashboards in Your Application](https://mysqlreports.com/srm-modules-embed-manager/)
- [MySQL Pivot Tables](https://mysqlreports.com/php-mysql-pivot-tables/)
- [PHP Dashboards for MySQL](https://mysqlreports.com/php-dashboards-for-mysql/)
- [PHP Charts for MySQL](https://mysqlreports.com/php-charts/)
- [Data Analysis in MySQL](https://mysqlreports.com/mysql-data-analysis/)

## Support & Documentation
- [Customer Support](https://mysqlreports.com/open-ticket/)
- [FAQ](https://mysqlreports.com/faq/)
- [Documentation](https://mysqlreports.com/mysql-report-generator-manual/)
- [Video Tours](https://mysqlreports.com/webuccino-screencasts/)
- [Demo Version](https://demo.mysqlreports.com/login)

---

## Page: https://mysqlreports.com/mysql-forms-demo/wizard/step_2.php

# PHP MySQL Form Maker Demo

This document provides instructions for entering your MySQL database parameters to set up a PHP MySQL Form Maker.

---

## Step-by-step Instructions

### 1. Enter MySQL Database Parameters

You will need the following information:

- **Hostname**: The address of your MySQL server (e.g., `localhost`, `127.0.0.1`, or your server's IP address).
- **Username**: Your MySQL username.
- **Password**: The password associated with your MySQL username.
- **Select Database**: Choose the database you wish to work with (e.g., `database`).

### 2. Select a Table

Once connected, select the specific table in your database that you want to generate forms for. The available tables include:

- `categories`
- `customers`
- `employees`
- `items`
- `order_details`
- `orders`
- `products`
- `shippers`
- `suppliers`

### 3. Choose Form Actions

Specify which actions you want to enable on the selected table:

- **Insert**: To add new records.
- **Update**: To modify existing records.
- **Delete**: To remove records.

---

## Visual Layout of the Parameters Entry Form

```plaintext
+-------------------------------------------------+
| Please enter MySQL database parameters           |
+-------------------------------------------------+
| Hostname:       [__________________________]    |
| Username:       [__________________________]    |
| Password:       [__________________________]    |
| Select Database: [__________________________]   |
|                                                 |
| Select Table:                                   |
| [ categories ]                                 |
| [ customers ]                                  |
| [ employees ]                                  |
| [ items ]                                      |
| [ order_details ]                              |
| [ orders ]                                     |
| [ products ]                                   |
| [ shippers ]                                   |
| [ suppliers ]                                  |
|                                                 |
| Select Form Actions:                            |
| [Insert]                                       |
| [Update]                                       |
| [Delete]                                       |
+-------------------------------------------------+
```

---

## Notes:
- The selection of the table is made from a dropdown list.
- The form allows selecting multiple actions.
- All inputs should be filled out with valid MySQL credentials and the desired table.

---

*This concludes the instructions for entering MySQL parameters in the PHP MySQL Form Maker demo.*

---

## Page: https://mysqlreports.com/mysql-report-generator-manual

# Webuccino Smart Report Maker Documentation

## Overview

Webuccino has been creating easy-to-use reporting tools since 2007. The platform provides a suite of tools for generating reports, dashboards, charts, KPIs, and scheduled reports from MySQL databases with various installation options and extensive configuration capabilities. This document summarizes key sections and guides available for users.

---

## Getting Started

The "Getting Started" section offers a detailed walkthrough of the different installation methods for Smart Report Maker (SRM):

1. **Installation Methods**
   - Choose the appropriate installation approach based on your hosting environment, whether shared hosting, VPS, dedicated server, or cPanel.
   - Follow step-by-step instructions tailored to each method:
     - Direct Upload (recommended for most environments)
     - cPanel
     - Plesk
     - CWP (Control Web Panel)
     - Composer
     - Docker
     - Existing Docker Stack
     - Web Installation Wizard

2. **Steps for Installation**
   - Select your hosting environment.
   - Follow the corresponding step-by-step guide:
     - For example, to install via cPanel:
       - Log into your cPanel account.
       - Upload SRM files.
       - Run the installer wizard.
       - Configure database connection.
     - For Docker:
       - Set up Docker environment.
       - Pull SRM Docker image.
       - Configure containers.
   - Troubleshoot common installation issues with provided tips.

---

## Configuration Settings

The "Settings" section includes guides on:

- **Group Management**: Create and manage user groups.
- **User Management**: Add, edit, and assign permissions to users.
- **Mail Settings**: Configure SMTP for email notifications and scheduled report delivery.
- **Data Connections**: Set up multiple data sources for reports.
- **Branding and Other Settings**: Customize with company logo, organization name, and other preferences.

---

## Reports, Charts, and KPIs

### Reports

- Manage and create reports from MySQL databases.
- Customize data presentation and layout.
- Generate insightful and tailored reports.

### Charts

- Build and manage various data visualizations.
- Support drill-down functionality for detailed data analysis.
- Export charts to PDF for sharing.

### Metrics / KPIs

- Monitor key performance indicators directly from the database.
- Display KPIs as info boxes or gauge charts.
- Support comparisons with historical data and targets.

---

## Dashboards and Scheduled Reports

### Dashboards

- Create personalized dashboards by adding widgets that showcase KPIs, charts, or reports.
- Users can design multiple dashboards.
- Quick access to key data points.

### Scheduled Reports

- Automate report delivery by scheduling reports.
- Distribute reports hourly, daily, monthly, or quarterly.
- Ensures consistent and timely sharing with stakeholders.

---

## Upgrades and Help Center

### Upgrade

- Upgrade SRM from version 9.0 or later to the latest version:
  - via cPanel
  - via Plesk
  - via CWP
  - using Composer
  - via Docker

### Help Center

- Addresses common issues with step-by-step solutions.
- Enhances user troubleshooting capabilities.

---

## Additional Resources

- Articles on related technologies: Docker, Composer, cPanel, PHP.
- Guides and tools for expanding platform capabilities.

---

## Support and Community

- Open support tickets
- FAQs
- Video tutorials and screencasts

---

## About Webuccino

Webuccino has been delivering user-friendly reporting solutions since 2007. For more information, visit [about Webuccino](https://mysqlreports.com/about/).

Connect with Webuccino:
- [YouTube](https://www.youtube.com/user/MrStarsoft2011)
- [Vimeo](https://vimeo.com/115685915)

---

## Highlights and Additional Products

### Highlights
- PHP Reports for MySQL
- Report Linking & Chaining
- WordPress Reports & Dashboards
- Application Embeddable Reports
- MySQL Pivot Tables
- PHP Dashboards and Charts
- Data Analysis tools

### Related Resources
- Comprehensive PHP report library
- Form builder
- Data analysis tools

### Support Links
- Customer Support
- FAQ
- Documentation
- Video Tours
- Demo Version

---

## External Resources

- Using SSH with cPanel
- Why Use Docker?
- Docker vs VMs
- Common Docker Issues
- What is Composer?
- Email Settings in cPanel

---

*Note:* The original content does not describe any specific API endpoints. The documentation provided pertains mainly to installation, configuration, and feature guides for the Smart Report Maker platform.

---

## Page: https://mysqlreports.com/mysql-reporting-tools

# MySQL Reporting Tools

## Overview
Webuccino has been creating easy-to-use reporting tools since 2007, focusing on solutions for MySQL and MariaDB databases. Their product suite includes tools for report building, form generation, pivot tables, and reporting libraries.

## Products

### 1. [Smart Report Maker](https://mysqlreports.com/mysql-reporting-tools/the-best-mysql-report-builder/)
An advanced PHP-based report builder and dashboard tool for MySQL and MariaDB. Features include:
- Dynamic PHP dashboards
- Interactive pivot tables
- Scheduled report generation
- And more...

**Continue Reading:** [Link](https://mysqlreports.com/mysql-reporting-tools/the-best-mysql-report-builder/)

---

### 2. [Smart Form Maker](https://mysqlreports.com/mysql-reporting-tools/php-mysql-form-generator/)
A user-friendly tool to build AJAX forms for managing records in MySQL and MariaDB databases with minimal effort.

**Continue Reading:** [Link](https://mysqlreports.com/mysql-reporting-tools/php-mysql-form-generator/)

---

### 3. [Smart Pivot Table](https://mysqlreports.com/mysql-reporting-tools/mysql-pivot-table/)
A simple PHP reporting tool that transforms raw data from MySQL into web-based pivot tables without coding.

**Continue Reading:** [Link](https://mysqlreports.com/mysql-reporting-tools/mysql-pivot-table/)

---

### 4. [Smart Report Engine](https://mysqlreports.com/mysql-reporting-tools/smart-report-engine/)
A PHP reporting library for developers. It allows programmatic generation of polished reports from MySQL or MariaDB within code.

**Continue Reading:** [Link](https://mysqlreports.com/mysql-reporting-tools/smart-report-engine/)

---

## Watch the Demonstrations
### Smart Report Maker
[Watch on YouTube](https://www.youtube.com/watch?v=HLy5ciY4weg)

### Smart Form Maker
[Watch on YouTube](https://www.youtube.com/watch?v=qGaoMpwz3yQ)

### Smart Report Engine
[Watch on YouTube](https://www.youtube.com/watch?v=ZLa24Eo5gmE)

---

## About Webuccino
Webuccino has been creating reporting solutions since 2007.  
[Read more](https://mysqlreports.com/about/)

Follow on:
- [YouTube](https://www.youtube.com/user/MrStarsoft2011)
- [Vimeo](https://vimeo.com/115685915)

---

## Highlights and Features
- [PHP Reports for MySQL](https://mysqlreports.com/php-reports/)
- [Report Linking & Chaining](https://mysqlreports.com/report-linking/)
- [Reports & Dashboards in WordPress](https://mysqlreports.com/srm-embed-smart-report-maker/)
- [Reports & Dashboards in Your Application](https://mysqlreports.com/srm-modules-embed-manager/)
- [MySQL Pivot Tables](https://mysqlreports.com/php-mysql-pivot-tables/)
- [PHP Dashboards for MySQL](https://mysqlreports.com/php-dashboards-for-mysql/)
- [PHP Charts for MySQL](https://mysqlreports.com/php-charts/)
- [MySQL Data Analysis](https://mysqlreports.com/mysql-data-analysis/)
- [Manage Dashboards](https://mysqlreports.com/smart-report-maker-docs/docs/dashboards/mysql-dashboards-managing-and-customizing-your-data-insights/)
- [PHP Form Builder for MySQL](https://mysqlreports.com/mysql-reporting-tools/php-mysql-form-generator/)
- [Easy-to-Use PHP Reporting Library](https://mysqlreports.com/mysql-reporting-tools/smart-report-engine/)

---

## Help & Support
- [Customer Support](https://mysqlreports.com/open-ticket/)
- [FAQ](https://mysqlreports.com/faq/)
- [Docs](https://mysqlreports.com/mysql-report-generator-manual/)
- [Video Tours](https://mysqlreports.com/webuccino-screencasts/)
- [Demo Version](https://demo.mysqlreports.com/login)

---

## Legal & Contact
- [Privacy Policy](https://mysqlreports.com/privacy-policy/)
- [About Webuccino](https://mysqlreports.com/about/)
- [User Testimonials](https://mysqlreports.com/smart-report-maker-testimonials/)
- [Sitemap](https://mysqlreports.com/web-sitemap/)

---

*Note:* The content provided here is a direct conversion of the main content section of the webpage. There are no API endpoint references or tutorials requiring step-by-step API documentation or code samples in this content.

---

## Page: https://mysqlreports.com/mysql-reporting-tools/php-mysql-form-generator

# Smart Form Maker - Webuccino

## Overview
**Smart Form Maker** is a user-friendly PHP form generator designed for MySQL and MariaDB databases. It enables users to create various types of AJAX-powered forms with minimal effort, without requiring programming skills.

## Main Features
- **Intuitive Wizard Interface:** Seamlessly build forms through a step-by-step process.
- **Unlimited Dynamic Forms:** Manage many forms from a single database.
- **Supported Form Types:**
  - Columnar (standard forms)
  - Master-Details (sub-forms)
  - Editable Grids (batch processing)
  - Mobile Forms
  - Justified Forms
- **Data Management Capabilities:** Insert, update, search, navigate, and delete records.
- **Email Notifications:** Ability to send alerts upon form submission.
- **Multi-Style Forms:** Generate aesthetically diverse forms.
- **Security:** Password-protect any form.
- **Validation Rules:** Based on column data types.
- **Mobile-Friendly:** Responsive design for mobile devices.
- **AJAX Technology:** Submit data without page refresh.
- **Automatic Element Rendering:** Fields like dates turn into calendars; ENUMs become dropdowns.
- **Customizable:** Labels, themes, headers, footers, and error messages.
- **Foreign Keys Handling:** Simplifies complex database relationships.
- **Multiple Record Processing:** Editable grids.
- **Single License:** Install in up to five domains.
- **No Setup Hassles & Free Support.**

## Tutorials & Documentation
- [Building PHP MYSQL Master/Details Forms](https://mysqlreports.com/blog/subforms-in-php-mysql-form-maker/)
- [Video Tutorials](https://mysqlreports.com/video-tours/)
- [User Manual](https://mysqlreports.com/docs/sfm.pdf)

## System Requirements
- Web server (e.g., Apache, Nginx)
- PHP version 5 or higher
- MySQL or MariaDB

## Frequently Asked Questions (FAQ)

### Q: Is Smart Form Maker easy to install?  
**A:** Yes. It's a pure PHP application that requires only uploading files to your server. No command-line or complex server configurations needed.

### Q: Do I need programming skills to install or use it?  
**A:** No. It's designed for both technical and non-technical users, with an intuitive wizard interface.

### Q: Does it support both MySQL and MariaDB?  
**A:** Yes. It works seamlessly with both database engines.

### Q: Can I create master-detail (sub-form) forms?  
**A:** Yes. Supports managing related data across multiple tables on one page.  
For guidance, see: [Build master-detail forms](https://mysqlreports.com/blog/subforms-in-php-mysql-form-maker/).

### Q: What types of forms can I create? Do they support AJAX?  
**A:** Multiple types including columnar, editable grids, mobile, justified, and master-detail forms, all utilizing AJAX for smooth submission.

### Q: Is there a discount or promotion when purchasing?  
**A:** Yes. Cross-product promotions with Smart Report Maker often offer around 25% off. Check the checkout page for current deals.

## Demo & Documentation
[Try Demo Version](https://mysqlreports.com/Forms/demo/wizard/step_2.php)  
[Download User Manual (PDF)](https://mysqlreports.com/docs/sfm.pdf)

---

## About Webuccino
Webuccino has been creating easy-to-use reporting tools since 2007.  
[Read more about Webuccino](https://mysqlreports.com/about/).

## Additional Links & Media
- [YouTube Channel](https://www.youtube.com/user/MrStarsoft2011)
- [Vimeo Tour](https://vimeo.com/115685915)

## Highlights & Related Products
- [PHP Reports for MySQL](https://mysqlreports.com/php-reports/)
- [Report Linking & Chaining](https://mysqlreports.com/report-linking/)
- [Reports & Dashboards in WordPress](https://mysqlreports.com/srm-embed-smart-report-maker/)
- [CDC in Your Application](https://mysqlreports.com/srm-modules-embed-manager/)
- [MySQL Pivot Tables](https://mysqlreports.com/php-mysql-pivot-tables/)
- [PHP Dashboards for MySQL](https://mysqlreports.com/php-dashboards-for-mysql/)
- [PHP Charts for MySQL](https://mysqlreports.com/php-charts/)
- [MySQL Data Analysis](https://mysqlreports.com/mysql-data-analysis/)
- [Manage Dashboards](https://mysqlreports.com/smart-report-maker-docs/docs/dashboards/mysql-dashboards-managing-and-customizing-your-data-insights/)
- [PHP Form Builder for MySQL](https://mysqlreports.com/mysql-reporting-tools/php-mysql-form-generator/)
- [PHP Reporting Library](https://mysqlreports.com/mysql-reporting-tools/smart-report-engine/)

## Support & Contact
- [Customer Support Ticket](https://mysqlreports.com/open-ticket/)
- [FAQ](https://mysqlreports.com/faq/)
- [Documentation](https://mysqlreports.com/mysql-report-generator-manual/)
- [Video Tours](https://mysqlreports.com/webuccino-screencasts/)
- [Demo Version](https://demo.mysqlreports.com/login)
- [Privacy Policy](https://mysqlreports.com/privacy-policy/)
- [About Webuccino](https://mysqlreports.com/about/)
- [Testimonials](https://mysqlreports.com/smart-report-maker-testimonials/)
- [Sitemap](https://mysqlreports.com/web-sitemap/)

---

*This document is a conversion of the main content of the web page, focusing on the features and details about Smart Form Maker by Webuccino.*

---

## Page: https://mysqlreports.com/mysql-reporting-tools/smart-report-engine

# Products: Smart Report Engine

## Overview
The **Smart Report Engine** is a powerful PHP reporting library designed for MySQL databases. It enables developers to programmatically generate polished reports directly from MySQL or MariaDB within their PHP codebase. Compatible with native PHP and Laravel, it offers advanced reporting features such as grouping, filtering, conditional formatting, appearance customization, security options, and exporting capabilities.

---

## Quick Code Example

```php
use Sre\SmartReportEngine\src\CustomEngine;
use Sre\SmartReportEngine\src\ReportOptions;

class ReportService {
    public function generatePublicReport() {
        $report = new ReportOptions('PUBLIC_REPORT');
        $report->select_tables(['items'])
               ->set_grouping(['country'])
               ->set_layout('OUTLINE')
               ->select_all_fields();

        $engine = new CustomEngine($report);
        $report_path = $engine->create_report();
        return $report_path;
    }
}
```

**Generate Report Link:**  
[Generate Report](https://mysqlreports.com/engine/demo/sre_reports/rep1659165261820424/rep1659165261820424.php)

**More Examples:**  
[More Examples](https://mysqlreports.com/examples)

---

## Main Features
- Create unlimited reports for MySQL and MariaDB with extensive data filtration options.
- Support for selecting specific columns, multiple tables, views, or SQL queries.
- Multiple grouping levels to organize data (e.g., grouping sales reports by region, country, city).
- Dynamic filtering functions, including parameterized reports (e.g., date ranges).
- Filter reports based on the currently logged-in user to ensure personalized data view.
- Security functions for easy integration with existing login systems.
- Add subtotals and grand totals, including calculations (sum, average, min, max, count).
- Generate reports with calculated, virtual columns.
- Support for conditional formatting and cell styling based on data values.
- Customize report style, layout, headers, and footers.
- Export options for various formats.
- Mobile-friendly report layouts.

---

## Key Advantages
- **User-Friendly API:** Simplifies report creation in PHP.
- **Extensible:** Manage and expand reports directly from code.
- **Time-Saving:** Fully functional report generation reduces development, debugging, and maintenance time.
- **Dual Compatibility:** Available as a native PHP library and Laravel package.
- **Mobile Friendly:** Easily generate mobile-optimized reports.
- **Support:** Personalized support via the dedicated [support system](https://mysqlreports.com/support).

---

## Features in Detail
- **Unlimited Report Creation:** Supports multiple data filtration methods; choose columns and data sources flexibly.
- **Multiple Groupings:** Organize data hierarchically for detailed reports.
- **Dynamic Filters:** Create parameterized reports, e.g., date ranges, user-specific filters.
- **User-Based Filtering:** Show only records relevant to the logged-in individual.
- **Security:** Integration with login systems for secure report access.
- **Totals & Calculated Columns:** Summaries, averages, and custom calculated fields.
- **Conditional & Cell Formatting:** Visual cues based on data (e.g., low stock in red).
- **Custom Styles:** Adjust layout, headers, footers, and report appearance.
- **Export & Layout Options:** Flexible report outputs suitable for various devices.

---

## Frequently Asked Questions (FAQ)

**Q: What's the difference between Smart Report Maker and Smart Report Engine?**  
**A:**  
Smart Report Maker is a complete application with an interface for designing reports, charts, dashboards, and KPIs.  
Smart Report Engine, on the other hand, is a PHP library intended for developers to embed reporting capabilities directly into their PHP projects by calling its API programmatically.

---

**Q: How easy is it to install in my PHP project?**  
**A:**  
It's straightforward. The engine is provided as pure PHP files that can be added without command-line steps or complex setups.

---

**Q: What does Smart Report Engine offer to PHP developers?**  
**A:**  
It enables programmatic report generation from MySQL or MariaDB data via simple PHP API calls. This accelerates development, reduces effort, and enhances report quality within your application.

---

**Q: Can it integrate with an existing login system?**  
**A:**  
Yes. It offers security functions that can be integrated with your login system. [Tutorial here](https://mysqlreports.com/examples/integrating-smart-report-engine-with-a-session-based-login-system/).

---

**Q: Can I filter reports based on logged-in users?**  
**A:**  
Yes. It supports filtering data based on the current user. [Tutorial here](https://mysqlreports.com/examples/filter-with-current-logged-in/).

---

**Q: Where can I find tutorials and examples?**  
**A:**  
You can find them in the [tutorials section](https://mysqlreports.com/examples/).

---

**Q: Is there a discount if I buy Smart Report Maker and Smart Report Engine together?**  
**A:**  
Yes. Promotions usually include around 25% off when purchasing both, visible in the checkout's "We Also Recommend" section.

---

## Additional Resources and Support
- [Official Website](https://mysqlreports.com)
- [Support Page](https://mysqlreports.com/support)
- [Documentation](https://mysqlreports.com/mysql-report-generator-manual/)
- [Video Tours & Screencasts](https://mysqlreports.com/webuccino-screencasts/)
- [Demo Version](https://demo.mysqlreports.com/login)

---

## About Webuccino
Webuccino has been creating easy-to-use reporting tools since 2007.  
[Read more](https://mysqlreports.com/about/).  

Follow their channels:  
- [YouTube](https://www.youtube.com/user/MrStarsoft2011)  
- [Vimeo](https://vimeo.com/115685915)

---

## Highlights
- PHP Reports for MySQL
- Report Linking & Chaining
- Reports & Dashboards in WordPress
- Embeddable Reports & Dashboards
- MySQL Pivot Tables
- PHP Dashboards
- PHP Charts for MySQL
- Data Analysis
- Dashboard Management
- PHP Form Builder

**Support:**  
- [Customer Support](https://mysqlreports.com/open-ticket/)  
- [FAQ](https://mysqlreports.com/faq/)  
- [Docs](https://mysqlreports.com/mysql-report-generator-manual/)  
- [Video Tours](https://mysqlreports.com/webuccino-screencasts/)  
- [Demo Version](https://demo.mysqlreports.com/login)

**Legal:**  
© Webuccino, 2007-2025.  
[Privacy Policy](https://mysqlreports.com/privacy-policy/)  
[Sitemap](https://mysqlreports.com/web-sitemap/)

---

## Page: https://mysqlreports.com/mysql-reporting-tools/the-best-mysql-report-builder

# Overview of Smart Report Maker

Smart Report Maker (SRM) is an advanced PHP-based report builder and PHP dashboard tool designed for MySQL and MariaDB databases. It supports features such as dynamic PHP dashboards, interactive pivot tables, scheduled reports, advanced charts, KPI monitoring, and more. SRM enables users to link reports for drill-down analysis, embed reports securely into web applications and WordPress sites, and visualize data with full control, flexibility, and security.

---

# Key Features

## Easy-to-Use PHP Report Builder
- Wizard-style interface for generating reports from MySQL/MariaDB
- No coding required
- [Learn more](https://mysqlreports.com/php-reports/)

## Create Report Chains
- Link reports by passing parameters
- Multi-step exploration of data
- [Report linking details](https://mysqlreports.com/report-linking/)

## Embed Reports and Dashboards
- Built-in Embed Manager
- WordPress plugin for seamless embedding
- Secure, interactive embedding with filtering, drill-down, and export features
- [Embed WordPress reports](https://mysqlreports.com/srm-embed-smart-report-maker/)

## Embed Manager for PHP Applications
- Secure embedding into PHP-based apps
- Full interactivity and control
- [Embed Manager details](https://mysqlreports.com/srm-modules-embed-manager/)

## Pivot Tables
- Drag-and-drop, no SQL coding needed
- Analyze, summarize, and break down data efficiently
- [Pivot Table module](https://mysqlreports.com/php-mysql-pivot-tables/)

## PHP Dashboards
- Customizable dashboards for real-time data monitoring
- Visual display of KPIs and performance metrics
- [Dashboards overview](https://mysqlreports.com/php-dashboards-for-mysql/)

## Advanced PHP Charts
- Create professional charts directly from your data
- [Chart Builder details](https://mysqlreports.com/php-charts/)

## Scheduled Reports
- Automate report generation and email delivery
- Supports daily, weekly, monthly schedules
- Multiple formats (e.g., PDF)
- Configure recipients and output formats
- Eliminates manual effort

## KPI and Metrics Monitoring
- Track business performance with customizable KPIs
- Filter by timeframes (last month, quarter, custom)
- Compare against historical data or targets
- Represent data in various display formats (currency, percentage, etc.)
- Display KPIs through info boxes, gauges, trend charts

## Data Analysis and Visualization
- Drill down into reports and charts
- Generate time-series data and compare metrics
- Create calculated columns and apply dynamic filters

## Export, Share, and Print
- Export reports in formats like PDF, CSV, XML
- Printer-friendly layouts
- Embed resources in external websites

## Security & User Management
- Role-based permissions and group management
- Control who can view, edit, or create resources
- Manage public vs. private resources
- User subscriptions for access control
- Admin privileges for full system control

## Easy Setup & Compatibility
- No command-line, Docker, or complex server configuration
- Direct upload method for quick installation
- Compatible with shared hosting, VPS, dedicated servers
- Supports cPanel, Plesk, CWP, and other hosting panels

## Documentation & Support
- Detailed, step-by-step documentation
- Free support via ticketing system
- Free upgrades for 6 months
- One-time payment, no renewal fees

## System Requirements
- PHP 7.4+ 
- MySQL/MariaDB
- Web server: Apache or Nginx

---

# Frequently Asked Questions (FAQs)

### Why choose Smart Report Maker?
- Trusted since 2007, creates reports, dashboards, pivot tables, KPIs
- Easy web-based installation
- Full ownership with one-time payment
- Embeddable into PHP apps and WordPress

### Can non-technical users operate it?
- Yes, intuitive wizard interface requires no coding
- Suitable for business analysts, managers, and technical users

### Compatibility with hosting control panels?
- Works with cPanel, Plesk, CWP, and others that support PHP

### Can reports be scheduled?
- Yes, with flexible scheduling options.
- Supports email delivery in formats like PDF

### Can visual elements be embedded?
- Yes, supports barcodes, QR codes, Google Maps, images, checkboxes, star ratings, country flags, hyperlinks, and formatted financial cells.

### Is report linking possible?
- Yes, from customer to accounts and invoices, enabling drill-down navigation.
- [Learn more about report linking](https://mysqlreports.com/report-linking/)

### Can reports be embedded into WordPress and PHP apps?
- Yes, via Embed Manager and WordPress plugin.

### How to see SRM in action?
- Demo online and video tutorials available:
  - [Demo](https://demo.mysqlreports.com/)
  - [Tutorials](https://mysqlreports.com/webuccino-screencasts/)

### Difference between SRM and SRE?
- SRM: Complete report building platform
- SRE: API-based reporting engine for developers

### Are discounts available?
- Cross-product promotions with Smart Form Maker and Smart Report Engine (~25%)

---

# Related Resources

- [Embed Reports & Dashboards in Your Application](https://mysqlreports.com/srm-modules-embed-manager/)
- [Embedding Reports in WordPress](https://mysqlreports.com/blog/how-to-securely-embed-reports-dashboards-and-charts-in-wordpress-using-the-srm-embed-plugin/)
- [Report Linking & Chaining](https://mysqlreports.com/report-linking/)
- [Pivot Tables Details](https://mysqlreports.com/php-mysql-pivot-tables/)
- [Dashboards Overview](https://mysqlreports.com/php-dashboards-for-mysql/)
- [Reports Overview](https://mysqlreports.com/php-reports/)
- [Charts Overview](https://mysqlreports.com/php-charts/)
- [New Features in SRM](https://mysqlreports.com/blog/smart-report-maker-11-0-release-powerful-new-features/)
- [Video Tutorials](https://mysqlreports.com/webuccino-screencasts/)
- [Try Demo](https://demo.mysqlreports.com/)

---

# System Requirements Summary

| Requirement | Specification |
|---------------|--------------|
| PHP Version | 7.4 or later |
| Database Support | MySQL / MariaDB |
| Web Server | Apache or Nginx |

---

# Support & Support Resources

- [Documentation](https://mysqlreports.com/smart-report-maker-docs/smart-report-maker-docs/)
- [Customer Support](https://mysqlreports.com/open-ticket/)
- Free upgrades for 6 months post-purchase
- One-time payment, no renewal costs

---

# About Webuccino
Creating easy-to-use reporting tools since 2007.  
[Read more](https://mysqlreports.com/about).

---

# Conclusion
Smart Report Maker provides a comprehensive suite of tools for building, visualizing, embedding, and automating reports and dashboards directly from MySQL and MariaDB databases, suitable for technical and non-technical users alike.

---

## Page: https://mysqlreports.com/open-ticket

# Webuccino Support and About Page Overview

## Main Sections

### Open Ticket Support System

- **Purpose:**  
  To assist users in submitting support inquiries or reviewing existing requests related to Webuccino products.

- **Checking Existing Questions:**  
  Before submitting a new ticket, users are encouraged to review the FAQ:  
  [FAQ](https://mysqlreports.com/faq/)

- **Submitting a New Support Ticket:**  
  If an answer isn't found, users can create a new support ticket:  
  [Support Ticket Submission](https://mysqlreports.com/support/index.php?a=add)  
  **Note:** Do not post passwords in support tickets.

- **Reviewing Existing Tickets:**  
  Users can check the status of open or past tickets here:  
  [View Tickets](https://mysqlreports.com/support/ticket.php)

### About Webuccino

- **Company Introduction:**  
  Webuccino has been creating user-friendly reporting tools since 2007.  
  [Read more](https://mysqlreports.com/about/)

- **Social Media & Video Content:**  
  - YouTube: [Link](https://www.youtube.com/user/MrStarsoft2011)  
  - Vimeo: [Link](https://vimeo.com/115685915)

### Highlights of Webuccino Products and Features

- **Product Links:**  
  - [PHP Reports for MySQL](https://mysqlreports.com/php-reports/)  
  - [Report Linking & Chaining](https://mysqlreports.com/report-linking/)  
  - [Reports & Dashboards in WordPress](https://mysqlreports.com/srm-embed-smart-report-maker/)  
  - [Reports & Dashboards in Your Application](https://mysqlreports.com/srm-modules-embed-manager/)  
  - [MySQL Pivot Tables](https://mysqlreports.com/php-mysql-pivot-tables/)  
  - [PHP Dashboards for MySQL](https://mysqlreports.com/php-dashboards-for-mysql/)  
  - [PHP Charts for MySQL](https://mysqlreports.com/php-charts/)  
  - [MySQL Data Analysis](https://mysqlreports.com/mysql-data-analysis/)  
  - [Manage Dashboards](https://mysqlreports.com/smart-report-maker-docs/docs/dashboards/mysql-dashboards-managing-and-customizing-your-data-insights/)  
  - [PHP Form Builder for MySQL](https://mysqlreports.com/mysql-reporting-tools/php-mysql-form-generator/)  
  - [PHP Reporting Library](https://mysqlreports.com/mysql-reporting-tools/smart-report-engine/)

### Support Resources

- **Customer Support:**  
  [Open a Support Ticket](https://mysqlreports.com/open-ticket/)

- **Frequently Asked Questions:**  
  [FAQ](https://mysqlreports.com/faq/)

- **Documentation:**  
  [Support Documentation](https://mysqlreports.com/mysql-report-generator-manual/)

- **Video Tours:**  
  [Webuccino Screencasts](https://mysqlreports.com/webuccino-screencasts/)

- **Demo Version:**  
  [Demo Login](https://demo.mysqlreports.com/login)

---

## Summary

This webpage provides support options for Webuccino products, including ticket submission, ticket status review, and access to FAQs and documentation. It also offers background information about Webuccino, highlights of their products and features, social media links, and resources for tutorials and demos.

---

## Page: https://mysqlreports.com/php-charts

# Webuccino Smart Report Maker - PHP Charts for MYSQL

## Overview

Smart Report Maker simplifies data visualization by providing a robust PHP MYSQL Chart Builder. It enables users to create professional, insightful PHP charts directly from their MySQL and MariaDB databases with ease.

---

## Key Features

### 1. Build Stunning PHP Charts with Customizable Chart Types
- Create charts using various types:
  - Bar
  - Line
  - Pie
  - Donut
  - Time-Series
- Visualize data such as product performance or customer demographics.
- Transform raw data into meaningful insights.

### 2. Time-Series Charts for Trend Analysis
- Track performance over time (daily sales, signups, order volume).
- Filter data by custom time ranges:
  - Last 30 Days
  - This Quarter
  - Last Week
- Choose time scales: hours, days, weeks, months, quarters.
- Gain insights into trends and seasonality.

### 3. Interactive Drill-Down Charts
- Explore deeper information with a single click.
- Example: clicking on a region in a “Sales by Region” chart reveals sales by city/store.
- Supports uncovering specific trends and detailed analysis.

### 4. Advanced Data Filters
- Apply custom filters to target specific segments.
- Filter by department, region, date, product, performance metrics.
- Keeps visualizations clear, relevant, and actionable.

### 5. User-Friendly Chart Builder with Wizard Interface
- Step-by-step interface guides users through chart creation, editing, and management.
- Suitable for both technical and non-technical users.

### 6. Export Charts to PDF
- Download charts as high-quality PDF files.
- Use in reports, presentations, or sharing with stakeholders.

---

## FAQs

### Q1: Can I create PHP charts directly from my MySQL or MariaDB databases using Smart Report Maker?
**A:** Yes. It allows creating professional PHP charts directly from existing databases without data duplication. Visualizations leverage live database data with ease.

### Q2: Does it support time-series charts?
**A:** Yes. Supports time-series charts for trend analysis across various time scales, helping track metrics like sales or user activity over time.

### Q3: Can I filter charts by date ranges or other criteria?
**A:** Yes. Supports advanced filters like department, region, date ranges, product, or performance metrics, ensuring targeted visualizations.

### Q4: Does it support drill-down and interactivity?
**A:** Yes. Charts can be clicked for more detailed views, such as expanding a sales region to see individual store data.

### Q5: Is it suitable for non-technical users?
**A:** Yes. The wizard-based interface simplifies chart management, requiring no SQL or programming knowledge.

### Q6: Can I export charts to PDF?
**A:** Yes. Facilitates exporting as high-quality PDFs suitable for reporting and presentations.

---

## Summary

Create dynamic, professional charts easily from your MySQL data. Choose from multiple chart types, apply filters, enable drill-down interactivity, and export to PDF—all via an intuitive wizard. Transform complex data into actionable visual insights with minimal effort.

---

## Related Links

- [More about Report Linking](https://mysqlreports.com/report-linking/)
- [WordPress Plugin for Smart Report Maker](https://mysqlreports.com/srm-embed-smart-report-maker/)
- [Embed Manager for Reports & Dashboards](https://mysqlreports.com/srm-modules-embed-manager/)
- [Pivot Tables for MySQL](https://mysqlreports.com/php-mysql-pivot-tables/)
- [MySQL Dashboards](https://mysqlreports.com/php-dashboards-for-mysql/)
- [Reports](https://mysqlreports.com/php-reports/)
- [Charts](https://mysqlreports.com/php-charts/)
- [What's New in SRM](https://mysqlreports.com/blog/smart-report-maker-11-0-release-powerful-new-features/)
- [Video Tutorials](https://mysqlreports.com/webuccino-screencasts/)
- [Try Demo Version](https://demo.mysqlreports.com/)

---

## About Webuccino

**Creating easy-to-use reporting tools since 2007.**  
[Read more](https://mysqlreports.com/about/)

Follow us on:
- [YouTube](https://www.youtube.com/user/MrStarsoft2011)
- [Vimeo](https://vimeo.com/115685915)

---

## Highlights

- [PHP Reports for MySQL](https://mysqlreports.com/php-reports/)
- [Report Linking & Chaining](https://mysqlreports.com/report-linking/)
- [WordPress Reports & Dashboards](https://mysqlreports.com/srm-embed-smart-report-maker/)
- [Application Embedding](https://mysqlreports.com/srm-modules-embed-manager/)
- [MySQL Pivot Tables](https://mysqlreports.com/php-mysql-pivot-tables/)
- [PHP Dashboards](https://mysqlreports.com/php-dashboards-for-mysql/)
- [PHP Charts for MYSQL](https://mysqlreports.com/php-charts/)
- [Data Analysis](https://mysqlreports.com/mysql-data-analysis/)

---

## Support & Resources

- [Customer Support](https://mysqlreports.com/open-ticket/)
- [FAQ](https://mysqlreports.com/faq/)
- [Documentation](https://mysqlreports.com/mysql-report-generator-manual/)
- [Video Tours](https://mysqlreports.com/webuccino-screencasts/)
- [Demo Version](https://demo.mysqlreports.com/)

---

## Copyright and Legal
© Webuccino 2007 - 2025  
[Privacy Policy](https://mysqlreports.com/privacy-policy/)  
[About Webuccino](https://mysqlreports.com/about/)  
[User Testimonials](https://mysqlreports.com/smart-report-maker-testimonials/)  
[Sitemap](https://mysqlreports.com/web-sitemap/)

---

## Page: https://mysqlreports.com/php-dashboards-for-mysql

# PHP Dashboards with Smart Report Maker (SRM)

## Overview

**Smart Report Maker** offers a module to build **interactive PHP dashboards** for MySQL and MariaDB databases. These dashboards provide a visual and centralized way to monitor key metrics, trends, and performance indicators without requiring any coding.

**Benefits of SRM Dashboards:**
- Enhance decision-making by centralizing insights.
- Quickly identify trends and track progress.
- Summarize sales, analyze user activity, or visualize other KPIs.
- Create professional dashboards directly from your database with a wizard-based interface.

## Key Features

### Unlimited PHP Dashboards
- Create and manage an unlimited number of dashboards.
- Suitable for small businesses and large enterprises.
- Design dashboards for various departments, projects, or reporting periods within the same platform.

### Customizable Widgets
- Build dashboards with a variety of widgets:
  - Detailed reports
  - Interactive charts
  - Real-time KPIs
  - Dynamic pivot tables
- Fully customizable to highlight relevant data.

### Powered by Your Databases
- Each dashboard is directly linked to your MySQL or MariaDB databases.
- Supports integration with data from other connected applications.
- Acts as a central hub for real-time business data visualization.

### Drill-Down Interactivity
- Dashboards are interactive and exploratory.
- Click on chart points, KPIs, pivot table cells, or report data for detailed views.
- Jump from widgets to focused views for in-depth analysis.

### Dashboard Management
- Built-in manager to modify, reorder, or delete dashboards.
- Easy addition of new dashboards through a step-by-step wizard interface.
- Designed to adapt to evolving business needs without technical complexity.

---

## Frequently Asked Questions (FAQ)

### Is there a limit to the number of PHP dashboards I can create?
- **No.** Unlimited dashboards can be created and managed for different purposes.

### Can I embed dashboards into my PHP applications?
- **Yes.** SRM includes an Embed Manager to securely embed dashboards into your PHP applications with full interactivity.

### What types of widgets are available?
- Reports
- Interactive charts
- KPIs
- Pivot tables
- All customizable to suit your needs.

### Are dashboards support drill-down and interactivity?
- **Yes.** Users can explore data in-depth by drilling down into any widget element for detailed insights.

### Can I combine widgets from different databases in one dashboard?
- **Yes.** SRM supports multiple database connections, allowing aggregation of data from various MySQL and MariaDB systems into a single dashboard.

---

## Conclusion
Smart Report Maker simplifies the creation, customization, and management of unlimited PHP dashboards, enabling businesses to turn raw database data into clear, actionable insights in minutes. Its wizard-based interface and rich interactive features make it an accessible and powerful solution for professional data visualization.

---

## Related Links
- [More about the Report Linking](https://mysqlreports.com/report-linking/)
- [WordPress Plugin for SRM](https://mysqlreports.com/srm-embed-smart-report-maker/)
- [Embed Manager Details](https://mysqlreports.com/srm-modules-embed-manager/)
- [Pivot Tables Information](https://mysqlreports.com/php-mysql-pivot-tables/)
- [Reports Overview](https://mysqlreports.com/php-reports/)
- [Charts Overview](https://mysqlreports.com/php-charts/)
- [Latest SRM Features](https://mysqlreports.com/blog/smart-report-maker-11-0-release-powerful-new-features/)
- [Video Tutorials](https://mysqlreports.com/webuccino-screencasts/)
- [Try the Demo Version](https://demo.mysqlreports.com/)

## About Webuccino
Webuccino has been creating easy-to-use reporting tools since 2007. [Read more](https://mysqlreports.com/about/).

---

*Note:* This document focuses solely on the main content related to PHP dashboards and Smart Report Maker features, excluding navigation menus, footers, or unrelated content.

---

## Page: https://mysqlreports.com/php-mysql-pivot-tables

# Pivot Tables in Smart Report Maker (SRM)

## Overview

Smart Report Maker (SRM) includes a powerful module that allows users to create PHP MySQL and MariaDB pivot tables through an easy-to-use drag-and-drop interface. This feature enables users to summarize and analyze data without writing any SQL code. 

## Key Features

- **No-code, drag-and-drop interface** for building pivot tables.
- **Automatic relationship detection** between tables based on foreign keys.
- **Dynamic filtering** with user-defined parameters.
- **Time-based grouping** such as year, quarter, month, weekday, or hour.
- **Subtotals and grand totals** for comprehensive analysis.
- **Multiple aggregation functions** including Sum, Count, Count Distinct, Average, Min, Max, and First Value.
- **Column visibility management** to customize views.
- **Export options** for sharing reports.
- **Access control and permissions** for secure data sharing.
- **Seamless dashboard integration** for real-time updates.
- **High performance** with large datasets.

## How to Build PHP MySQL and MariaDB Pivot Tables

### Step-by-step Instructions

1. **Access the Pivot Table Module:**
   - Navigate to the SRM interface and select the pivot table module.

2. **Select Database Tables:**
   - Choose the tables you want to include in your pivot table.
   - SRM will automatically detect relationships based on foreign keys.
   - Adjust or manually set relationships if needed.

3. **Assign Fields to Pivot Sections:**
   - Drag database fields into the following sections:
     - **Rows:** Fields to appear as row categories.
     - **Columns:** Fields to appear as column categories.
     - **Values:** Numeric fields to aggregate (Sum, Count, etc.).

4. **Configure Grouping and Filters:**
   - For date/time fields, specify grouping (year, quarter, month, etc.).
   - Apply static filters by dragging fields into the filters area with fixed conditions.
   - Define dynamic filters (parameters) for end-user interaction:
     - Use input controls like date pickers, dropdowns, sliders, etc.
     - These controls allow users to filter data at runtime.

5. **Set Aggregation Functions:**
   - Choose the appropriate aggregation (Sum, Count, Average, Min, Max, etc.) for each Values field.

6. **Customize Appearance:**
   - Select or customize report templates.
   - Hide or show columns to highlight key metrics.
   - Adjust styles and formatting.

7. **Enable Subtotals and Totals:**
   - Choose to display subtotals for grouped periods (quarterly, yearly).
   - Decide on showing grand totals for rows and columns.

8. **Export and Share:**
   - Export pivot tables in formats like Excel, PDF, etc.
   - Embed pivot tables into dashboards or PHP applications.

9. **Set Access Permissions:**
   - Control who can view or interact with specific pivot tables.

### Additional Features

- **Column Visibility Management**
   - Toggle visibility of specific columns to simplify the report.

- **Embed Pivot Tables**
   - Embed into dashboards with real-time data refresh.

- **Filter Handling**
   - Static filters for fixed data views.
   - Dynamic parameters for user-driven filtering.

### Example Use Cases

- Analyzing monthly sales by region with just drag-and-drop.
- Creating time-series reports with automatic date grouping.
- Comparing data across multiple categories with various aggregation functions.

## FAQ Highlights

- **Creating pivot tables without SQL:** Yes, SRM allows building complex pivot tables visually.
- **Handling date fields:** You can group date/time fields into months, quarters, weekdays, hours.
- **Automatic relationship detection:** Relationships are auto-detected based on foreign keys; manual adjustments are possible.
- **Filtering options:** Supports static filters and user-definable dynamic parameters with various input controls.
- **Embedding tables:** Pivot tables can be embedded into your PHP applications and dashboards.
- **Custom styles:** Fully customizable templates, formatting, and display options.
- **Trial and demonstration:** Use the [online demo](https://demo.mysqlreports.com/pivot-tables/create) to try the feature, with tutorials available [here](https://www.youtube.com/watch?v=hYuytO_e0J8).

## Summary

Building PHP MySQL pivot tables has become simpler and more powerful with SRM. The drag-and-drop interface enables quick creation of dynamic, interactive reports to visualize trends, conduct deep data analysis, and generate time-based insights—all without SQL coding.

## Related Links

- [More about Report Linking](https://mysqlreports.com/report-linking/)
- [WordPress Plugin for Reports & Dashboards](https://mysqlreports.com/srm-embed-smart-report-maker/)
- [Embed Manager for Reports](https://mysqlreports.com/srm-modules-embed-manager/)
- [PHP Dashboards for MySQL](https://mysqlreports.com/php-dashboards-for-mysql/)
- [PHP Reports for MySQL](https://mysqlreports.com/php-reports/)
- [PHP Charts for MySQL](https://mysqlreports.com/php-charts/)
- [New in SRM](https://mysqlreports.com/blog/smart-report-maker-11-0-release-powerful-new-features/)
- [Video Tutorials](https://mysqlreports.com/webuccino-screencasts/)
- [Try the Demo Version](https://demo.mysqlreports.com/)

---

## Page: https://mysqlreports.com/php-reports

# SRM Modules – Report Builder

## Easy-to-Use PHP Reports for MySQL and MariaDB

[Smart Report Maker](https://mysqlreports.com/mysql-reporting-tools/the-best-mysql-report-builder) is a comprehensive MySQL and MariaDB Report Builder designed to generate PHP reports directly from your databases. It features an intuitive wizard-style interface that simplifies report creation, enabling users to convert their MySQL and MariaDB data into insightful reports effortlessly.

---

## Key Features Overview

### User-Friendly Interface

- Wizard-based report design guiding users step-by-step.
- No programming skills required.
- Fast and easy installation via browser-based installer.

### Multiple Data Connections

- Supports connecting to multiple MySQL and MariaDB databases simultaneously.
- Facilitates comprehensive reports across different data sources.

### Flexible Data Sources

- Creates PHP reports from:
  - Single tables
  - Multiple related tables with join relationships
  - Custom SQL queries for advanced data customization

### Dynamic Calculations & Summaries

- Subtotals and grand totals for summarized data.
- Calculated fields, e.g., revenue = unit price × quantity.
- Customized calculations for deeper insights.

### Advanced Data Filtering

- Column-level advanced filtering.
- Runtime, user-defined filters.
- Powerfull date filtering (daily, weekly, monthly, quarterly).
- Building report relationships and linked reports.
- Embedding reports into PHP applications and WordPress sites via Embed Managers and plugins.

### Appearance Customization

- Add headers and footers with titles, dates, or branding.
- Inclusion of logos, with support for different logos per user.
- Various pre-designed themes and flexible layout options.

### Cell Styling & Conditional Formatting

- Dynamic cell formatting options, including:
  - Thumbnails for image URLs
  - Checkboxes for boolean values
  - Star ratings
  - Country flag icons
  - Clickable hyperlinks
  - Barcodes and QR codes
  - Google Maps integration
  - Financial formatting (currencies, percentages)

- Conditional formatting rules, e.g., highlight low stock in red, status in green/orange.

---

## Report Management Features

- Multi-level grouping and sorting.
- Selective column display with renaming.
- Quick duplication of reports.
- Reordering columns.
- Export options: PDF, XML, CSV.
- Responsive design optimized for mobile devices.
- Multilingual support.
- Access control:
  - Private reports (restricted access)
  - Public reports (accessible to all)

---

## Benefits

- **Ease of Use:** Designed for non-technical users.
- **Powerful Data Handling:** Multiple databases, customs SQL, related tables.
- **Professional Appearance:** Custom headers, footers, themes, logos.
- **Rich Data Visualization:** Advanced cell styling, conditional formatting.
- **Flexible Reporting:** Filtering, grouping, exporting, embedding.

---

## Frequently Asked Questions (FAQ)

### Why choose Smart Report Maker for MySQL/MariaDB reporting?

Smart Report Maker, established since 2007, is trusted worldwide for creating reports, dashboards, charts, KPIs, and pivot tables without coding. It can be installed easily using its web installer and runs on your server, ensuring data privacy. Reports and dashboards can be embedded securely into PHP applications and WordPress sites. [More info](https://mysqlreports.com/why-choose-our-mysql-reporting-tools/)

### Is it suitable for non-technical users?

Yes. Its wizard-based interface makes it accessible for business users, analysts, and managers without SQL or PHP skills. The web installer simplifies setup and daily operation.

### What's new in version 11?

The latest version introduces enhanced reporting features, analytics, improved usability, and installation processes. [Details here](https://mysqlreports.com/blog/smart-report-maker-11-0-release-powerful-new-features/)

### Can it connect to multiple databases?

Yes, users can create and manage multiple MySQL/MariaDB database connections, enabling reporting across several sources within the same system.

---

## Related Links

- [Report Linking & Chaining](https://mysqlreports.com/report-linking/)
- [WordPress Plugin for Reports & Dashboards](https://mysqlreports.com/srm-embed-smart-report-maker/)
- [Embed Manager](https://mysqlreports.com/srm-modules-embed-manager/)
- [Pivot Tables](https://mysqlreports.com/php-mysql-pivot-tables/)
- [Dashboards](https://mysqlreports.com/php-dashboards-for-mysql/)
- [Charts](https://mysqlreports.com/php-charts/)
- [Video Tutorials](https://mysqlreports.com/webuccino-screencasts/)
- [Demo Version](https://demo.mysqlreports.com/)

---

## About Webuccino

Webuccino has been creating easy-to-use reporting tools since 2007. [Read more](https://mysqlreports.com/about/).

---

## Contact and Support

- Customer Support: [Open Ticket](https://mysqlreports.com/open-ticket/)
- FAQ: [Support FAQ](https://mysqlreports.com/faq/)
- Documentation: [User Manual](https://mysqlreports.com/mysql-report-generator-manual/)
- Video Tours: [Watch Videos](https://mysqlreports.com/webuccino-screencasts/)
- Demo: [Try Demo](https://demo.mysqlreports.com/)

---

# Summary

Smart Report Maker offers a robust, intuitive platform for generating professional PHP reports from MySQL and MariaDB databases. Its rich feature set includes support for multiple data sources, dynamic calculations, advanced filtering, customizable appearance, and secure report management, making it suitable for both technical and non-technical users seeking efficient data reporting solutions.

---

## Page: https://mysqlreports.com/privacy-policy

# Privacy Policy

## Overview
This policy explains how we use your personal information. We are committed to protecting your privacy and will take all necessary measures to safeguard your personal data.

## Use of Personal Information
Any personal information we receive will be used solely to fulfill your orders and send you important updates regarding new versions or plugins of the products you purchased. We guarantee that your information will never be sold or redistributed to third parties.

## Refund Policy
If you are dissatisfied with your purchase due to unresponsive support within 2 business days, you may request:
- A full refund
- A partial refund
- An exchange for another solution provided by Webuccino

# About Webuccino
Webuccino has been creating easy-to-use reporting tools since 2007. [Read more about us](https://mysqlreports.com/about/).

## Contact & Social Media
- YouTube: [MrStarsoft2011](https://www.youtube.com/user/MrStarsoft2011)
- Vimeo: ![Vimeo Link](https://vimeo.com/115685915)

# Highlights of Our Products
- [PHP Reports for MySQL](https://mysqlreports.com/php-reports/)
- [Report Linking & Chaining](https://mysqlreports.com/report-linking/)
- [Reports & Dashboards in WordPress](https://mysqlreports.com/srm-embed-smart-report-maker/)
- [Reports & Dashboards in Your Application](https://mysqlreports.com/srm-modules-embed-manager/)
- [MYSQL Pivot Tables](https://mysqlreports.com/php-mysql-pivot-tables/)
- [PHP Dashboards for MySQL](https://mysqlreports.com/php-dashboards-for-mysql/)
- [PHP Charts for MySQL](https://mysqlreports.com/php-charts/)
- [MySQL Data Analysis](https://mysqlreports.com/mysql-data-analysis/)
- [Manage Dashboards](https://mysqlreports.com/smart-report-maker-docs/docs/dashboards/mysql-dashboards-managing-and-customizing-your-data-insights/)
- [PHP Form Builder for MySQL](https://mysqlreports.com/mysql-reporting-tools/php-mysql-form-generator/)
- [Easy-to-Use PHP Reporting Library](https://mysqlreports.com/mysql-reporting-tools/smart-report-engine/)

# Help & Support
- [Customer Support Ticket](https://mysqlreports.com/open-ticket/)
- [FAQ](https://mysqlreports.com/faq/)
- [Docs](https://mysqlreports.com/mysql-report-generator-manual/)
- [Video Tours](https://mysqlreports.com/webuccino-screencasts/)
- [Demo Version](https://demo.mysqlreports.com/login)

# Copyright
Copyrights Reserved 2007 - 2025 © Webuccino.

# Additional Links
- [Privacy Policy](https://mysqlreports.com/privacy-policy/)
- [About Webuccino](https://mysqlreports.com/about/)
- [User Testimonials](https://mysqlreports.com/smart-report-maker-testimonials/)
- [Sitemap](https://mysqlreports.com/web-sitemap/)

---

## Page: https://mysqlreports.com/report-linking

# SRM Modules – Report Linking

## Build Report Chains Using the Report Linking Feature in Smart Report Maker

Starting from version 11, Smart Report Maker allows you to create powerful report chains by linking multiple reports together. This feature enables users to explore data step by step instead of viewing everything in a single flat report.

### Example Use Case
A user can begin with a **Customer List** report, click on a specific customer to view only their invoices, then click an invoice to see the products associated with it, and finally drill into the supplier details for each product. Each step is automatic and maintains context, providing a smooth data exploration experience.

---

## Benefits of SRM Report Linking

### Create Smarter Data Exploration Through Report Chains
- Instead of overcrowding a single report with excessive information, you can design a sequence of interconnected reports that guide the user through relevant data points.
- Reports are linked through parameters, enabling a logical and incremental data browsing experience.

### Better Navigation Experience
- Users can navigate from summary reports to detailed data with a single click, eliminating the need for manual filter setup.
- This drill-down capability remains functional even when reports are embedded within other websites or applications, ensuring seamless interaction.

---

*Note:* No specific API endpoints or technical implementation details are included in this section. The content focuses on describing the new feature, its benefits, and how it enhances data exploration within Smart Report Maker.

---

## Page: https://mysqlreports.com/smart-report-maker-docs/docs/dashboards/mysql-dashboards-managing-and-customizing-your-data-insights

# Documentation: Managing and Customizing PHP Dashboards in Smart Report Maker

## Overview

Dashboards in Smart Report Maker serve as crucial tools for visualizing and tracking data extracted from MySQL databases. They enable users to organize, analyze, and interact with key performance indicators (KPIs), charts, and reports. Each PHP dashboard is highly customizable, allowing individual users to tailor their data experience, starting from a centralized Home Dashboard and expanding into additional dashboards for specialized insights.

---

## 1. Home Dashboard: Your Centralized Data Hub

### Purpose
- Acts as the default landing page after login.
- Presents high-priority widgets such as KPIs, charts, and reports.
- Provides an at-a-glance overview of essential data metrics.

### Customization
- Fully customizable according to user roles and preferences.

### How to Customize Your Home Dashboard

1. **Add Widgets**
   - Click the **“Add Widget”** button.
   - Select Resource Type:
     - **Charts**: Displays accessible charts; admins see all, users see permitted charts.
     - **KPIs**: Add KPI widgets similar to charts.
     - **Report List**: Add linked reports, requiring a label name for the group.

2. **Interact with Widgets**
   - Drill down for detailed data.
   - View and analyze live KPIs and charts to detect trends and monitor real-time metrics.

---

## 2. Managing Additional Dashboards

### Creating and Organizing Dashboards

1. **Access Dashboard Manager**
   - Navigate via **“Dashboards”** in the side panel.
   - Dashboard Manager displays all existing dashboards for viewing and modification.

2. **Top Dashboards in Sidebar**
   - Top five dashboards are listed directly in the sidebar for quick access.
   - Other dashboards are accessible via Dashboard Manager.

3. **Reordering Dashboards**
   - Use **"Move Up" / "Move Down"** to reorder dashboards.
   - Only the top five dashboards appear in the sidebar; reorder to prioritize frequently used dashboards.

4. **Dashboard Display Options**
   - **Display**: Opens the dashboard for interaction.
   - **Move Up / Down**: Changes the dashboard's position in the sidebar.

---

## 3. Adding and Editing Dashboards

### How to Add a New Dashboard

1. **From Dashboard Manager or Quick Add**
   - Click **“Add Dashboard”** or the Quick Add icon.
   - Fill in the popup form with dashboard details:
     - **Name**: Name shown in sidebar & Dashboard Manager.
     - **Icon**: Select a Font Awesome icon for visual identification.
     - **Title**: Header displayed on the dashboard.

2. **Adding Widgets to a Dashboard**
   - After creating or opening a dashboard, click **“Add Widget”**.
   - Select Resource Type:
     - Chart, KPI, or Report.
     - Pick the specific resource available in your account.

### Editing Existing Dashboard

- Open a dashboard and modify its properties or add new widgets following the process above.

---

## 4. Practical Use Cases for PHP Dashboards

- **Sales Performance Tracking**
  - Monitor monthly sales, growth metrics, and historical comparisons using KPIs and charts.
- **Employee Performance**
  - Visualize KPIs like average tenure, productivity, or attendance.
- **Operational Efficiency**
  - Track order processing times, customer support response rates, or other operational metrics for improvement insights.

---

## 5. Summary

Smart Report Maker’s dashboard tools empower users to:
- Create personalized dashboards tailored to specific needs.
- Organize dashboards effectively for quick access.
- Interact dynamically with data through drill-downs and live metrics.
- Use dashboards for strategic decision-making across sales, HR, and operational domains.

For more detailed instructions and advanced customization options, refer to the [Official SRM Docs – Dashboards](https://mysqlreports.com/smart-report-maker-docs/docs/dashboards/).

---

**Note:** This document strictly covers the main content related to managing and customizing dashboards. It does not include API endpoint references, tutorials, or other unrelated sections.

---

## Page: https://mysqlreports.com/smart-report-maker-docs/smart-report-maker-docs

# Webuccino Smart Report Maker Documentation

## Overview
Webuccino has been creating easy-to-use reporting tools since 2007. Their flagship product, **Smart Report Maker (SRM)**, enables users to generate, customize, and manage reports from MySQL databases through a user-friendly interface, with extensive configuration options and additional features like dashboards, KPIs, and scheduled reports.

## Main Sections and Features

### Getting Started
Provides detailed instructions for installing Smart Report Maker across various environments:
- Installing via direct upload
- Using cPanel or Plesk
- Installing via Docker or Composer
- Integrating into existing stacks
- Using the web installation wizard

### Settings
Guides on configuring:
- SMTP email settings for notifications and scheduled reports
- User and permissions management
- Branding customization (logos, company name)
- Multiple data sources for comprehensive reporting

### Reports
Instructions and best practices for managing and creating reports from MySQL databases, with options for customization and data analysis.

### Charts
Guidelines for creating and managing visual charts:
- Customization options
- Drill-down capabilities
- Export to PDF

### Metrics / KPIs
Steps to set up and monitor key performance indicators:
- Display as info boxes or gauges
- Historical data comparisons
- Setting targets

### Dashboards
Create personalized dashboards:
- Adding widgets for KPIs, reports, or charts
- Multiple dashboards per user
- Visual performance monitoring

### Scheduled Reports
Automate report delivery:
- Scheduling frequency (hourly, daily, monthly, quarterly)
- Target groups
- Ensures stakeholders receive timely insights

### Upgrade
Instructions for upgrading SRM to the latest version:
- Via cPanel
- Via Plesk
- Via CWP
- Using Composer
- Docker-based upgrades

### Help Center
Common issue resolution with step-by-step solutions.

### Other Resources
Additional articles on:
- Docker
- Composer
- cPanel
- PHP
- Related technologies

---

## Related Technologies & Support

### Highlights
- PHP Reports for MySQL
- Report Linking & Chaining
- Embedding Reports/Dashboards in WordPress or Applications
- MySQL Pivot Tables
- PHP Dashboards and Charts
- MySQL Data Analysis

### Support and Support Links
- Customer support portal
- FAQ
- Product documentation
- Video tutorials
- Demo versions

---

## Legal & About
- Company: Webuccino (since 2007)
- Rights Reserved © 2007 - 2025
- Privacy Policy
- About Webuccino
- User testimonials
- Sitemap

---

## Additional Resources
Articles on:
- SSH with cPanel
- Docker benefits
- Docker vs VMs
- Common Docker issues
- What is Composer?
- Email settings in cPanel

---

**Note:** This document summarizes the main content sections and features of the Webuccino Smart Report Maker documentation page. It does not include specific API endpoint references, as none are present in the main content.

---

## Page: https://mysqlreports.com/smart-report-maker-testimonials

# Testimonials

## What Our Customers Say About Smart Report Maker 9.0

### Steven Thefaine
**Solutions Engineer at** [EnTelegent Solutions](https://entelegent.com/)  
**Rating:** ⭐⭐⭐⭐⭐  
**Review:**  
> “Great Product. Easy to use and integrate into existing sites.”

---

### Garrett Scott Spring
**Rating:** ⭐⭐⭐⭐⭐  
**Review:**  
> “They have been Excellent! I have not experienced better service… ever. They answered well and assisted me with any questions or problems until they were all resolved. They truly went above and beyond!!!!”

---

### Paul Willemse
**Rating:** ⭐⭐⭐⭐⭐  
**Review:**  
> “As a relatively new user to SRM V9.0 I have been really impressed! SRM is very easy to setup and is quite intuitive in its use. SRM is more than capable of producing any report (or chart) that I need; from the simplest to very complex. I have used a number of report generators over the years, but find that SRM has been the best by far! I can highly recommend SRM to anyone with a requirement for a flexible and capable reporting tool. As a bonus, its chart, KPI and dashboard functionality only enhances an already fabulous product.”

---

### Ben Ahmed Maroc
**Rating:** ⭐⭐⭐⭐⭐  
**Review:**  
> “I have just discovered SRM, and I am impressed by the team’s innovative approach as well as the tool’s strong reputation in the reporting field. I am confident that SRM will perfectly meet my future needs for creating professional and intuitive reports. I also appreciate the team’s commitment to listening to its users and continuously improving the product. I look forward to following its evolution and taking full advantage of it!”

---

### Mohamed Saed
**Technical Team Lead at** [Erwaa](https://www.erwaa.me/)  
**Rating:** ⭐⭐⭐⭐⭐  
**Review:**  
> “Using SRM has been a game-changer with its powerful reporting capabilities. It enables the generation of detailed reports, automated scheduling, and interactive chart visualization. With numerous options and utilities, users can easily manage complex reports, metrics, and charts. The comprehensive KPIs and metrics tracking feature provides valuable insights for informed decision-making. The support team has been responsive and effective, addressing feedback promptly. SRM is set to be an essential tool for data-driven management.”

---

### Robert Welch
**Product Design Engineer**  
**Rating:** ⭐⭐⭐⭐⭐  
**Review:**  
> “Great software. Saved me a lot of time at work. Great tech support!”

---

### Jason Gray
**Founder, President and CEO at** [Crafty Yoopers Marketplace, LLC](https://www.craftyoopers.com/)  
**Rating:** ⭐⭐⭐⭐  
**Review:**  
> “Opening a support ticket was easy and working with the technical team was outstanding. Communications were quick and solutions from both sides (their tech support and myself) were easily communicated to each other.”

---

### Jim Andreasen
**IT Professional**  
**Rating:** ⭐⭐⭐⭐  
**Review:**  
> “The move to SRM 9 made it easy for me to make reports that were easy to distribute via my PHP applications, and the way of building the reports was extremely easy compared to previous versions.”

---

### Riccardo Colasanti
**Rating:** ⭐⭐⭐⭐  
**Review:**  
> “I like this platform.”

---

### Eman Mostafa
**Software QA Engineer**  
**Rating:** ⭐⭐⭐⭐⭐  
**Review:**  
> “This app is user-friendly and packs multiple tools in one place. It’s easy to navigate, delivers accurate results, and saves me the hassle of switching between apps. Highly recommended.”

---

# Try Demo Version
[![Try Demo Version](https://img.icons8.com/ios-filled/50/000000/link.png)](https://demo.mysqlreports.com/login)

# About Webuccino
Webuccino - Creating easy-to-use reporting tools since 2007.  
[Read more](https://mysqlreports.com/about/)

## Follow Us
- [YouTube](https://www.youtube.com/user/MrStarsoft2011)
- [Vimeo](https://vimeo.com/115685915)

# Highlights of Our Products
- [PHP Reports for MySQL](https://mysqlreports.com/php-reports/)
- [Report Linking & Chaining](https://mysqlreports.com/report-linking/)
- [Reports & Dashboards in WordPress](https://mysqlreports.com/srm-embed-smart-report-maker/)
- [Reports & Dashboards in Your Application](https://mysqlreports.com/srm-modules-embed-manager/)
- [MySQL Pivot Tables](https://mysqlreports.com/php-mysql-pivot-tables/)
- [PHP Dashboards for MYSQL](https://mysqlreports.com/php-dashboards-for-mysql/)
- [PHP Charts for MYSQL](https://mysqlreports.com/php-charts/)
- [MySQL Data Analysis](https://mysqlreports.com/mysql-data-analysis/)
- [Manage Dashboards](https://mysqlreports.com/smart-report-maker-docs/docs/dashboards/mysql-dashboards-managing-and-customizing-your-data-insights/)
- [PHP Form Builder for MYSQL](https://mysqlreports.com/mysql-reporting-tools/php-mysql-form-generator/)
- [Easy-to-Use PHP Reporting Library](https://mysqlreports.com/mysql-reporting-tools/smart-report-engine/)

# Help & Support
- [Customer Support](https://mysqlreports.com/open-ticket/)
- [FAQ](https://mysqlreports.com/faq/)
- [Docs](https://mysqlreports.com/mysql-report-generator-manual/)
- [Video Tours](https://mysqlreports.com/webuccino-screencasts/)
- [Demo Version](https://demo.mysqlreports.com/login)

# Footer Links
- [Privacy Policy](https://mysqlreports.com/privacy-policy/)
- [About Webuccino](https://mysqlreports.com/about/)
- [User Testimonials](https://mysqlreports.com/smart-report-maker-testimonials/)
- [Sitemap](https://mysqlreports.com/web-sitemap/)

*Copyrights Reserved 2007 - 2025 © Webuccino.*

---

## Page: https://mysqlreports.com/srm-embed-smart-report-maker

# SRM Modules – SRM WordPress Plugin

## Overview
The Smart Report Maker (SRM) Embed WordPress Plugin allows users to effortlessly embed reports, dashboards, and analytics into WordPress sites. Created in Smart Report Maker from MySQL databases, these embedded elements maintain full interactivity, enabling features like drill-down, filtering, and export directly on your website while ensuring you retain full control.

## Key Features and Benefits

### Benefits of SRM WordPress Plugin
- **Seamless Embedding:** Embed dashboards, reports, charts, KPIs, or pivot tables into WordPress pages using simple shortcodes.
- **Full Interactivity Preserved:** Users can perform drill-downs, filtering, export, and interact with linked reports.
- **Clean Display:** Only the embedded resource appears, with no extra SRM interface.
- **Easy Workflow:** Copy resource URLs from SRM and paste into the plugin.
- **Supports Public and Private Content:** Works equally for unrestricted and protected resources.

### Examples of Embedded Resources
- **Sales Dashboard:** Demonstration with multiple charts, metrics, pivot tables, and reports. [View Example](https://demo.mysqlreports.com/wordpress/?page_id=93)
- **Linked Invoices per Customer Report:** Users can drill down from invoices to product details and suppliers. [View Example](https://demo.mysqlreports.com/wordpress/?page_id=67)
- **Pivot Table:** Filter data dynamically using embedded parameters. [View Example](https://demo.mysqlreports.com/wordpress/?page_id=78)

### Main Features of the Embed WP Plugin
- **Unified Setup:** All configurations managed from a dedicated SRM Embed Manager page inside Smart Report Maker:
  - **Left Panel:** Configure API URL and Access Key.
  - **Right Panel:** Copy URLs of SRM resources to embed.
- **Encrypted Access Keys:** Securely encrypted for authentication.
- **Expiring Embed Tokens:** Tokens have adjustable expiration times for security.
- **Origin Restrictions:** Enforce embedding from specific domains or allow any origin.
- **Feature Retention:** End users can still perform drill-downs, filtering, and exporting.
- **Signed Links:** Use signed URLs to prevent tampering.

## Security Best Practices
1. **Embed Private Resources Only in Protected Pages**
   - *Public Resources:* Can be embedded anywhere with no restrictions.
   - *Private Resources:* Should only be embedded on secure, membership-only pages to prevent unauthorized access.

2. **Restrict Access Keys to Approved Origins**
   - Use the embed origin policy to limit usage to trusted domains.
   - Configure in SRM to restrict keys to your WordPress site's domain.

3. **Avoid Using Full-Access Keys**
   - Use limited access keys with permissions only to necessary resources.
   - This minimizes security risks by reducing access scope.

## Frequently Asked Questions

- **How to download the SRM Reports WordPress plugin?**  
  Download from the official WordPress repository: [SRM Reports WordPress Plugin](https://wordpress.org/plugins/srm-embed-smart-report-maker/)

- **How to see the plugin in action?**  
  Watch tutorials at [Video Tutorials](https://mysqlreports.com/webuccino-screencasts/) or test with the [online demo version](https://demo.mysqlreports.com/wordpress).

- **How to configure the plugin?**  
  Access the "Embed Manager" section within your Smart Report Maker installation or the online demo to set API URL and Access Keys.

- **Can users interact with embedded dashboards/reports?**  
  Yes, full interactivity including filtering, drill-downs, search, paging, and exporting.

- **Is token and key storage secure?**  
  All tokens and keys are encrypted using WordPress salts. Access can be limited to specific origins for enhanced security.

## Related Links
- [Guide to Securely Embedding Reports in WordPress](https://mysqlreports.com/blog/how-to-securely-embed-reports-dashboards-and-charts-in-wordpress-using-the-srm-embed-plugin/)
- [Report Linking & Chaining](https://mysqlreports.com/report-linking/)
- [Embed Manager Details](https://mysqlreports.com/srm-modules-embed-manager/)
- [Pivot Tables Info](https://mysqlreports.com/php-mysql-pivot-tables/)
- [Dashboards](https://mysqlreports.com/php-dashboards-for-mysql/)
- [Reports](https://mysqlreports.com/php-reports/)
- [Charts](https://mysqlreports.com/php-charts/)
- [What's New in SRM](https://mysqlreports.com/blog/smart-report-maker-11-0-release-powerful-new-features/)
- [Video Tutorials](https://mysqlreports.com/webuccino-screencasts/)
- [Demo Version](https://demo.mysqlreports.com/)

## About Webuccino
Webuccino has been creating easy-to-use reporting tools since 2007. [Learn more](https://mysqlreports.com/about/).

## Contact and Social Media
- [YouTube](https://www.youtube.com/user/MrStarsoft2011)  
- [Vimeo](https://vimeo.com/115685915)

---

*This document is a conversion of the main content of the web page regarding the SRM WordPress Plugin. No specific API endpoint references were present to document as an API reference.*

---

## Page: https://mysqlreports.com/srm-modules-embed-manager

# SRM Modules – Embed Manager

## Overview
The Smart Report Maker (SRM) Embed Manager allows you to easily embed reports, dashboards, charts, KPIs, and pivot tables—created in SRM and connected to MySQL databases—directly into any PHP-based application. It ensures secure embedding without writing additional code while maintaining full interactivity, enabling users to drill down, filter data, and export results within your app.

The Embed Manager offers control over permissions, access rules, customization, and display settings, whether resources are private for authenticated users or public for wider access.

---

## Benefits of the SRM Embed Manager

- **Full interactivity** (drill-down, filtering, exporting, linked navigation) is preserved.
- **No manual coding**: Embed files are automatically generated.
- Works with both **public** and **private** resources using different embedding methods.
- **Secure access** using Access Keys with permissions and origin restrictions.
- **Access logs** for private embeds—view details in the Smart Report Maker logs.
- **Custom code support** (headers, authentication, layout) via Embed Preferences.
- **Signed links and expiring tokens** protect private content.
- Compatible with **PHP apps, internal systems, portals, and frameworks**.
- WordPress users can embed reports using the [SRM WordPress plugin](https://mysqlreports.com/srm-embed-smart-report-maker/).

---

## Key Features

### Access Keys (Security Layer)
Smart Report Maker offers two types of Access Keys for private resources:

#### 1. Full Access Key
- Grants access to *all* SRM resources.
- Suitable for testing or admin embedding.
- **Not recommended for production** due to lack of restrictions.

#### 2. Limited Access Key (Recommended)
- Grants access **only** to resources assigned to specific permission groups (e.g., Sales, HR, Finance).
- Ideal for role-based security and preventing access to unrelated resources.

### Origin Types (Where Embedding is Allowed)
When generating embed files, specify the permitted load origins:

#### a. Same Origin
- When SRM and your PHP app are hosted on the **same domain**.
- No extra setup needed.
- **Examples**:
  - `app.example.com` and `reports.example.com`
  - `localhost` during development

#### b. Approved Origins
- When hosting on **different domains**.
- Specify allowed origin(s), such as:
  - `https://myapp.com`
  - `https://portal.company.net`
- Embedding only allowed from these whitelisted domains.

#### c. Any Origin
- Embedding from **any domain** without restriction.
- Suitable for demos or public content.
- **Note**: Not recommended for private/sensitive resources.

---

## Generating Embed Files

The Embed Manager can generate ready-to-use PHP (or HTML) files that include:

- Your selected resource
- Custom code from preferences
- Dimensions and display settings
- Correct Access Key configuration
- Token expiration settings

You simply download the file and place it into your PHP project—no manual coding required.

---

## Embed Preferences

Accessible via the **Embed Preferences** page, allowing you to set global configurations that apply to all generated embed files for consistency:

- **Before-Embed PHP code**: Run custom PHP before the embedded resource loads, e.g.:
  - Include application headers/layout
  - User authentication checks
  - Redirect unauthorized users
  - Initialize session data

- **After-Embed code**: Add content after the embedded resource, such as:
  - Footers
  - Layout wrappers
  - Additional scripts or widgets

- **Embed Dimensions**: Set default width and height.

- **Token Expiration Time**: Set how long the embed token remains valid (in minutes).

---

## Supporting Full Functionality

Embedded reports and dashboards are fully interactive and allow users to:

- Drill down into data
- Filter results
- Export data
- Navigate linked resources

throughout their session inside your application.

---

## Security Features

- **Signed Links & Embed Tokens**:
  - Private resources use signed requests with Access Keys.
  - Temporary embed tokens with defined expiration.
  - Origin whitelisting optional.

- **WordPress Integration**:
  - Use the [SRM WordPress plugin](https://mysqlreports.com/srm-embed-smart-report-maker/) for embedding resources within WordPress sites.

- **Access Activity Log**:
  - All accesses to private resources are logged.
  - View activity details such as resource accessed, used Access Key, timestamp, and origin within the **Access Control Log** of the Embed Manager.

---

## Best Security Practices

- **Protect private embed files** by placing them in secured PHP application areas; use authentication checks in "Before Embed" code to prevent direct access.
- **Restrict Access Keys**:
  - Use *Limited Access Keys* with permissions for specific resource groups.
  - Restrict embedding to trusted origins.
- **Assign Access Keys** to specific permission groups that match embedded resources.
- Keep tokens short-lived for better security.
- Ensure consistent and secure origin configurations to prevent unauthorized embedding.

---

## Frequently Asked Questions (FAQ)

### Can the Embed Manager embed any resource?
- Yes. You can embed reports, dashboards, charts, KPIs, and pivot tables created in Smart Report Maker.

### Are embedded dashboards interactive?
- Yes. Users can filter, drill down, search, page, and sort data, just as within SRM.

### Will SRM menus be visible inside the embedded content?
- No. Only the embedded resources are shown. SRM menus and panels are hidden, allowing you to apply custom branding.

### How do I restrict embedding to my applications?
- By configuring origin settings (same-origin or approved origins).
- Use access keys with limited permissions.

### How to manage embedding for multiple clients?
- Use separate access keys per client/application.
- Limit each key to relevant resources and approved origin.

### Can I customize embed scripts?
- Yes. The generated PHP files can be modified, and shared global settings can be applied via Embed Preferences.

---

## Related Links
- [Report Linking & Chaining](https://mysqlreports.com/report-linking/)
- [WordPress Plugin](https://mysqlreports.com/srm-embed-smart-report-maker/)
- [Embed Manager Details](https://mysqlreports.com/srm-modules-embed-manager/)
- [Pivot Tables](https://mysqlreports.com/php-mysql-pivot-tables/)
- [Dashboards](https://mysqlreports.com/php-dashboards-for-mysql/)
- [Reports](https://mysqlreports.com/php-reports/)
- [Charts](https://mysqlreports.com/php-charts/)
- [New Features in SRM](https://mysqlreports.com/blog/srm-11-0-release-powerful-new-features/)
- [Video Tutorials](https://mysqlreports.com/webuccino-screencasts/)
- [Demo Version](https://demo.mysqlreports.com/)

---

## About Webuccino

Webuccino has been creating easy-to-use reporting tools since 2007.  
[Read more about Webuccino](https://mysqlreports.com/about/).

---

## Highlights of SRM Modules
- [PHP Reports for MySQL](https://mysqlreports.com/php-reports/)
- [Report Linking & Chaining](https://mysqlreports.com/report-linking/)
- [WordPress Reports & Dashboards](https://mysqlreports.com/srm-embed-smart-report-maker/)
- [Application Reports & Dashboards](https://mysqlreports.com/srm-modules-embed-manager/)
- [MySQL Pivot Tables](https://mysqlreports.com/php-mysql-pivot-tables/)
- [PHP Dashboards](https://mysqlreports.com/php-dashboards-for-mysql/)
- [PHP Charts](https://mysqlreports.com/php-charts/)
- [MySQL Data Analysis](https://mysqlreports.com/mysql-data-analysis/)
- [Managing Dashboards](https://mysqlreports.com/smart-report-maker-docs/docs/dashboards/mysql-dashboards-managing-and-customizing-your-data-insights/)
- [PHP Form Builder](https://mysqlreports.com/mysql-reporting-tools/php-mysql-form-generator/)
- [PHP Reporting Library](https://mysqlreports.com/mysql-reporting-tools/smart-report-engine/)

---

## Support
- [Customer Support](https://mysqlreports.com/open-ticket/)
- [FAQ](https://mysqlreports.com/faq/)
- [Documentation](https://mysqlreports.com/mysql-report-generator-manual/)
- [Video Tours](https://mysqlreports.com/webuccino-screencasts/)
- [Demo Version](https://demo.mysqlreports.com/)

---

## Legal and Miscellaneous
- © Webuccino 2007–2025  
- [Privacy Policy](https://mysqlreports.com/privacy-policy/)
- [About Webuccino](https://mysqlreports.com/about/)
- [User Testimonials](https://mysqlreports.com/smart-report-maker-testimonials/)
- [Sitemap](https://mysqlreports.com/web-sitemap/)

---

## Page: https://mysqlreports.com/web-sitemap

# Webuccino Reporting Tools Overview

Webuccino has been creating easy-to-use reporting tools since 2007. The platform offers a suite of products designed for reporting, data analysis, dashboards, and form generation for MySQL databases.

---

## Our Main Products

### [Smart Report Maker](https://mysqlreports.com/mysql-reporting-tools/the-best-mysql-report-builder/)
A comprehensive tool for building MySQL reports with modular features such as:
- PHP Report Builder modules
- Report Linking & Chaining
- WordPress Plugin Integration
- Embed Manager for dashboards and reports
- PHP Charts for MySQL
- Pivot Tables for MySQL
- PHP dashboards for data visualization
- Data analysis modules

### [Smart Report Engine](https://mysqlreports.com/mysql-reporting-tools/smart-report-engine/)
A flexible PHP reporting library for creating custom reports.

### [Smart Form Maker](https://mysqlreports.com/mysql-reporting-tools/php-mysql-form-generator/)
A tool for generating PHP/MySQL forms easily.

### [Demo Version](https://demo.mysqlreports.com)
See the tools in action.

### [Video Tours](https://mysqlreports.com/webuccino-screencasts/)
Visual demonstrations of product features.

### [Purchase](https://mysqlreports.com/buy/)
Options to buy the products.

---

## Help & Support

- [Open Ticket](https://mysqlreports.com/open-ticket/)
- [FAQ](https://mysqlreports.com/faq/)
- [Sitemap](https://mysqlreports.com/web-sitemap)

---

## Documentation

- [Smart Report Maker Documentation](https://mysqlreports.com/smart-report-maker-docs/smart-report-maker-docs/)
  - [Getting Started](https://mysqlreports.com/smart-report-maker-docs/docs/getting-started/install/)
  - [Settings](https://mysqlreports.com/smart-report-maker-docs/docs/settings/groups/)
  - [Report Management](https://mysqlreports.com/smart-report-maker-docs/docs/reports/php-reporting-tool-for-mysql/)
  - [Charts Management](https://mysqlreports.com/smart-report-maker-docs/docs/charts/mysql-charts-and-data-analysis/)
  - [KPIs Management](https://mysqlreports.com/smart-report-maker-docs/docs/kpis/comprehensive-kpi-methods-for-php-data-analysis/)
  - [Dashboards](https://mysqlreports.com/smart-report-maker-docs/docs/dashboards/mysql-dashboards-managing-and-customizing-your-data-insights/)
  - [Scheduled Reports](https://mysqlreports.com/smart-report-maker-docs/docs/scheduled-reports/mysql-scheduled-reports/)
- [Smart Form Maker Documentation](https://mysqlreports.com/docs/sfm.pdf)

---

## About Us

Webuccino has been dedicated to creating user-friendly reporting tools since 2007. [Read more](https://mysqlreports.com/about/).

---

## Tutorials & Guides

- [One Smart Report Maker Installation for Multiple PHP Applications](https://mysqlreports.com/blog/one-smart-report-maker-installation-for-multiple-php-client-applications/)
- [Securely Embed Reports, Dashboards, Charts, and Pivot Tables in WordPress](https://mysqlreports.com/blog/how-to-securely-embed-reports-dashboards-and-charts-in-wordpress-using-the-srm-embed-plugin/)
- [Adding Reports and Dashboards to an AppGini Application](https://mysqlreports.com/blog/adding-smart-report-maker-reports-and-dashboards-to-an-appgini-application/)
- [Create an Interactive Time Series Chart from Your MySQL Database](https://mysqlreports.com/smart-report-maker-docs/docs/charts/php-time-series-chart/)
- [Create KPIs with Historical Comparison](https://mysqlreports.com/smart-report-maker-docs/docs/kpis/30-days-orders-count-kpi-example-for-mysql-data-analysis/)
- [Integrate Reports into Your Software Projects](https://mysqlreports.com/blog/integrate-created-reports-with-smart-report-maker-into-your-software-project/)
- [Create PHP MySQL Master/Details Forms](https://mysqlreports.com/blog/subforms-in-php-mysql-form-maker/)
- [Generate Quarterly Sales Reports Using Pivot Tables](https://mysqlreports.com/blog/generating-a-quarterly-sales-report-from-a-mysql-db-using-smart-pivot-table/)
- [Generate Pivot Tables from MySQL](https://mysqlreports.com/blog/generating-a-pivot-table-cross-tabulation-from-mysql-using-smart-pivot-table/)
- [Create Reports with Dynamic Images](https://mysqlreports.com/blog/generating-a-report-with-image-field-from-any-mysql-database/)
- [Add Languages to Smart Report Maker](https://mysqlreports.com/blog/adding-new-languages-to-smart-report-maker/)
- [Create Reports Based on SQL Queries or Views](https://mysqlreports.com/blog/creating-report-based-query-view/)
- [Troubleshoot Proxy Errors](https://mysqlreports.com/blog/proxy-error-received/)
- [Smart Report Engine Tutorials](https://mysqlreports.com/examples/)
  - Creating reports with data filters
  - Creating mobile-friendly reports
  - Converting SQL queries to reports
  - Using conditional formatting
  - Integrating with login systems
  - Using multiple tables
  - Column customization
  - Primary usage scenarios

---

## Latest News & Releases

- [Smart Report Maker 11.0](https://mysqlreports.com/blog/smart-report-maker-11-0-release-powerful-new-features/)
- [Smart Report Maker 10.0](https://mysqlreports.com/blog/mysql_pivot_tables/)
- [Smart Report Maker 9.0](https://mysqlreports.com/blog/php-dashboard-builder-and-php-report-writer-for-mysql/)
- [Version 8.1.0](https://mysqlreports.com/blog/smart-report-maker-version-8-0-0-has-been-released/)
- [Smart Report Engine Release](https://mysqlreports.com/blog/php-reporting-framework/)
- [Version 7.1.0](https://mysqlreports.com/blog/smart-report-maker-version-7-1-0-has-been-released/)
- [Version 7.0](https://mysqlreports.com/blog/smart-report-maker-7-0-released/)
- [Smart Form Maker 3.1.0](https://mysqlreports.com/blog/mysql-form-maker-version-3-0-is-released/)
- [Pivot Table 1.1](https://mysqlreports.com/blog/mysql-pivot-table-new-release/)
- [Version 6.0](https://mysqlreports.com/blog/mysql-report-maker-6-0-has-been-released/)
- [Smart Chart Maker 2.0](https://mysqlreports.com/blog/mysql-graph-generator/)

---

## Contact & Social Media

- YouTube: [MrStarsoft2011](https://www.youtube.com/user/MrStarsoft2011)
- Vimeo: [Screencast](https://vimeo.com/115685915)

---

## Highlights of Our Products

- PHP Reports for MySQL
- Report Linking & Chaining
- WordPress Reports & Dashboards
- Application Report Embed & Management
- MYSQL Pivot Tables
- PHP Dashboards
- PHP Charts for MySQL
- MySQL Data Analysis
- Dashboard Management
- PHP Form Builder
- PHP Reporting Library

---

## Legal & Footer

Copyrights Reserved 2007 - 2025 © Webuccino.  
[Privacy Policy](https://mysqlreports.com/privacy-policy/), [About Webuccino](https://mysqlreports.com/about/), [User Testimonials](https://mysqlreports.com/smart-report-maker-testimonials/), [Sitemap](https://mysqlreports.com/web-sitemap/).

---

## Page: https://mysqlreports.com/webuccino-screencasts

# Webuccino Screencasts

## About Webuccino
Webuccino has been creating easy-to-use reporting tools since 2007. [Read more](https://mysqlreports.com/about/).

## Links and Social Media
- [YouTube Channel](https://www.youtube.com/user/MrStarsoft2011)  
- [Vimeo Video](https://vimeo.com/115685915)

## Highlights of Webuccino Products
- [PHP Reports for MySQL](https://mysqlreports.com/php-reports/)
- [Report Linking & Chaining](https://mysqlreports.com/report-linking/)
- [Reports & Dashboards in WordPress](https://mysqlreports.com/srm-embed-smart-report-maker/)
- [Reports & Dashboards in Your Application](https://mysqlreports.com/srm-modules-embed-manager/)
- [MYSQL Pivot Tables](https://mysqlreports.com/php-mysql-pivot-tables/)
- [PHP Dashboards for MySQL](https://mysqlreports.com/php-dashboards-for-mysql/)
- [PHP Charts for MySQL](https://mysqlreports.com/php-charts/)
- [MySQL Data Analysis](https://mysqlreports.com/mysql-data-analysis/)
- [Manage Dashboards](https://mysqlreports.com/smart-report-maker-docs/docs/dashboards/mysql-dashboards-managing-and-customizing-your-data-insights/)
- [PHP Form Builder for MySQL](https://mysqlreports.com/mysql-reporting-tools/php-mysql-form-generator/)
- [Easy-to-Use PHP Reporting Library](https://mysqlreports.com/mysql-reporting-tools/smart-report-engine/)

## Help Resources
- [Customer Support](https://mysqlreports.com/open-ticket/)
- [FAQ](https://mysqlreports.com/faq/)
- [Docs](https://mysqlreports.com/mysql-report-generator-manual/)
- [Video Tours](https://mysqlreports.com/webuccino-screencasts/)
- [Demo Version](https://demo.mysqlreports.com/login)

## Copyright
**Copyrights Reserved 2007 - 2025 © Webuccino.**

## Footer Links
- [Privacy Policy](https://mysqlreports.com/privacy-policy/)
- [About Webuccino](https://mysqlreports.com/about/)
- [User Testimonials](https://mysqlreports.com/smart-report-maker-testimonials/)
- [Sitemap](https://mysqlreports.com/web-sitemap/)

---

## Page: https://mysqlreports.com/why-choose-our-mysql-reporting-tools

# Webuccino: Creating Easy-to-Use Reporting Tools Since 2007

## Overview

Webuccino offers PHP reporting tools tailored for MySQL databases, enabling users to generate professional reports, charts, pivot tables, KPIs, dashboards, and more. Designed for developers, data analysts, and business owners, these tools facilitate quick and efficient data extraction and visualization without requiring programming knowledge.

---

## Top Reasons to Choose Our PHP Reporting Tools

### 1. Create Multiple Data Visualizations in One Solution
- Generate reports, charts, Pivot tables, KPIs, and dashboards from any MySQL database.
- No coding required.
- Supports effective data visualization and insights.

### 2. Effortless Installation
- Web-based installer; upload and launch via browser.
- No command-line commands or complex server setups needed.
- Quick deployment in minutes.

### 3. Broad Compatibility
- Supports shared hosting, VPS, and dedicated servers.
- Flexible hosting options.

### 4. Established Market Presence
- Operating since 2007.
- Trusted by thousands globally.

### 5. Embed Reports & Dashboards in PHP Applications
- Secure Embed Manager enables seamless integration.
- Dynamic content supporting filters, links, and drill-downs.
- Maintains security and flexibility.

### 6. One-Time Payment Model
- No recurring fees, subscriptions, or hidden costs.
- Lifetime access with a single purchase.

### 7. WordPress Plugin Available
- Easy embedding of reports, charts, and dashboards into WordPress sites.

### 8. Advanced Data Analysis Features
- Drill-downs, metrics, dashboards.
- Pivot tables, historical comparisons, time-series charts.
- Enables users to explore data independently.

### 9. Complete Data Privacy
- Runs on your own server.
- No data sent to external servers.

### 10. Customization Options
- Brand your reports with logos.
- Full control over layout, styles, headers, and footers.

### 11. User-Friendly Interface
- Intuitive design suitable for non-technical users.

### 12. Dedicated Support Service
- Free, personalized assistance.
- Fast resolution of issues.

---

## Related Resources

### About Webuccino
- Creating easy-to-use reporting tools since 2007.  
  [Read more](https://mysqlreports.com/about/)

### Helpful Links
- [YouTube Channel](https://www.youtube.com/user/MrStarsoft2011)
- [Vimeo Channel](https://vimeo.com/115685915)

---

## Product Highlights & Features

- [PHP Reports for MySQL](https://mysqlreports.com/php-reports/)
- [Report Linking & Chaining](https://mysqlreports.com/report-linking/)
- [Reports & Dashboards in WordPress](https://mysqlreports.com/srm-embed-smart-report-maker/)
- [Embed Manager for Applications](https://mysqlreports.com/srm-modules-embed-manager/)
- [MySQL Pivot Tables](https://mysqlreports.com/php-mysql-pivot-tables/)
- [PHP Dashboards for MySQL](https://mysqlreports.com/php-dashboards-for-mysql/)
- [PHP Charts for MySQL](https://mysqlreports.com/php-charts/)
- [MySQL Data Analysis](https://mysqlreports.com/mysql-data-analysis/)
- [Manage Dashboards](https://mysqlreports.com/smart-report-maker-docs/docs/dashboards/mysql-dashboards-managing-and-customizing-your-data-insights/)
- [PHP Form Builder for MySQL](https://mysqlreports.com/mysql-reporting-tools/php-mysql-form-generator/)
- [PHP Reporting Library](https://mysqlreports.com/mysql-reporting-tools/smart-report-engine/)

### Help & Support
- [Customer Support](https://mysqlreports.com/open-ticket/)
- [FAQ](https://mysqlreports.com/faq/)
- [Documentation](https://mysqlreports.com/mysql-report-generator-manual/)
- [Video Tours](https://mysqlreports.com/webuccino-screencasts/)
- [Demo Version](https://demo.mysqlreports.com/login)

---

## Additional Information

**Legal & Policies**  
- [Privacy Policy](https://mysqlreports.com/privacy-policy/)  
- [About Webuccino](https://mysqlreports.com/about/)  
- [User Testimonials](https://mysqlreports.com/smart-report-maker-testimonials/)  
- [Site Map](https://mysqlreports.com/web-sitemap/)

**Copyright**  
Webuccino © 2007 - 2025. All rights reserved.

---