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 / 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 |
Hi, I am Searching on Cognos 10, If any experienced person can send out a project or explain a realtime scenario that would be very helpful for me. Please be kind towards me and help me in this regard. I am really finding difficult to find a person who can guide me in this feild. Your help will be highly appriciated. My email id is asimcognos10@gmail.com. Hope you will help....
what is a Galaxy Schema?
what is the difference between enterprise data warehouse and data warehouse
what are the types of facts ? explain them?
2 Answers Business Objects, Informatica, Syntel, Teradata,
hi, i am Having 2 Reports one list report,one crosstab report if i put 2 querys for 2 reports which query will execute first?if i put same query for both 2 which report i will Get?pls pls pls Explain me...
Hi Experts, Can a single package be shared by multiple users?
In my report i want display sales rep name, country ,city how to achieve this by using repeater table
what r the names of the reports that u prepared???
9 Answers Covansys, IBM, Wipro,
Mention the difference between ‘macros’ and ‘prompt’?
how to test reports in cognos?
Hi is any one having link to download books on datawarehouse tool kit by ralph kimball or any other authors books.
How can we do the unit testing?