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!

Parameters missing values

Status
Not open for further replies.

khoke

Programmer
Jul 8, 2005
20
US
Hi!
I am using CR XI, against a MS SQL database and am having trouble with my cascading parameter prompts.

I have a parameter with 5 levels, and after I enter the 3rd parameter, data starts 'disappearing.'
I am using one view as the data source, and the data pulled in by this view is correct, so the problem is not the data source. My cascading prompt-

Level 1 - "Department"
Level 2 - "Unit"
Level 3 - "Type"
Level 4 - "Active Staff"
Level 5 - "Name"

I am allowing multiple choices on each level.
Once I make my 3rd level selection - "Type," level 4 & 5 are pulling data based on ONLY the 1st parameter value from the 3rd level, only.

For example, on the 3rd level, if I pull the types A, B, C & D, and on the 4th level, I select "true", the names that appear in the level 5 parameter value are the names from type A, and active only. Names from B, C and D do not appear as parameter values. (When looking at the raw data, there are names with types B, C, & D, who are active, and they should pull names into the 5th level parameter.)

I have already updated my registry keys -
HKEY_LOCAL_MACHINE>SOFTWARE>Business Objects>Suite 11.5>Crystal Reports>LOV- MaxRowsetValue = 15000
HKEY_CURRENT_USER>SOFTWARE>Business Objects>Suite 11.5>Crystal Reports>LOV- MaxRowsetValue = 15000
There are only 7300 possible names to choose from within my data source, so my registry keys are not the problem.

I am at a complete loss. Anything that will help provide insight would be great. Thank you.


 
With additional testing, I figured out that if I select multiple values from each level, the report will only print 335 records.
I am completely confused by this one.
Thanks
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top