|How do I get multiple parameter values processed in a Data Set? [message #1626795]
||Sat, 21 February 2015 06:01
| Al Koch
Registered: August 2011
I have a Cascading Parameter Group that is working correctly in the sense that I am able to take the selected value from the 1st parameter in the group and use it in the where clause to build the Data Set for the 2nd parameter. The 2nd parameter (a list box) is marked as "Multiple Values". In the 3rd (final) data set (which will return the values I want on the report) I have
... IN ? ...
and I define a Data Set Parameter for this as being linked to the 2nd parameter above that has multiple values. When I close the window where I define the Data Set parameter I get this warning:
"If a user sets multiple values for the report parameter, the data set parameter only uses the first value."
The warning is correct! If I run the report and select two values for the 2nd parameter in the Cascading Group the report shows that only the 1st value was used. My questions are:
1) what use is the "multiple values" selection if this is the result?
2) how can I have the report operate on multiple "filter" values as I tried to accomplish above?
[Updated on: Sat, 21 February 2015 19:05]
Report message to a moderator
Powered by FUDForum
. Page generated in 0.04479 seconds