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 the difference between native sql and cognos sql?

0 Answers  


If you have a report with list and cross tab in the same page. How do you restrict one user can see only the list and the other user can see both.

4 Answers   IBM,


How to create a completed dashboards in cognos report studio? and how to change the bar colours for differencet columns in bar charts?

4 Answers  


Hi I need real time senarios and how to explain project in the interview pls let me know my email id m.n.prathyusha@gmail.com.Please help me out with this

2 Answers  


Diff b/w surrogate Key and Primary Key?

2 Answers   Cap Gemini,


What is Index?

2 Answers  


write a query to display the departments with no employee?

0 Answers   HCL,


10. In Report studio ,how to get the top 20 employees in using list report Row number – if only list  Rank  Running-count

1 Answers   Data Semantics,


What is cognos connection?

0 Answers  


What is defined as Cognos Impromptu?

0 Answers  


What is the complex report you faced in real time?

0 Answers  


How you create IQD In ReportNet FrameWork?

3 Answers   IBM,


Categories