how to get the all values from a prompt using 'ALL' use and
display value in prompt
Answer Posted / venkatesh
In your value prompt add the static chioce as 'All'
and in filter put the expression as....
(column in (?Parameter1?)) or (?Parameter1?='All')
| Is This Answer Correct ? | 12 Yes | 1 No |
Post New Answer View All Answers
How can I schedule reports in cognos?
Can you define set to be cardinality?
What are the types of hierarchies?
What's the limitation of 'Page Footer' in Report Studio? e.g. If I have an activity prompt (list of activities in a Search & Select Prompt) and selected around 2500 activites from the 'Activity' Search & Select Prompt and when I ran the report I got a message "#! Overflow" in page footer. Can somebody please tell me what's max. limit. I tried with around 300 activities and page footer displayed the activities. Your help will be appriciated.
How to create model and how to test model?
Can you explain model durability?
hi frnds any body have cognos projects plz send me two(or)three projects to my mail adress ramureddy.reddy4@gmail.com.
Which studio is used to create reports?
What are various types of gateways in cognos?
What is the difference b/w macros and prompt?
What is the difference between Standard and Metrics folder?
Why need staging area database for dwh?
What is the importance of having monitor service in cognos?
How to a create header dynamically in a crosstab report in cognos 8.1?
what is the diff. between a link n a union? what is a custom view? what is the use of unlocking a report ? plz answer to these