Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2020 : Report Design
Message Icon Topic: Prompt Group case sensitive Post Reply Post New Topic
Author Message
Abhi
Newbie
Newbie


Joined: 23 Jul 2012
Online Status: Offline
Posts: 12
Quote Abhi Replybullet Topic: Prompt Group case sensitive
    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
IP IP Logged
Sastry
Moderator
Moderator
Avatar

Joined: 16 Jul 2012
Online Status: Offline
Posts: 537
Quote Sastry Replybullet 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
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.031 seconds.