how to get the all values from a prompt using 'ALL' use and
display value in prompt

Answers were Sorted based on User's Feedback



how to get the all values from a prompt using 'ALL' use and display value in prompt..

Answer / 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

how to get the all values from a prompt using 'ALL' use and display value in prompt..

Answer / ganga

?Parameter?='ALL' then pass the static choices:Use
value='ALL'
Display Value:'ALL'

or

<script>
listboxBox1.selectAll();
</script>

Is This Answer Correct ?    4 Yes 0 No

how to get the all values from a prompt using 'ALL' use and display value in prompt..

Answer / murthy

for ex: i want display all emps in valueprompt.
drag value prompt on tool box select parameter 1 finish
use value ename from emp, finish then run the report
value prompt display all enames ,u have one emp ename that
data will be displayed...........

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Cognos Interview Questions

i have a sales project interviewe asked tel me the how many facts&dimensions used in ur project.

2 Answers   IBM,


How to hide/unhide the prompts which are not used by unauthorized users?

3 Answers  


What do you understand by the term 'dynamic cube'?

0 Answers  


What is the difference between set functions and filter function in dimensional data?

0 Answers  


2. What functional area you worked on.

0 Answers   IBM,






How can I change reports to another package???

3 Answers   IBM,


What is meant by Reportstudio shortcut?

0 Answers  


hi, i am Having 2 Reports one list report,one crosstab report if i put 2 querys for 2 reports which query will execute first?if i put same query for both 2 which report i will Get?pls pls pls Explain me...

1 Answers   IBM,


1.How can we driil through from a page report having query1 to list report having Query2 in master detail relationship n Drill through? 2.In database i have 50 records but when it is displayed on the report i'm getting 100 record with duplictes.How can we solve this to eliminate duplicates? 3.Exact Diff B/W Filter n Condition? 4.Render Variable? 5.I have leftouter join when right table does not have any matched records with left table what will be the output of the report whether it will be dispalying Null or blank in that particular row? 6.How to test the reports i.e Unit Testing? 7.How canwe drill through when there is no common column between the parent n child report? 8.How can we do performance tuning? I kindly request all the experts to give reply with correct answers and if possible send me some examples regarding that at srini.madhala@gmail.com

1 Answers   IBM,


..Architectural difference between cognos reportnet and cognos8?

3 Answers  


how many facts&dimensions tables in project? it's very urgent.........

2 Answers  


what is loop in frameworkmanager ?

4 Answers   Texas,


Categories