Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 6693 Views
- Cap Gemini, HSBC, I also Faced
- E-Mail Answers
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 are burst options you have?
1. We have been asked to add summary information to sales reprasentatives performance report. The report needs to be grouped by country and city to compare performance between areas Also we need to include revenue totals for each city and each country.
how can you get the errors in job? when loops are araised we get error?
Suppose you run a report with empty data, how will you inform the end user that it has no data while running the report in report studio? Is it possible, if so how?
How to create a dynamic column name in Cognos?
6 Answers Aditya Birla, Polaris,
advantages of cascade prompt ???
how u will determine the performence tune will occur either in report or system
What are the advantages of using cognos sql?
what r the claims? how many type of claims we face from client side?
I need to display blue color for max Revenue and red color for min Revenue by using condition formatting how it possible........?
Define query studio?
What are the different type of securities can we apply in framework manager?
Teradata 
