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

what are the applications of the tabular model ????

5 Answers   iFlex, iGate,

what is the difference between querystudio in reportnet and cognos8

0 Answers   CTS,

What is the difference between Conditional Layout and Conditional Block

1 Answers   TCS,

What is cognos connection?

0 Answers  

My problem is as follows I made two pages of the portal; in the first page i have two reports and from one of these i would like to communicate in some way (i.e drill- through?) with the second page that contains four reports (prompt value [product] and three chart [sales revenue, sales quantity and budget]). Particularly I would like to communicate with the report that contains the prompt, passing the Product. How can i drill from the first page of the portal to the second page ? More generally, is it possible to move from one page, containing 2 report, to another page with 4 report, through a drill-through or any other mechanism? Thank in advance.

1 Answers  

What are links & Segments in Cognos Framework Manager?

1 Answers   Systime,

can we put more measure on cross tab? If so how many? How this affect the aggregation?

4 Answers  

what r the reports u faced critical and how it can be solved .. any once can u give a best ans for interviw

0 Answers   IBM,

what is the difference between a data item and a query item?

2 Answers   Bodhtree, HP,

Define the cognos reporting tool?

0 Answers  

what is a box type in cognos? what is a stitch query? what are the services that run in background when cognos is running

2 Answers   IBM,

3. Differences between Cognos Sql & Native Sql? What are their Advantages and Disadvantages?

3 Answers   CTD, Wipro,