If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

How to filter the Filter Prompt?

Started by S_N_Solution, 07 Aug 2008 05:32:37 AM

Previous topic - Next topic

S_N_Solution

I want to Keep a filter in the report like:

[protocol_no]=?Protocol no?

But this list should contain only those protocol nos which is having status in 'Succeeded ' and 'Close' along with

When will i run the report Filter should contain only the protocol  which is having status in 'Succeeded ' and 'Close'.

Please Help me.........................

kvuppala

Create a query that has the filter on status to show only 'Succeeded' and 'Close'. Have the parameter point to this query and you should be fine.

Suraj

To explain above suggestion:
All you need to do is have a separate query for the prompt that gives protocol_no.
In that query add a filter such as:
[status] in ('Succeeded','Close').
that way, the values will be displayed only for those status.