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

Can you define dimension?

0 Answers  


1. Can we import the cube into FWM? If yes how & what is the necessity to import it? 2. What is the use of TABULAR OBJECTS? Repeated Question

2 Answers  


If anyone has COG-185 IBM Cognos 8 Migration Professional Certification Dump, please mail me at: sushma_biswas@yahoo.com

1 Answers   EDS,


Which one is better among Value and select & search prompts,in terms of performance?

2 Answers   L&T,


A list box contains 1000 records, while running the list, inside the header the content has to scroll down. Note the header should not go up?

1 Answers  






Explain the difference between native sql and cognos sql?

0 Answers  


How can we do the unit testing?

3 Answers   Logica CMG,


Can you define confirmed dimension?

0 Answers  


what are versions of cognos from starting release to latest in the market?

4 Answers   IBM,


What is cognos powerhouse?

0 Answers  


Why are meta service important then other services?

0 Answers  


what is field set? what is the query calculation and layout calculation?

2 Answers   Syntel,


Categories