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 |
what is prompt types of prompt example briefly each types of product (eg:values, date,search,prompt etc.)
What is the use of 'individual data source' option while using filter in query studio?
How to generate cubes in cognos?
What are the components of the report studio?
can we insert list report in corsstab report?
how you create security to cubes ?????
please please give me some banking calculations in framework manager.
What's the differance between each studio in cognos 8?
I have four region(Us, Uk, Canada, Europe) in my value prompt. Along with this I want new prompt called All. Once I click on All it should display all regions data. How can I achieve this ?
What are all the types of indexes in Cognos?
Why we should go for cognos? when there are so many other BI(Reporting) tolls in front of us?
what is the difference between java script and html in cognos?