Problem about value prompt in report studio

I have 4 countries in my database as USA, UK, INDIA, CHANA. In value prompts prompt control list, i want WESTERN_COUNTRIES, ASIAN_COUNTRIES instead of those country names. When i click on WESTERN_COUNTRIES, it should retrieve USA, UK records and when i click on ASIAN_COUNTRIES, it should retrieve INDIA, CHINA records.
How is it possible,,,pls tell me

Questions by kranthi.kunta   answers by kranthi.kunta

Showing Answers 1 - 1 of 1 Answers

Khushboo Kapadia

  • Jun 12th, 2008
 

From Query Explorer, open up the query for which the filters should be applied on.

2) Drag a Filter object from the Toolbox tab to the Detail Filters pane.

3) In the Expression Definition, enter the following including the #s

#prompt ('<prompt parameter>', 'token', '<default filter>')#

example: #prompt ('Countries', 'token', '[Country] IN ('INDIA','CHINA')#

4) Add a Value Prompt to the report .

5) Select the Value Prompt and in its Properties in the bottom right corner, go to the Static Choices property.

5) For each possible filter that needs to be applied, add a new Static Choice.  Make the Use the expression of the filter that you should be applied and the Display is what is shown to users in the prompt's drop down list.:

Use: <filter expression>
Display: <what is displayed to users>

Example :
Use: [Country] IN ('INDIA','CHINA')
Display: Eastern Countries

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions