Pass query results to reference reports

[sipjames]

I have a Sales Order-Work Order table, which like below

SO_Number        WO_Number    WO_Type

7001                  300001             A
7001                  300002             A
7001                  300003             B
7001                  300004             C

The Work order format was created by Cognos10 and each WO type will have a different work order report. So I have 3 different Cognos10 report which can print each type of the work order, every time when user try to run it, they will need to input the work order number.

I want to save some user time. I would like to create a new report and user only need to input the sales order. I have create a single report and using all the other 3 reports as report reference, but here come the issue. How can I pass the query result into different report reference?

Thank you very much for your advise.
James

[hespora]

To the best of my knowledge, this does not work with report references. Here's what I would do:

- combine the 3 different reports that print each type of work order. build them with parameters for wo_number (just like you have now) and wo_type (which actually selects which of the three outputs to print)
- in your sales order report, setup up drill thru definition on the wo_number column that links into the new report. setup the drill thru so that it passes wo_number and wo_type into the parameters you setup for those in the new report.