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
- 3 Answers
- 7200 Views
- I also Faced
- E-Mail Answers
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 the components of the report studio?
What is Additive function?
Mention the difference between ‘macros’ and ‘prompt’?
what is the use of backward drilling in cognos 8?is it possible?whats the uws of it?
What project,model,parameter maps,namespace and database definitions....... what these are all contains? what are differences b/w them?
---------------Tell me about DWH Concepts?
What is Bitmap Index?
how the values be passed to prompts in report studio? when a data item is dragged n dropped in to report, after the default query generated first which sql will the query query hit for processing means (native or cognos)? plz answers to these questions?
what are the dimensions that you have in your current project?list them?
What are all the different types of prompt in cognos?
How to do Performence Tunning in Cognos Reports?
How to publish a package by running Java Script?
Define query items?
Explain what is the difference between native sql and cognos sql?
I have ten columns that needs to be totalled... but some columns are empty...how do i get sum all the columns even if sum are empty? Can i get a total of the rows instead of columns? if yes, what is the function to be used?
