Pass parameter to sub report

[Caddie]

Hi -

I have a report that has a subreport embeded in it. There is a work order field in the main report and in the sub report, so they are my master and child links. The main report list costs associated to work orders related to vender invoices, where as the subreport list costs associated to materials.

When you run a report you are asked to enter a work order # this parameter is passed to the main report and through the link is passed onto the child, however I have a problem.....some reports I run have do not have vendor invoice costs (no data in the main report) but they do have material costs (data in the subreport), so when I run my report it works perfect when there are both types of costs or if there is vendor invoice costs, but it does not work when there are only material costs (only data that would appear in the supreport.

How can I work around this?

Thanks!

 

[boblarson]

If you can have one or the other or both then your vendor invoice costs should not be a main report but instead it should be a subreport and the other one a subreport as well. The main report should only have the work order information and then link to both subreports.

 

[Caddie]

Fantastic idea...works perfect now.

Thanks!