"Missing Parameter Values"

[Atronics]

A client needs 3 copies of a delivery docket and one copy of a picking slip to print, and does not want to use the Report Type grouping in sales orders, so I have added the DelDoc into three separate details sections of the picking slip. The report works and tests correctly in Crystal, but when run in Jiwa it returns "Missing Parameter Values" The report and sp are attached.

[Mike.Sheen]

1. Change the sub-report links for each sub-report to be using the @Pass_SP_InvoiceID as the container report field to link to, and have that link to the sub report field ?@SP_InvoiceHistoryID

SubreportLinks.png (21.34 KiB) Viewed 4004 times

2. Change the Record Selection formula for each sub-report to be (replace any existing content with the following):
//{@Pass_SP_InvoiceHistoryID}

You've got other problems with that report as you've put the subreports in the details sections - so in my testing I got 91 pages for a 15 line order because it repeats 3 subreports for each line of the order.

I believe you want those subreports to be in the a report footer section of their own. But, that's a different problem.

[Atronics]

Thanks, Mike.
I know about the other issues and just wanted to get the linking to work correctly.
Cheers
John I

[Atronics]

All works fine with the sub-reports in the footer. However, there is a trap for the unwary which Scott has previously discovered. The footer has a maximum page length which is quite a bit less than A4, which presents some limitations for the sub-report.