4 Replies Latest reply on Aug 15, 2014 8:28 AM by Jason_Farnsworth

    Reports

    Jason_Farnsworth

      Reporting,

       

      I need to make a report that has a Seperate Title Header page for each contractor then uses the body from that contractor when sorted. Additionally it would also be great is a closing letter page that prints on each occurance as well.

       

      Title Header (Cover Letter)

      Sub-Summary (Sorted of Contractor)

      Body (List of Items relative)

      Footer

      Title Footer

       

      This is what I have at the moment but I only get one cover page for all sorted bodies.

       

      Questions:

       

      Is it possible to have a seperate Cover Letter for each Body occurance?

      Is it possible to also have a seperate closing letter for each Body occurance?

       

      If it is what am I missing?

       

      Thanks in advance,

       

      Jason Farnsworth

      Odessa, TX

        • 1. Re: Reports
          AlanStirling

          Hi Jason

           

          This is very difficult to troubleshoot from a distance, but I have just one suggestion for you.

           

          Change the Title Header to a normal Header and ensure that the sub-summary on change in Contractor has the checkbox set: 'Start new page on change of contractor' or words to this effect.

           

          This should print your Cover Letter for each Contractor.

           

          Best wishes - Alan Stirling, London UK.

           

           

          Alan Stirling Technology Ltd, 135 Lisson Grove, London NW1 6UP

          +44 (0) 20 7724 2456 - alan@ast.fm - www.ast.fm.

          FileMaker Certified Developer for versions; 7 8 9 10 11 12 13.

          • 2. Re: Reports
            Jason_Farnsworth

            Thank you Alan for your time

             

            I am not sure I a see the forest because I have all these trees in the way!

             

            I will try and make things more clear

             

            I have a sort table that I am sort with using Sub Summary (by contractor) to break out my different groups of information (Body). This works great I can get it to break a new page for each group. Now what I would like for each group is a separate cover letter that addresses that group individually along with a closing page that again handles that contractor uniquely.

             

            So for each Body separates (1) Cover Letter, Body (multiple components), (1) Closing Letter

             

            There could be (30 - 50) different contractors at a time with (10 - 15) body components each.

             

            I hope I have given you enough to go on

             

            Best regards,

             

            Jason Farnsworth

            Odessa, Tx

            • 3. Re: Reports
              AlanStirling

              Hi Jason

               

              So as far as I can see, you are halfway there - since you have each contractors report starting at the top of the next page.

               

              I now realise that there was a flaw in my initial advice!

               

              So, make the Sub-summary by contractor, deep enough to almost fill the page, and copy the contents of your Title Header (the cover page) into it.

               

              Now remove the Title Header.

               

              Now on a change in Contractor, you should see your one page cover letter printed first, followed by the list of body component items on the next page.

               

              You may have trouble getting column headings to appear at the top of the second page, since you will have used the Sub-Summary on the previous page (and I have a feeling that you can't get the Sub-Summary to be longer than a page).

               

              Try it and see - one of the most famous FileMaker adages.

               

              Hope this helps ...

               

              Best wishes - Alan Stirling, London UK.

               

               

              Alan Stirling Technology Ltd, 135 Lisson Grove, London NW1 6UP

              +44 (0) 20 7724 2456 - alan@ast.fm - www.ast.fm.

              FileMaker Certified Developer for versions; 7 8 9 10 11 12 13.

              • 4. Re: Reports
                Jason_Farnsworth

                Alan,

                 

                Ha! It works, your a genius in my mind.

                 

                Thank you very much I appreciate all your help,

                 

                Jason Farnsworth

                Odessa, Tx