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.
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.