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
- 6717 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 |
How much time it will take to develop a report in real time? It depends upon the complexity of the report, so tell me the approximate time period for a simple list, cascading, master-detail, drill-through,..…etc?
What's the limitation of 'Page Footer' in Report Studio? e.g. If I have an activity prompt (list of activities in a Search & Select Prompt) and selected around 2500 activites from the 'Activity' Search & Select Prompt and when I ran the report I got a message "#! Overflow" in page footer. Can somebody please tell me what's max. limit. I tried with around 300 activities and page footer displayed the activities. Your help will be appriciated.
There are some reports,we have to provide security to that reports like the hr manager should have access to hr department reports only and the accountant should have access to accounts reports where as the CEO can have access to all the reports. How to deal with this situation using Cognos?
suppose i want to do drill through a column only for the values which is having more than > 50000. how can i do that?
In my Report C-id c-name Revenue are the query items I need to display the report has Alternative colors for rows and Revenue >=1000 has display in another color? i.e Both c-id,c-name are applying the alternative color(red,yellow) condition and revenue (blue) u think..How its possible? Iam doing for alternative colors i defined Two dataitems as running-count and Mod... and next in Boolean varaible define as [Query1].[Data Item2] = 1 or 0 and [Query1].[Revenue]>=1000 as like this (it's correct or not) and define in condition explorer yes and no purpose two colors(here how to define 4 revenue color) By selecting the list columns body style its applying only the Body and run report it working only for alternative colors Next i defined by using same Boolean condition for revenue like this. For selecting only the Revenue Body and define as yes 4 one color and no for another color? But here it the revenue column also applying only the alternative color condition and it's taking the >=1000 condition... So,i need to display 2 columns have alternative colors and 3rd column >=1000 cell have another color any body pls give me the replay/answer in step wise..... Thank u Basha
8. Can you use calculations in report headers and footers? How?
what are typees of dimensions
Hey Techies, Could you please tell me about query processing? and what is database only and what is Limited locale? brief plz..
How to hide/unhide the prompts which are not used by unauthorized users?
how u will determine the performence tune will occur either in report or system
What are the differences between Cognos 8 and Cognos 7.x version?
can anyone provide link to download cognos 7.2 version for download along wiht installation and configuration steps tx in advance
Teradata 
