Hey all! I’m building a new version of the Batch Packing Slip report, and in order to make it do what I need, I need to add the SOOrder, SOLine and SOLineSplit tables. However- once I added them, it caused the report to loop line items thousands upon thousands of times.
How do I fix this? I’ve attached the report.
Best answer by BenjaminCrisman
For this issue I would add a subreport and set a collection parameter called ShipmentNbr and use SOShipment.ShipmentNbr as the value:
Create a new report and add the SOShipLineSplit table in there, set a parameter for shipment number and a filter condition where SOShipLineSplit.ShipmentNbr = @ShipmentNbr
Then put your fields into the Details or groupFooter section and update the main report with the name you’ve given the subreport:
You can then remove the SOShipLineSplit fields from the section they print in and it should work as expected
+4Hi
In the subreport use the SOShipLineSplit and send the Order Type and Order Number as collection parameters.
Then in the subreport either in the Details section or a groupfooter section add the SOShipLineSplit fields
Hi
In the subreport use the SOShipLineSplit and send the Order Type and Order Number as collection parameters.
Then in the subreport either in the Details section or a groupfooter section add the SOShipLineSplit fields
There’s no way to join these tables? I don’t understand why that would be.
+4For this issue I would add a subreport and set a collection parameter called ShipmentNbr and use SOShipment.ShipmentNbr as the value:
Create a new report and add the SOShipLineSplit table in there, set a parameter for shipment number and a filter condition where SOShipLineSplit.ShipmentNbr = @ShipmentNbr
Then put your fields into the Details or groupFooter section and update the main report with the name you’ve given the subreport:
You can then remove the SOShipLineSplit fields from the section they print in and it should work as expected
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.