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
- 10210 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
Helow, i have a problem with runing-total function when i use it for a calculate row (for example : i need to diplay a running-total of total units ?)
actually 2 members working in same module.at a time is possible to work on same module? i add some tables,another person also add some tables how the synchronization betn the two in same module? pls ans me and expain to me.....
What DB View and Bus View?
Can you explain model durability?
What is the difference between the standard and metrics folder?
I have created a database "TestingDB" in MS SQL Server 2005. I have set the port properties and the Cognos Service is up. But I don't see anything in the Cognos. In the administration i have set the ODBC connection and it tested successfully.If i copy the samples to the appropriate directory then i can see the samples.But I don't know how to do the same thing with my own database "TestingDB". As i have configure the cognos in my company which is having a database (very near to production database).I am a novice in cognos. Please help me out.
how can we Upgrad the reports from version Impromptu 6.0 to 7.0 and Power Play from version 6.6 to 7.0 ?
WHAT IS METRIC STUDIO?WHAT IS SCORE CARDS HOW TO IMPLEMENT IT AND WHAT IS THE USE OF SCORE CARD?
What are the components of the report studio?
What are all the advantages of Cognos?
What are cognos connection initial page components?
what are the special features in cognos reportnet?
What do you understand by the term 'model durability'?
What are all the types of indexes in Cognos?
Explain the characteristics of cognos?
