Interested to Buy Any Domain ? << Click Here >> for more details...
i have 4 countries in my database as USA, UK, INDIA, CHANA.
In value prompt's 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?
- 4 Answers
- 10040 Views
- Tech Mahindra, I also Faced
- E-Mail Answers
Answer Posted / itesh
simple man ,
create country prompt with 2 dynamic prompt value dispay
value WESTERN_COUNTRIES>use vale (1)ASIAN_COUNTRIES (2)
in report query put filter
write a if statement
if (?country?)=1
then country in (USA,UK)
else country in (INDIA, CHINA)
cheers
| Is This Answer Correct ? | 9 Yes | 3 No |
Post New Answer View All Answers
New coloums are added in database, then how you know in report level
What are the components used in web tier?
What are the themes in a data warehouse?
What is called Cognos powerplay?
What junk dimension contains?
What is called cognos reporting tool?
What is meant by junk dimension?
Can you define materialized view?
How do we convert from Numeric to be Words?
What is the diff between the following Report output-- HTML O/P, PDF O/P, EXCEL 2000 and EXCEL 2003 of report outputs? Listout main differences?
What DB View and Bus View?
How can you link a query to a data container manually in Report Studio?
What are the steps to import the two data sources in framework manager?
Define query studio?
What is the difference between a cascading report and drill through report?
