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?
- 1 Answers
- 6329 Views
- Cap Gemini, HSBC, I also Faced
- E-Mail Answers
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
What are the types of hierarchies?
What do you understand by the term 'aggregate cache'?
What is the difference between a cascading report and drill through the report?
Can you define cube?
WHAT ARE THE DISTNICT VARIABLES?
What is the difference between a cascading report and drill through report?
hi i need to rename a file in cognos8? can anyone help me out how 2 do it? pls suggest some solution such as using a batch file or using a procedure node or anything to rename the file
What project,model,parameter maps,namespace and database definitions....... what these are all contains? what are differences b/w them?
What is the difference between Open Connection command ang Open Session Command?
Can we create 2 conditions in report expression of a single data item..Eg: I added 2 new dataitems each one should show revenue for Q1 and Q2..Pls advice
Tell me about Dnamic and Static Dashboards?
Looking for IBM COGNOS Certification C1000-065 , C2020-605 , C2090-621 , C2090-623 Dumps?
What is the diff between cognos 8.1 & cognos 8.2 & cognos 8.3? Measn whet are the enhancements are added in new versions(8.2& 8.3)?
please can you give me some banking domine calculations developed in framework manager plzzzzz thank you.
What is defined as Query studio?
