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
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.