Main report and two sub-reports... Main Report prompts for OrderDet.OrderNo, the Quote Costs sub-report prompt for OrderDet. JobNo and the Job Matl sub-report prompts for POReleases.JobNo.
OrderNo example: 110954
JobNo example: 110954-01
The -01 signifies the top level assembly JobNo to which WIP activity and costs are rolled up.
I'd prefer to enter a single OrderNo parameter but could live with entering the OrderNo and a single JobNo passed to both subreports; but would like to avoid entering 3 parameters.
The JobNo will always end with -01
Is it possible to prompt only for the OrderNo and pass that parameter to the two subreport parameters and add the -01 suffix to them?
You could create a formula that adds the -01 to the orderno parameter and link that to the parameters in the subreports.