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 are the differences between Cognos ReportNet 1.1, Cognos 8? and enhancements in cognos 8?

1 Answers   IBM, iFlex, TCS,


wt is the differnce between Block & conditional block ?

2 Answers  


How to create a Ratio in Cognos Report studio Reports?

1 Answers   IBM,


Cleared COG-112 with 100% score today. What next certification should i go for?

0 Answers   IBM,


what is the difference between list report and crosstab report?

0 Answers   IBM,






Can someone tell me whether we can apply filter on list of values in the 'Value Prompt'? e.g. I have a value prompt (named city) and the prompting is holding around 2000 cities but I want to apply filters on cities so users can select only 15 cities out of 2000 and then run the report. Users should be flexible enought to select any 15 cities from the list. Is it possible. Please advice!

5 Answers   DELL,


Can you explain new content durability?

0 Answers  


Why is auto-regression used in forecasting used on cognos platform?

0 Answers  


hi cognos Experts what are the enhancements in cognos 10 than cognos 8.4?Pls Ans Me........

1 Answers  


what is the difference between filter and condition?

0 Answers   IBM,


What is zero-foot print?

0 Answers  


What DB View and Bus View?

0 Answers  


Categories