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
What are slice and dice?
how you provide security to reports? How you provide security to packages ?
Define metrics studio?
Can you explain cognos planning?
describe the starschema grouping ?how can i add a new column for existing report ,when it is not present even in model & dataabase?
Define catalog in cognos and write its various types?
hi all i am searching for cognos jobs pls inform about the jobs to:santosh.koora@gmail.com
What is the difference between a data mart and a data warehouse?
How can you link a query to a data container manually in Report Studio?
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
What are initial page components of Cognos connection?
How can we create a dynamic column name in cognos?
What are the different types of reports present in cognos?
tell me two or three issues from client side and how to solve those issues?
i was asked what are the caluclations done by you in your report? plz give reply