Cascading prompt not pulling all parameters

[khoke]

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!

 

[Madawc]

Try checking the actual SQL code generated by the selection. You should find this on the menus under 'Datebase'.

If that doesn't make it clear, please post your formula and the SQL.

Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10

 

[khoke]

When I checked the SQL generated by the report against the actual database, all the data is correct. When I only use the first 2 parameters, the item that I would use as the 3rd parameter pulls back all the data I expect. However, when I try to add the 3rd paratameter, the selections that I can select from are not all the same items I was able to pull when using the 1st 2 parameters.
It's hard to explain - sorry if this is not making sense.

For example:
Parameter 1 and Parameter 2 return 15 items on a report.
If i added those items as a 3rd parameter, I would expect to get 15 available selections, but I might only get 8. Does that make sense?
THANKS!