Interested to Buy Any Domain ? << Click Here >> for more details...
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 ?
- 6 Answers
- 9221 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / cognosvij
Hi Sriprabhath,
In your value prompt add the static chioce as 'All'
and in filter put the expression as....
(region column in (?Parameter1?)) or (?Parameter1?='All')
hope this may help u :)
vij
| Is This Answer Correct ? | 14 Yes | 0 No |
Answer / ben
Hi vij,
Thank you so much for your answer! It was just the thing I
was looking for!
Ben
| Is This Answer Correct ? | 2 Yes | 0 No |
Answer / manish
You can also use page render with page1 with the region
filter and page2 with no filters.
Depending on the selection All the page2 will be displayed
else page 1 will be displayed with the filter
| Is This Answer Correct ? | 2 Yes | 1 No |
Answer / sriprabhath
Hi Nimmi,
Thank you for reply. I got u r answer making the prompt 'Optional'. But My requirement is that I want new prompt to be displayed in the value prompt called 'All' along with existing region prompts.
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / jaya
Go to the Query Explorer and click on the value prompt
expression and type 'in' in the place of '=' . When u run
the report , you will get the option 'show all' . let me
know when it works .
| Is This Answer Correct ? | 0 Yes | 5 No |
Hi,
This is very simple to achieve.you can make your first
prompt an optional one. so if the user selects no options
in the dropw down then all the regions data is displayed .
if any region is selected then that regions data is
displayed.
hope this helps you..
cheers :)
| Is This Answer Correct ? | 0 Yes | 7 No |
Can you define snapshot?
Main Differnce between Cognos7 and Cognos8
what are the special features in cognos reportnet?
A report is scheduled at 2am in the night... and the report contains 4 value prompts how it is going to be executed without selecting the values....if executed who is going to select the values from the value prompt
how u migrate the reports from impromptu to reportnet???
What is catalog and types of catalogs in cagonos and which is better?
What is a query set?
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?
How do you schedule process automatically in cognos.I.e we have 50 reports and 100 users that will schedule daily, weekly, and monthly basis? Pls, give the answers the query early on.
9. What was the most complex type of report you dealt with?
What is the usage propertys in Framework Manager?n Ie we set EMP ID as a Fact and what will happen?Actullay EMPID is a Identifier....
please tell me architecture of the cognos8?
Teradata 
