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 ?
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 |
Why need staging area database for dwh?
I have ten columns that needs to be totalled... but some columns are empty...how do i get sum all the columns even if sum are empty? Can i get a total of the rows instead of columns? if yes, what is the function to be used?
1.how do nyou configure link between fwm and database (source).if you created fwm where it will be? and if you create reports where it is stored? 2.what is spic shot in fwm?
Can you define materialized view?
What are the types of folder present in cognos?
What are query items?
Can we create reports using OLTP database?How?
When we save a report in report studio with what extn it save?
How can we give the same color for alternate(1,3,5.... and 2,4,8...) cells in a column?
what are the difficult problem are you involved in cognos report net and 8 and impromptu if any pls share with us
Hi.. friends, dis Bhaskar p.if any of u having realtime scenerios.. plz send to me.. my mailid s bhaskarparitala.rao@gmail.com send ASAP.. waiting for reply..
-----------------What is Direct and Conventional loading?