Print Page | Close Window

Prompt Group case sensitive

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Report Design
Forum Discription: The best way to design a report and problems you have encountered
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=19622
Printed Date: 28 Apr 2024 at 7:05pm


Topic: Prompt Group case sensitive
Posted By: Abhi
Subject: Prompt Group case sensitive
Date Posted: 09 Jun 2013 at 6:27am
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


Replies:
Posted By: Sastry
Date Posted: 10 Jun 2013 at 3:44am
Hi
 
Crystal LOV values are not case sensitive so, it is displaying only 'test' once.
 
Work around for this is create a serial number or if you have any unique ID (Eg: PART NO., ID,etc)  at database end and create dynamic paramert based on this unique number and insert your 'test' field in description.  Go in Prompt values and modify 'Prompt with Description only' as true
 
Now it will dsplay all your 'test' values
 
 


-------------
Thanks,
Sastry


Print Page | Close Window