Try this:
1. Group by Lot No
2. Put Lot No, Shed, Avg GWT, and Net Gross Wt in the Lot No group header section.
3. Put Total Gwt and Total Bag in the details section.
4. Right-click in the grey area to the left of the group footer section and then click on "Section Expert".
5. You don't say which version of Crystal you're using, but find the options "Reset Page Number After" and "New Page After" and turn them on.
6. Click on the formula button to the right of "New Page After" and enter
"OnLastRecord" (without the quotes). This will suppress a blank page from appearing after the last group.
7. In the Section Expert, select the group header section. Turn on "Underlay following".
-Dell