2 Replies Latest reply on Jul 17, 2009 6:50 AM by BonnieL

    Page breaks on group change

    BonnieL

      Title

      Page breaks on group change

      Post

      I'm doing labels -- 6 to a page/sheet (2 across, 3 down).  Each record is in a OrderGroup of which there can be several for the whole table, which by the way, is a SQL table that is a shadow table.  I've sorted my records on the OrderGroup field.  I need it to start a new page/sheet when the OrderGroup changes.  I also need to print a "header" label for the new group with the OrderGroup number on it along with various other information from the next record.  I looked at all the things I can find and it seems that I need a subsummary report.  I'm not summarizing anything though, just the page/sheet break.   I've tried inserting the subsummary with the OrderGroup as the group field to break on.  That presented a couple problems.

         1. It just plain didn't start a new page at the beginning of the group.

         2. If I made the subsummary section big enough(the size of my label) to put all the information I needed on it, I ended up with only 4 labels on a page rather than the 6 but I never did get my "subsummary" report.

         3. If I made it real small and put no information in it, it still did not break.

         4. I've also tried putting the some of the needed info in the header section which gets the info on each sheet of labels but doesn't break on the group. 

         5. Thinking the problem may be that I'm using a SQL shadow table, I imported the information into FM.  No difference.

       

      What is really strange is that I did another layout in another app using a different label type and it worked.  I followed the same instructions for inserting the subsummary section, didn't put any info into the section and my data was physically inside FM, not  a shadow table.

       

      Any suggestions?

       

      Bonnie Litts

        • 1. Re: Page breaks on group change
          etripoli
             You're correct, you need a subsummary.  And it needs to be based on the OrderGroup.  But, the subsummary part needs to be small, 1-2 pixels, so that it doesn't interfere with the printing of the labels.  And make sure the 'Page break before each occurrence' is checked.  If you want the header to appear on each sheet printed, place the appropriate fields in the header part. 
          • 2. Re: Page breaks on group change
            BonnieL
              

            Looks like I finally got it to work. I did have to import my break

            field and another field into FMP and set up a relationship with my

            shadow SQL table. I also had to remember to sort my imported field even

            though it was already sorted in the SQL table.

             

            Thanks for your help. 

             

            Bonnie