dynamic parameter not showing all possible values

[jwsobeck]

I am creating a report in Crystal XI. I've created a dynamic parameter, but when I add the parameter to the report and run it, the list of possible values is not complete. There should be roughly 10 distinct values in the list, but only 5 of them show up. It seems to stop alphabetically (it never makes it past the values that start at the letter P).

Any ideas on how to figure on why it's acting this way is appreciated

 

[lbass]

Is this a dynamic cascading parameter? The values in the higher order parameter will be limited to ensure that the total number of values at the lower level do not exceed 1000.

-LB

 

[jwsobeck]

No, it's just a regular cascading parameter, but I do have the intention of adding a cascading parameter later on.

What's strange is, I created a command using a solution from another post you created on this forum (select fieldname from table UNION select 'all' from table) so that I could have the "ALL" selection, and when I create a parameter from that command, the full list of distinct values is correctly displayed.

I would just use this command in lieu of the actual table, but I want to create a cascading parameter and I can't do that if I create separate commands for each field I want to use.

How is Crystal populating the dynamic parameter list? I would guess it's just a select distinct statement, and if I do that manually in my DB, I get the full list of 10 values.

 

[lbass]

I'm not sure why that would happen then.

-LB

 

[jwsobeck]

Hrm.

Is it possible to create cascading parameters using the command that I described above?

Thanks!