In this step, you should enter the connection parameters for the 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.
The database that you intend to use to create your report for mysql.
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.
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” .
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 .
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.
Version 6.0 features an upgraded navigation menu that greatly simplifies navigating within SRM 6.0. Additionally, many optional steps are grouped into tabs. This feature satisfies the demand of many clients who have called for an easier way to get around the software.
More secure and stable
SRM Version 6.0 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.
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.