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

what is dynamic sort?

1 Answers   Infosys,


What is Local Cache and how does it help in performance tuning

1 Answers  


what is the difference between enterprise data warehouse and data warehouse

4 Answers  


hi..i'm searching on cognos.i want to know some real time explanation..persons who have real time exp and who r searching in this field..can u send ur mail-id..my mail-id is dhaanuus@gmail.com..hope u will respond as soon as possible..

0 Answers  


What is meant by grouped star schema

0 Answers   IBM,






1. Differences between Merge and Union In Cognos?

0 Answers   Wipro,


What is the difference between Open Connection command ang Open Session Command?

0 Answers  


What is Normalization?

3 Answers  


In my report i want display sales rep name, country ,city how to achieve this by using repeater table

0 Answers   IBM,


How can I schedule reports in cognos?

0 Answers  


what is power prompt in cognos ep7series?what is the use of this?

0 Answers   HCL,


If you need latest cognos certification dumps to get certified in first attempt with 100% score, please e-mail to getmecert@yahoo.com

4 Answers  


Categories