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

can we insert list report in corsstab report?

1 Answers   JPMorgan Chase,


how to improve performance in report studio level

1 Answers   Wipro,


diff b/w layout calculation and query calculation

2 Answers   Cap Gemini,


Hi Buddies...i am lalitha. i am willing to appear for cognos bi-author certification. can anyone of you send me cognos dump. please please help me.

0 Answers  


how many types of variables in cognos report net and cognos 8

4 Answers   HCL, Merrill Lynch,


whis meant by Thumbnails on cagnos?

2 Answers  


What is the use of report studio?

0 Answers  


What is the basic relationship between measures and dimensions in transformer modelling

5 Answers  


What is Normalization?

3 Answers  


What do you understand by the term ‘frame manager' in cognos and write all the layers of the framework manager model?

0 Answers  


Hi,Can anyone tell me training centre for cognos in Mumbai?

4 Answers  


Why Star Schema is de-normalized? Please explain in detail probably with some examples.

2 Answers   DELL,


Categories