Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations biv343 on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Cascading prompt not pulling all parameters

Status
Not open for further replies.

khoke

Programmer
Jul 8, 2005
20
US
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!
 
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.

[yinyang] Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10 [yinyang]
 
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!
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top