Hello -
I am working in CR XI, and the data source is SQL. I am using a view as the data source behind my cascading parameter. The parameter has 3 levels.
I am allowing a multple selection on each level, when I select the parameters in the 1st and 2nd level parameters, the 3rd level of the cascade only reflects data that is related to the 1st selection in the first level of the parameter. Does this make sense? It almost seems as if the query is looking at the 1st selection on the 1st level of the cascading parameter, and stopping there to gather the data for the 3rd. Its not even taking the 2nd selection of the 1st level parameter into consideration.
Also, I have updated my registry to increase the number if available parameter selections- so that is not the problem.
THANK YOU!
I am working in CR XI, and the data source is SQL. I am using a view as the data source behind my cascading parameter. The parameter has 3 levels.
I am allowing a multple selection on each level, when I select the parameters in the 1st and 2nd level parameters, the 3rd level of the cascade only reflects data that is related to the 1st selection in the first level of the parameter. Does this make sense? It almost seems as if the query is looking at the 1st selection on the 1st level of the cascading parameter, and stopping there to gather the data for the 3rd. Its not even taking the 2nd selection of the 1st level parameter into consideration.
Also, I have updated my registry to increase the number if available parameter selections- so that is not the problem.
THANK YOU!