1. How to install a Stimulsoft Reports.PHP?

The installation package contains a PHP/Flex 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

2. How to show report in viewer?

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 report's loading in the 'sti_get_report' function, which is located in the 'index.php' file.

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

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.

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.

6. How to set values of variables, used in the report?

Variables, used in the report, can be set in the GET or POST request with the same name, for example:

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

7. How to save report, changed in designer, on the server or in the database?

Variables, used in the report, can be set in the GET or POST request with the same name, for example:

http://localhost/stimulsoft/index.php
	?stimulsoft_client_key=ViewerFx&stimulsoft_report_key=Report.mrt&var1=10&var2=text

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, this function will be called. As a parameter the report for saving will be passed.

8. Which databases are supported?

Currently supports the following data types: XML, MSSQL, MySQL, PostgreSQL, ODBC, Firebird, Oracle.

9. How to configure the designer and viewer?

The 'config.xml' file is used to configure the designer and viewer. This file is automatically called by the designer of viewer immediately after loading. The description of all available options can be found in the quick start application.