Calvin LeBlanc
asked on
SSRS Cascading Multi Value Parameters not passing second Parameter values to report
Hi there, I'm working with SSRS Report Builder 3.0 and have two cascading parameters that appear to be working fine.
I have a dataset set up for Param1 and another dataset configured for Param2.
The Param1 dropdown list works fine, and passes the correct Param1 values to the Param2 dropdown list which shows the correct sublist of items available for multiple selections.
I have the main dataset edited in the 'Where' clause to filter to the items selected in Param1,, and also to filter to the items selected in Param2.
The problems:
1) When i have both filters applied in the where clause, no records are returned although the cascading parameters appear to be working fine.
2) When i remove the Param2 filter from the Where clause, all of Param1 matches are returned, but Param2 selections are not applied.
Not sure how to confirm this but my guess is that Param2's values are not in a format that the report can use, and I'm not sure about how to resolve this issue. I've found multiple articles on cascading parameter configurations, but I'm apparently missing something around the sub-list and how it passes values to the report to use. Any assistance would be appreciated
Also the parameters used in the where clause are in parentheses () and i'm stating to look 'IN' the parameter value, and not using '=' equal to.
I have a dataset set up for Param1 and another dataset configured for Param2.
The Param1 dropdown list works fine, and passes the correct Param1 values to the Param2 dropdown list which shows the correct sublist of items available for multiple selections.
I have the main dataset edited in the 'Where' clause to filter to the items selected in Param1,, and also to filter to the items selected in Param2.
The problems:
1) When i have both filters applied in the where clause, no records are returned although the cascading parameters appear to be working fine.
2) When i remove the Param2 filter from the Where clause, all of Param1 matches are returned, but Param2 selections are not applied.
Not sure how to confirm this but my guess is that Param2's values are not in a format that the report can use, and I'm not sure about how to resolve this issue. I've found multiple articles on cascading parameter configurations, but I'm apparently missing something around the sub-list and how it passes values to the report to use. Any assistance would be appreciated
Also the parameters used in the where clause are in parentheses () and i'm stating to look 'IN' the parameter value, and not using '=' equal to.
ASKER
i think i found the solution in this link. will test it today..
https://www.experts-exchange.com/questions/28398459/SSRS-Dataset-with-multi-value-Parameters-in-query-ignore-where-clause-if-all-options-selected.html
https://www.experts-exchange.com/questions/28398459/SSRS-Dataset-with-multi-value-Parameters-in-query-ignore-where-clause-if-all-options-selected.html
ASKER
Not working yet.. :-/
ASKER
still working on this,, no solution yet.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Calvin