Crystal gurus - need help with formula
Working on a modified Picking Sheet form to generate labels instead of an actual picking sheet.
Each set of regular items above a comment line on the orders represents a group of items that will be processed together.
An order might look like this:
Line 1 Item A
Line 2 Item B
Line 3 - /C - Items A & B are shipped assembled
Line 4 Item C
Line 5 Item D
Line 6 - /C Items C & D are shipped assembled.
The goal is to get 2 labels, based on the above sample.
What I'm working on is page-breaking (to print the next label) when a Comment line (line type 4) is encountered. So far, I have it working, but I'm getting a 3rd, extra ""label"", with no detail info.
""New Page After"" formula: {SO_PickingSheetWrk.ItemType} <> ""1""
I'm looking to add to the formula the logic for ""if there are no more detail lines, don't print any more labels"".
Is this doable, and if so, how do I modify my formula logic?
Or, do I need to back to the drawing board?
TIA!