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

What are slice and dice?

689


how you provide security to reports? How you provide security to packages ?

854


Define metrics studio?

769


Can you explain cognos planning?

855


describe the starschema grouping ?how can i add a new column for existing report ,when it is not present even in model & dataabase?

2078


Define catalog in cognos and write its various types?

838


hi all i am searching for cognos jobs pls inform about the jobs to:santosh.koora@gmail.com

2143


What is the difference between a data mart and a data warehouse?

757


How can you link a query to a data container manually in Report Studio?

2128


Can we create 2 conditions in report expression of a single data item..Eg: I added 2 new dataitems each one should show revenue for Q1 and Q2..Pls advice

2323


What are initial page components of Cognos connection?

791


How can we create a dynamic column name in cognos?

715


What are the different types of reports present in cognos?

755


tell me two or three issues from client side and how to solve those issues?

1925


i was asked what are the caluclations done by you in your report? plz give reply

1914