I have a value prompt in my prompt page.Now if I set the
filter to required then I have to select a value from the
list and I will get the respective data in the report
page.But If I select nothing then I will get the complete
data in the report page.
I want that if I select nothing from the prompt list then
nothing is displayed in my report page.
How should I do this?



I have a value prompt in my prompt page.Now if I set the filter to required then I have to select ..

Answer / naresh

For this , you have to make static prompt values.

while making static prompt values create one empty value this will gives no data when you run the report with no value.

----------------------------------
But generally ,

If you are making filter is required , while running it won't highlight the Finish button if you are not selecting value,so without selecting values you cannot run the report.

If you are making filter is Optional means it will consider no prompt/filter if no value selected from prompt, it will allow to run the report.

So based on above two cases , second case is not preferable to run the report.

Is This Answer Correct ?    11 Yes 2 No

Post New Answer

More Cognos Interview Questions

2. What is With Clause In Cognos?

2 Answers   Wipro,


what are determinants?

4 Answers   College School Exams Tests, IBM,


What is difference between content store and content manager?

0 Answers  


What is the difference between cognos 8.2 and cognos 8.3?

5 Answers  


How can I change reports to another package???

3 Answers   IBM,






how many types of keys are there i.e primary key and foreign key etc..?

3 Answers   IBM,


what is your project workflow and your role in the project?

5 Answers   Syntel,


Name the types of gateway?

0 Answers  


what is conditional query subject and example

2 Answers   TCS,


give me scenario on cascading prompts&master-detail relation

4 Answers   IBM,


What is the use of powerplay web viewer in cognos?

0 Answers  


How to improve the performance of the report at the report level?

3 Answers  


Categories