connect Stimulsoft with Mysql

[mahfouz]

Hi,
I using the Stimulsoft to create a set of reports where system users can view it and design new report as who want.

but there a big problem in the library. where I must add connection data in the MRT file. and any user can see it

also, I'm trying to use JSON file and XML, but this way will not be an efficient way because of the data changed every hour.

I hope if there another solution in your bag
- if I can connect with MySQL and user can't see the connection details
- if I can link the MRT file with requested file return data (JSON or XML)

[HighAley]

Hello.

The connection strings are parsed in the \stimulsoft\adapters\mysql.php file.
You could make any changes there and set the right connection string there.

Thank you.

[mahfouz]

i set the connection data in parse function in stimulsoft\adapters\mysql.php file

but how I can select the connection type.

I hope if you can send a full example to using Stimulsoft with MySQL connection.

[HighAley]

Hello.

The connection type should be specified in a report template.

Thank you.

[mahfouz]

Hi dear,
thanks for you

I using the library in create a lot of reports template to use it in the system

and the user can design report and re-design prepared the template.

I need to prevent the users from seeing the connection string in the report template.

I think there 2 solutions for this problem
1- prevent user from edit connection string
2- add connection string using code in PHP files
-----------

please send an example to explain the solution

[HighAley]

Hello.

Could you specify which version of our product you use?
Which Designer do you use Flash or HTML5?

Thank you.

[mahfouz]

Hello,

I using version FXPHP_2016.08.26
and using HTML5 for designer

[HighAley]

Hello.

You could try to set next option:

Code: Select all

var options = new Stimulsoft.Designer.StiDesignerOptions();
options.dictionary.dataConnectionsPermissions = Stimulsoft.Designer.StiDesignerPermissions.View;

It hides the connection string from the users.

Thank you.