Say a client wants to add lot # to shipment report (SO64200 is the report name). Therefore, you add the table SOShipLineSplit table to the report, add additional detail band and display lot #. The report will look like the following example: Batch# (lot#)
But say the client doesn’t like the layout it currently producing of the batch #. It’s wasting space for the same items with the same information. Example TESTPROD02, it’s repeating 3 of the same lines in Line #1 and #2. To enhance the above report, you would need to modify the report and replace the detail bands with group bands. The final will display the report as below as 4 lines instead of 6 lines as above.