Passing Values from Value promt to multiple queries

[Maverick111]

Hi,

I am new to Cognos and looking for help in building a report in report studio.

I have three Queries which has multiple columns and among them there is one common column in all the three, that common column is the Project Name. I was able to Join all these three queries and arrange the data in a single final query.

In the page explorer I am want to create a value prompt for Project name and pass the user selected value to all my three queries in the backend.

Can someone help me in doing this!!!  :)

Thanks in Advance.

Regards,
Prasad

[HalfBloodPrince]

simply put a filter in all the quries set usage as opional or in the final query  :o :o

[Maverick111]

Thank you  :). It worked.