Select and Search Prompt Issue

[mike.coleman407]

Hi Masters,

I have a report with one prompt, a select and search. The prompt is using a filter parameter setup like this - [Voucher Line (Posted)].[Projects].[Project ID] in ?Prmpt_Project?

When I query the prompt it pulls in all the correct "Project ID's", however, if I pull over one Project ID and run the report is pulling in ALL project ID's. Any thoughts?

Thanks for any advice.

MC

[MFGF]

Hi Masters,

I have a report with one prompt, a select and search. The prompt is using a filter parameter setup like this - [Voucher Line (Posted)].[Projects].[Project ID] in ?Prmpt_Project?

When I query the prompt it pulls in all the correct "Project ID's", however, if I pull over one Project ID and run the report is pulling in ALL project ID's. Any thoughts?

Thanks for any advice.

MC

Hi,

Which query is this filter defined in? Is it definitely in the query pulling data into the report container you are using (list/crosstab/chart etc)

MF.

[mike.coleman407]

How I envision it working is let's say I search for a project that contains "ABC". The prompt will return something like this:

01ABC01
01ABC01.00
01ABC01.00.0000
01ABC01.00.0000.00
01ABC01.00.0000.00.0
01ABC01.00.0000.00.0.00
01ABC01.00.0000.00.0.00.0000

The only data that I want to pull is the data on the last line with 7 segments like this one - "01ABC01.00.0000.00.0.00.0000"
There is no data on these other levels. Is there a way to do that?

Thanks