MENU

Smart Report Maker v6.0
smart report maker


1.Getting started

1.1.Connect

In this step, you should enter the connection parameters for the database you intend to use to generate your reports.

report for mysql GeneratorServer name or IP address.
report for mysql GeneratorUser name and password:
The user name should have only a “select” permission. Additional permissions are neither recommended nor required.
report for mysql GeneratorDatabase:
The database that you intend to use to create your report for mysql.
report for mysql GeneratorData Source:
Table(s) or a SQL query.

contact to mysql

1.2. Data Source

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:
report for mysql GeneratorThe parent table from the “Left Table” list.
report for mysql GeneratorThe primary key from the “Left Field” list.
report for mysql GeneratorThe related/child table from the “Right table” list.
report for mysql GeneratorThe foreign key from the “Right Field” list.

using data filters

1.2.3. SQL Queries Data Source

Building reports based on query using smart report maker

Using smart report maker, you can build PHP reports based on SQL quires. There are two options for  doing this :

  • Using the query editor for writing the database quires from scratch.
  • Selecting a stored view from your MySQL database.

1.3.Creating Data filter(s)

 

data filters

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.

1.4.Columns

Selecting columns

 

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.

 

MySQL Statistical functions

To use aggregation functions on your PHP reports, you should select the following :

  • The function you want to apply.
  • The affected column : the column on which you want to apply the selected aggregation function.
    ( it should have a numeric data type)
  • The “group by” column.

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”.

 
1.5.Grouping

 

Report Multiple Grouping level

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.

 

1.6.Settings

 

In this step you can set the following :

1.6.1. The appearance settings :

You can select both the layout and style of your report .

1.6.2.The security settings:

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.

Security settings

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.

 

Report Member log in

 

 

Titles

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.

Report Titles

 

What’s new in Smart Report Maker 6.0?

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.

Easier navigation

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.

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.