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

hi all i am searching for cognos jobs pls inform about the jobs to:santosh.koora@gmail.com

1962


Can you define materialized view?

608


Define query items?

589


2. We have asked to create a repots showing sales by region in order to determine which regions are generating the most revenue and highest sales volume. The report needs to include the revenue and quantitiy sold of each subcategory with in category.

1711


What is metric store database?

556






please please give me some banking calculations in framework manager.

1645


What are the methods by which it non-durable model could be changed into the durable model?

512


How do we convert from Numeric to be Words?

2495


Cognos Online Training will be provided. prior training with all real time aspects. Comprehensive training will be given in Datawarehousing concepts , cognos 8.4 and cognos 10 versions. Contact kris.cognos25@gmail.com

1615


Explain the difference between powerplay transformer and power play reports?

590


What are the types of studio present in Cognos?

609


what are the limitations of cognos reportnet? What are the enhancements in reportnet ?

609


How can reports be bursted based on two groups? I want to schedule to burst a report based on product line and years and I need the burst report for every product line and every year. How can this be done? Please help..

1550


What is the enterprise class platform architecture of cognos 8?

571


How do we drill through from a powerplay cube to reportnet?\

1879