Home
Designing Analytics Reports
How to use Parameter with ListBox to pass multiple entry(data set with query in case of IN(multiple
Migrateduser
<p>Hi All I have a requirement about when client wants to select Branch of the parameter(List Box), So client can select any Branch or select All to see all of them for the report, for now we use data set with the query and use statement like "Select * from table where column in (?)" in this case i define the parameter of List Box in case of All(Value is A,B,C,D) so in this case we expect the result like : "Select * from table where column in (A,B,C,D)" as i try to test the query in the DB is working fine but when i try to run this case on the report it i'not working <br>
Step that i have modified</p>
<p>- for the query Like : Select * from table where column in (?)</p>
<p>- for the parameter that i have created is List Box and the value is : A,B,C,D</p>
<p>- for the parameter the i get to pass in the query is : params["Branch"].value</p>
<p> </p>
<p>So ,Do you have any help with this case?</p>
<p>Thanks</p>
Find more posts tagged with
Comments
There are no comments yet