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.
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.
Thanks for your help!