Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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


Please Help Members By Posting Answers For Below Questions

How can I schedule reports in cognos?

1060


Can you define set to be cardinality?

1061


What are the types of hierarchies?

1073


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.

2583


How to create model and how to test model?

1073


Can you explain model durability?

1114


hi frnds any body have cognos projects plz send me two(or)three projects to my mail adress ramureddy.reddy4@gmail.com.

2042


Which studio is used to create reports?

1155


What are various types of gateways in cognos?

1131


What is the difference b/w macros and prompt?

1220


What is the difference between Standard and Metrics folder?

1126


Why need staging area database for dwh?

1120


What is the importance of having monitor service in cognos?

1096


How to a create header dynamically in a crosstab report in cognos 8.1?

2483


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

2062