Query params/var request to user in runtime

Stimulsoft Reports.PHP discussion
Post Reply
3inweb
Posts: 9
Joined: Sun Mar 11, 2012 11:29 am
Location: Spain

Query params/var request to user in runtime

Post by 3inweb »

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
Alex K.
Posts: 6488
Joined: Thu Jul 29, 2010 2:37 am

Re: Query params/var request to user in runtime

Post by Alex K. »

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.
3inweb
Posts: 9
Joined: Sun Mar 11, 2012 11:29 am
Location: Spain

Re: Query params/var request to user in runtime

Post by 3inweb »

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
Vladimir
Posts: 1462
Joined: Fri Apr 13, 2007 4:05 am
Location: Earth

Re: Query params/var request to user in runtime

Post by Vladimir »

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.
Post Reply