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

Answer / ben

Hi vij,

Thank you so much for your answer! It was just the thing I
was looking for!

Ben

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

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.

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 .

Answer / nimmi

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 :)

why we r using report studio in webbased only and fm windows based only

1 Answers  

advantages of detailed filter??? and summarized filter???

4 Answers   iFlex,

10. In Report studio ,how to get the top 20 employees in using list report Row number – if only list  Rank  Running-count

1 Answers   Data Semantics,

how to connect datamarts

0 Answers   HCL,

Can any one expalain the procedure for How to create a Mastr Detail Report in Cognos 8.3 ver?

1 Answers  

3.User1 doveloped some report,user2 modify the same report and user 3 also updates in that same report? how to identify that report will be modified or not?

1 Answers   IBM, Thomson Reuters,

suppose if u burst the reports if ur reports not reached to the destination how u will identify that one???

3 Answers   CTS, iFlex,

How do add dynamic titles in PP?

3 Answers  

Can we provide Package level security to two different groups i.e for finace and HR depts should access only their data??

2 Answers   Barclays,

in which scenario we go for views in cognos or oracle?

1 Answers  

if we have a value prompt in a prompt page and if we need to pass that prompt value to a sql used in report, what is the sql code? give me example?

3 Answers   ComNet,

How to create users and permissions in cognos?

4 Answers   IBM,