Smart Report Maker is the best PHP report maker for MySQL, it comes with many powerful features, and a very easy to use wizard style interface!
In this step, you should enter the connection parameters for the MYSQL database you intend to use to generate your reports.
Server name or IP address.
User name and password:
The user name should have only a “select” permission. Additional permissions are neither recommended nor required.
Database:
The database that you intend to use to create your report for mysql.
Template : a saved template to use for your report.
Data Source:
Table(s) or a SQL query.
In this step you can do the following :
1.2.1.Choose the table(s) you require for your PHP report. You can select Multiple tables by holding the “CTRL” key while selecting your tables.
1.2.2. Define inner table relationships (if multiple tables were selected)
For each relation you should select:
The parent table from the “Left Table” list.
The primary key from the “Left Field” list.
The related/child table from the “Right table” list.
The foreign key from the “Right Field” list.
Using smart report maker, you can build PHP reports based on SQL quires. There are two options for doing this :
For those users who desire more control, you can create multiple data filters and select the exact data you wish to include in your report. Your Filters will depend on the data type of the filtered field. For example, if you want to filter a column with a textual data type, you will find only textual filters, such as like, No like, begin with, etc.
Starting from version 7.1.0 you can build PHP
parameterized reports from your MYSQL DB.
For example you can easily create a sales report by date
range where each user can define the date range they want to see.
In this step you can do the following :
1.4.1. Select The columns that you intend to use in your report.
1.4.2. Label your fields to make them more user-friendly with more recognizable / relevant names instead of their SQL names. For example, you might use “Customer Number” instead of “CustomerID” .
Starting from version 7.0.0 you can :
1.4.3. Use Aggregation functions.
For example, if you want to generate a report for the average salary of male and female employees, “Function” should be “AVG”. Affected column should be “Salary”, Grouped by “Gender”.
In this step you can do the following:
1.5.1. Define Multiple grouping levels. For example, you can group your customers by country in order to get the customer details for each country.
1.5.2. Sorting data according to any specific column(s) in ascending or descending order.
In this step you can set the following :
You can select both the layout and style of your report .
Password Protection:
With Our PHP report generator, you can prevent unauthorized access to generated reports by checking the “Password Protect Generated Report” option and then adding an Admin User name and password . Each username and password protects one report, so each report should have a user name and password. You can also choose to disable the password protection function for some reports.
Members log in
This feature allows your member’s stored usernames and passwords to access the generated report. Simply do the following:
-Select the table and fields that contain the log-in information of your members.
-If the passwords of your members are encrypted, please select the PHP function.
In this step, you can customize your report by adding a title, a header, and a footer. Additionally, you can Specify the number of records you want to display on each page.
We are extremely excited and proud to present the latest version of Smart Report Maker. Smart Report Maker is the best PHP report maker for MySQL you have ever wished for.
The new version of Smart Report Maker has a new look and feel.
Ability to generate Parameterized Reports
Using Smart Report Maker v7.1.0 or later you can generate parameterized reports
Ability to generate Multilingual reports
Using Smart Report Maker v7.0.0 or later you can generate multilingual reports
More secure and stable
Smart Report Maker employs several newly released PHP functions which are designed to offer more robust and stable security measures within the software. Have a much greater degree of confidence when generating PHP reports with SRM 6.0.
Views
With Smart Report maker 6.0, reports can be created based on MySQL views. Simply select the “SQL Query” option in the data source and check the existing view.
The SQL query text area will automatically be populated with the syntax of the selected view.