Creating reports and dashboards | Stimulsoft community forum

Hey.

I am creating a repository of reports showing reports from a server folder. When the user clicks the load on the viewer Stimulsoft and is where the user must select values ​​for the variables that filter the SQL statement.

The steps I do are these:

1 - declare a variable eg "Var1" marking request the user list type and connect with the data source for the values ​​mostar

2 - declare a parameter "Var1" containing the value of the variable and apply it to the query example: "Select from table where name = {Var1} of the data source.

When I preview the report no data on the variable list, no data in the report

I would appreciate any recommendations for not having to go through URL parameters.


thanks

Hello,

1. You must set the default value for variable.

2. Please try to set the "Request form User" option for variable, in this case the value will be requested from user.

Thank you.

Hello again. Thanks for your answer, but the type of variable I am using is a list to be filled from a data source of the report. When I use the report never ends and displays the message "compiling".

I tryed to write data source without parameters and try to use the variable in the filter of the data source, the same thing happens.

I have the latest version installed. They are operational variables required of the user from a list connected to the data source?

Thanks for your answer

Sorry for the automatic translation of Google. I do not speak English well

Hello,

Unfortunately, at this moment Reports.Fx for PHP does not support variable of the list type in SQL query. You can use only simple types - String, Integer, etc.

Thank you.