6 Replies Latest reply on Apr 16, 2009 12:07 PM by comment_1

    Bypassing the New Page/End of Page command

    KingsPawn

      Title

      Bypassing the New Page/End of Page command

      Post

      Newbie

      FMPro 9 Advanced

      Microsoft XP

       

      I have 9 reports with many lines and each report is working fine.

      I would like to create a report that list the first three detail lines from each report.

      Sometimes a line on one report is the exact same line found on other reports.

      Doing a found set for the first report and then doing an extend of the next report will not allow records to be added that are already in the found set.

       

      How can you send a found set to a printer with out issuing a new page/end of page command to the printer?:smileysad:

       KingsPawn:smileyvery-happy:

        • 1. Re: Bypassing the New Page/End of Page command
          philmodjunk
            

          Filemaker gives you two basic options for printing records:

           

          You can print the current record (select current record in the print dialog)

          You can print all the records in the found set (select records being browsed in the print dialog)

           

          You don't really have any other options.

           

          We can often get what we need through creatively manipulating the found set of records we are going to print. I can't quite follow your description of your report or report(s). Can you post a more detailed example of what you are trying to do?

          • 2. Re: Bypassing the New Page/End of Page command
            KingsPawn
              

            PhilModJunk,

            Sure nice to hear from you again. How was the Pizza?

             

            100 Yards 10 ½ Lb Gun Match 1 Page 1

             

                  First Time Supper Shooters 

            1          Bill Smith                .186

            2          John Jones              .229

            3          Betty Kerry             .241

            .                      .                           .

            .                      .                           . Page 2

                                                                 Page 3

                                                                     .

                                                                 Page n

              

            =========================

                            Female Shooters

            1          Betty Kerry              .241

            2          Jane Ponder             .289

            3          Cindy Porter            .417

            .                      .                           .

            .                      .                           . Page 2

                                                                 Page 3

                                                                     .

                                                                 Page n

             

            This goes on for 9 different Team types.

            These report contain a lot more information than that which I have displayed.

             

            Then I would like to create a report with just the Top 3 in each team type on one page like the example below.

              

            100 Yards 10 ½ Lb Gun Match 1 Page 1

             

            Top 3 First Time Supper Shooters 

            1          Bill Smith                .186

            2          John Jones              .229

            3          Betty Kerry             .241

            =========================

            Top 3 Female Shooters

            1          Betty Kerry              .241

            2          Jane Ponder             .289

            3          Cindy Porter             .417

              

            I'm just Piddlin' in the past,

             KingsPawn:smileyvery-happy:
            • 3. Re: Bypassing the New Page/End of Page command
              philmodjunk
                

              I see a 1, 2, 3... in the left column. If that's a number field in your table, you can do what you need easily.

               

              Perform a find that puts "< 4" or "1...3" in this rank field to restrict your found set to just those records that are ranked 1, 2 or 3.

               

               

              • 4. Re: Bypassing the New Page/End of Page command
                KingsPawn
                  

                PhilModJunk,

                 

                 

                Ok lets say that Betty Kerry is in Third place on both of them, now what? And the ranking is not stored in the record although it could be but would not solve the problem. You don't need to kill your self on this I will just build a strings containing what I want on the line and write it to a new table then print from the new table.

                 

                 

                I just thought that there might be some way of bypassing the new page/end of page command. I guess you can't win them all.

                 

                 

                Later tater.

                 

                KingsPawn:smileyvery-happy:

                • 5. Re: Bypassing the New Page/End of Page command
                  philmodjunk
                    
                  KingsPawn wrote:

                   

                  Ok lets say that Betty Kerry is in Third place on both of them, now what?

                  THen your find should pull up both instances, they should be two different records right? Then your sort should group the records by event. That should list Betty as third place in both parts of the report.

                   

                  And the ranking is not stored in the record although it could be but would not solve the problem.

                  It should, with the right table/relationship design.

                   

                  You don't need to kill your self on this I will just build a strings containing what I want on the line and write it to a new table then print from the new table.

                  That sounds like more work that what I am suggesting.

                   

                  I just thought that there might be some way of bypassing the new page/end of page command. I guess you can't win them all.

                  All through this thread, I've ignored this statement, because I have no idea what you mean by "new page/end of page command". Are you using instant web publishing or something?

                   

                  • 6. Re: Bypassing the New Page/End of Page command
                    comment_1
                      

                    If Betty Kerry competed in two events, then there should be two separate result records, both related to Betty Kerry.

                     

                    If the ranking comes from a summary field, then you can (1) find all records, (2) sort by event and competitor (re-order based on rank), and (3) loop between the records omitting all records ranked 4 and higher. The quick way to do this is to omit the first 3 records in each group then jump directly to the first record in the next group.

                     

                    This is just a rough sketch - you might need to make adjustments for ties.

                     

                     

                    ---

                    BTW, I have no idea what you mean by "new page/end of page command".