Sub-Summary Page Break Not As Intended
I've tried looking around the forums for this problem before posting here. But didn't run across it.
I have a database of product codes with sizes and their prices and am trying to create nice price sheets. My problem is the report is breaking in the middle of the sizes for a particular product set.
Detail: I'm sorting the Sub-Summary by a sort category number. For example all of product A's has the sort ID #1, product B's has the sort ID #2.... and basically Product A has (quart, gallon, 5 gallon, drum and tote). Then Product B has (quart, gallon, 5 gallon, drum and tote)..... The page keeps breaking right in the middle of say the gallon and 5 gallon, putting the gallon on the bottom of page 1 and then starting page 2 at the top with 5 gallon. I'd like the parts NOT to break up a set of product sizes and am unable to get the system to do this.
Hope I explained this ok.
I uploaded a screen shot if that helps at all.