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.........................
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.
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.