1. How to install a Stimulsoft Reports.Fx for PHP?
2. How to show report in Viewer.Fx?
3. How to design new report?
4. How to design a specified report?
5. How to use parameters in the SQL query?
6. How to set values of variables, used in the report?
7. How to save report, changed in Designer.Fx, on the server or in the database?
8. Which databases are supported?
9. How to configure the Designer.Fx and Viewer.Fx?
|
1. How to install a Stimulsoft Reports.Fx for PHP?
The installation package contains a QuickStart folder. This folder contains all application files, including the 'index.html' file. So all files from this folder are required to be copied on your PHP server (using ftp or http access interface - depending on your hosting provider). Then, in your browser, you can go to the following address:
| http://you_domain_name/index.html |
If you use the PHP server installed on local developers computer:
| http://localhost/index.html |
Back to top
|
2. How to show report in Viewer.Fx?
To show report in a viewer it is necessary to call the 'index.php' file with the following parameters:
| http://localhost/stimulsoft/index.php?stimulsoft_client_key=ViewerFx&stimulsoft_report_key=Report.mrt |
stimulsoft_client_key: parameter, that determines which report will be loaded
You can manage reports loading in the 'sti_get_report' function, which is located in the 'index.php' file.
Back to top
|
3. How to design new report?
To load the designer it is necessary to call the 'index.php' file with the following parameters:
| http://localhost/stimulsoft/index.php?stimulsoft_client_key=DesignerFx |
Back to top
|
4. How to design a specified report?
To load the designer it is necessary to call the 'index.php' file with the following parameters:
| http://localhost/stimulsoft/index.php?stimulsoft_client_key=DesignerFx&stimulsoft_report_key=Report.mrt |
stimulsoft_client_key: parameter, that determines which report will be loaded
You can manage reports loading in the 'sti_get_report' function, which is located in the 'index.php' file.
Back to top
|
5. How to use parameters in the SQL query?
To use parameters in the SQL query, the parameters must be specified by the following way:
| SELECT * FROM table LIMIT {param1} |
Then parameters, specified in SQL query, must be added in the URL request with the same name:
| http://localhost/stimulsoft/index.php?stimulsoft_client_key=ViewerFx&stimulsoft_report_key=Report.mrt&Param1=10 |
Also, you can manage parameters in the 'sti_get_parameter' function, which is located in the 'index.php' file.
Back to top
|
6. How to set values of variables, used in the report?
Variables, used in the report, can be set in the URL request with the same name:
| http://localhost/stimulsoft/index.php?stimulsoft_client_key=ViewerFx&stimulsoft_report_key=Report.mrt&var1=10&var2=text |
Also, you can use the 'Request from User' option. In this case, the variables will be requested in the Viewer.Fx window.
Back to top
|
7. How to save report, changed in Designer.Fx, on the server or in the database?
For this you must use the 'sti_save_report' function, which is located in the 'index.php' file. When you click the 'Save' button in the Designer.Fx, this function will be called. As a parameter the report for saving will be passed.
Back to top
|
8. Which databases are supported?
Currently supports the following data types: XML, MSSQL, MySQL, PostgreSQL, ODBC, Firebird, Oracle.
Back to top
|
9. How to configure the Designer.Fx and Viewer.Fx?
The 'config.xml' file is used to configure the Designer.Fx and Viewer.Fx. This file is automatically called by the designer of viewer immediately after loading. The description of all available options can be found in our documentation.
Back to top
|
