Hi All,
Can any help me out what are the steps to follow to make the Static Choices work the way I want.
The way I want is I have Four Prompts out of which two Prompts has values like Abbreviations or Codes (which come form DB like that) and I have a req. of Displaying the Detailed expansion of those Codes.
Well I did some research and am able to do ...but when I'm using these Static Choices Property for those Prompts, I see both the Codes as well as the Detailed Expansion of those Codes.
Can any 1 help how to hide the values comming from Database and just display what I want.
Eg., Prompt1: Country Code
IN - Value from DB
Display - India
USA - Value from DB
Display - America
EUR - Value from DB
Display - Europe
Values Before using Static Choices IN
Ã, Ã, Ã, Ã, Ã, Ã, Ã, Ã, USA
Ã, Ã, Ã, Ã, Ã, Ã, Ã, Ã, EUR
Ã, Ã, Ã, Ã, Ã, Ã, Ã, Ã, ....
(In my case)
Values After Using Static Choices India
Ã, Ã, Ã, Ã, Ã, Ã, Ã, Ã, America
Ã, Ã, Ã, Ã, Ã, Ã, Ã, Ã, Europe
Ã, Ã, Ã, Ã, Ã, Ã, Ã, Ã, ....
Ã, Ã, Ã, Ã, Ã, Ã, Ã, Ã, INÃ, Ã, Ã, Ã, Ã, Ã, Ã, Ã, Ã, Ã, Ã, Ã, Ã, Ã, Ã, Ã, (I don't need this)
Ã, Ã, Ã, Ã, Ã, Ã, Ã, Ã, USAÃ, Ã, Ã, Ã, Ã, Ã, Ã, Ã, Ã, Ã, Ã, Ã, Ã, Ã, Ã, Ã, Ã, Ã, Ã, Ã, ''
Ã, Ã, Ã, Ã, Ã, Ã, Ã, Ã, EURÃ, Ã, Ã, Ã, Ã, Ã, Ã, Ã, Ã, Ã, Ã, Ã, Ã, Ã, Ã, Ã, Ã, Ã, Ã, Ã, ''
Ã, Ã, Ã, Ã, Ã, Ã, Ã, Ã, ....
This is just for 1 Prompt
Edit the field to something like:
CASE WHEN
(CountryCode='USA') THEN 'America'
(CountryCode='EUR') THEN 'Europe'
...more here
END
where, I need to write this code (for the Prompt Value or...somewhere else)
...first of all after writing this code do I still need to use static choices or not
Well I tried various options am trying to figure out the steps
I'm sorry if I'm being pushy
Thanks
S
I think I figured out what is the problem
Well in the Value Prompt Properties under Data I had to clear Use Value property that was the reason for the values (I mean the codes/Abbreviations) to display again in the Prompt (DropDown)
Well we can close this Issue.
Thanks a lot to you all
S