I have a dynamic cascading prompt that uses a multi-union SQL statement to pull in Company, Call Type, Level, and Name. You can select one Company and one or more Call Types, Levels, and Names.
The cascading prompts work fine down to Level. When I select one level the Name prompt pulls in all appropriate names. However, if I select multiple or all levels the Name prompt pulls in only a few of the names. I've tested it in SQL Server and it works fine there so I've isolated it to a Crystal or Business View Manager problem.
Has anyone run across this before? Any ideas?
IP Logged
Never mind - I've discovered that it's the same problem I've had before - Crystal server is limiting the number of rows to just over 1,000 in the list of values (went into Business View Manager and estimated the number of rows by browsing the table). Therefore, I'm getting all of the values for the first three prompts but hitting the limit when I get to the last prompt.
