Multiple Queries In 1 List Report? Is there a 'Where' clause in Cognos?

[Pavlo01]

Hello Pro's,

I am trying to create a summary level list report that will have drill through definitions to more detailed reports.
I am not sure how to incorporate multiple queries in 1 list report. Each detailed report requires different filters and I want to incorporate these into 1 summary level report.
For example I have detailed reports such as 'Orders Due To Ship In The Next Week' and 'Drawings Due In The Next 7 Days' by Project Manager.
I want to create a summary report that will provide a count of each of those queries.
Ex.
Project Manager | Orders Due To Ship In The Next Week | Drawings Due In The Next 7 Days
Bob                       5                                                              8

The 'Orders Due To Ship In The Next Week' column requires a filter on an item query 'ShipDate' and  'Drawings Due In The Next 7 Days' requires a filter on 'DueDate'

When I add a filter it applied to both columns when I need 1 filter for one column and another filter for the other column.
I tried inserting a calculated expression as a column using a 'Where' but I dont know if this is possible in Cognos.

Any help would be much appreciated.
Thanks In advance.

[MFGF]

Hi,

Assuming this report is built over a relational package, it looks like you will need two queries, each with a separate filter. These can then be joined using a join object in Query Explorer (on Project Manager by the looks of things) and the results then directed into a third query. Your list would be based off this third query.

Cheers!

MF.

[Pavlo01]

Thanks for your help!