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?
Answer Posted / 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 View All Answers
Explain about scorecarding?
What do you understand by the term 'model durability'?
WHAT ARE THE DISTNICT VARIABLES?
9. What was the most complex type of report you dealt with?
please can you give me some banking domine calculations developed in framework manager plzzzzz thank you.
what is a prompt value in report studio and variables ?
-------------What is Coditional Prompting?
----------------------What are the User Securities?
How to apply securities for reports in cognos connection?
What do you understand by the term 'aggregate advisor?'
What are the roles defined by cognos platform?
What is the use of cognos decision stream?
can anyone let me know some tips or interview questions on framework manager metadata modeling, creating joins, and all other aspects related to Cognos 8 framework mgr
my table having data like this year month revenue 2011 jan 100 2011 feb 200 2011 mar 150 like this i want My report 2011 jan 100 2011 feb 100+200=300 2011 mar 300+150=450 like this for this where we specify the condition how will specify? pls ans me pls...
What are the advantages of cognos?