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


Please Help Members By Posting Answers For Below Questions

What is the difference between the content store and content manager?

574


How to create a cube in Transformer? What is the process? Please mention process thank u

1336


2. What functional area you worked on.

1915


can anybody explain me about sales project in cognos..wt is the requirement,how u get the requirement..explain me any one based on ur experience as a report developer..how much time u will take to complete one project,single person in a team have to do how many reports..in a real time how much time will take to complete reports ie..one single report.. (simple and complex report)and in real time ur project contains how many fact tables and dimension tables..how many query subjects and query items..wt functional area u worked on.. hope u vl respond as soon as possible ..my mail- id is ammu2india@gmail.com

1717


Can you define set to be cardinality?

591






What is dtm?

719


Explain what is the difference between microstrategy and cognos reporting tool?

545


I have a reports on cognos ep7series version3 with database SQl2000.Now i am migrating database SQL2000 to SQL2005.Then What happens to cognos reports and also there is reports cubes then how can i handle this problem please give me step by step solution b'coz i am new to cognos ep7series

1718


What is cognos reporting tool?

617


What is the model filter?

600


What is a dimension?

635


What is the size of database for you project?

1113


can we insert all types of charts in a list report? what r the realtime prompts?

1673


How to publish a package by running Java Script?

1604


What is set to be Cognos configuration?

607