Hi everyone,
I have a crystal report which has a dynamic prompt. The prompt values are populated based on a db field.
This Db field contains values such as "test","Test","TesT", "TEst"...etc.
Now while prompting, the prompt selection drop down lists only one "test" out of the four. But the client needs all the four values to show up in the prompt selection. Is there any way to achieve this.
I have tried the option "Database server is case-insensitive", but this option is no way affecting the prompt list generation.

Thanks in advance