1 Reply Latest reply on Oct 20, 2009 12:29 PM by philmodjunk

    Printing portal rows in report

    Karnel

      Title

      Printing portal rows in report

      Post

      1. Using version FileMaker Pro 10.

      2. Windows XP.

      3. I provide FM support at a university and I'm designing a database for our School of Social Work that keeps track of student internship assignments at multiple agencies.  The interns are assigned field supervisors and have a faculty liaison.


      4. I am creating a report that pulls together the four different related tables in my database--Agency, Student, Faculty, and Field Supervisors and is grouped by Agency using a join table called Agency_Internship.  All works great except I would like to only print each Agencies's assignments without a bunch of blank lines on my report.  What i have now is my layout's context is based on Agency and have my Agency's fields on my layout.  I then inserted my Agency_Internship portal and place the needed data from student, faculty, and field supervisors.  Most Agencies have 2 or 3 interns, but a few have as many as 20 interns, so I have set my portal to display 20 rows.  Is there a way to print each agencies internships without all the blank rows?

       

      5. Maybe there is another way to setup this report other than placing the portal on the layout.  I've designed several relational databases before using a good amount of scripting.  Any help you can share on this report would be greatly appreciated. 

       

      6. This database is hosted on our FM9 server and shared out.

       

      Thanks so much!



        • 1. Re: Printing portal rows in report
          philmodjunk
            

          Option 1: Less work but less flexible

          Select your portal while in layout mode and use Format | Set Sliding/Printing... make the portal "slide up, also shrink enclosing part". This works as long as you don't have more portal records than your portal can display. Also, the sliding is not visible in Browse mode, you have to preview, PDF, or print the report to see the sliding.

           

          Option 2: More work, but much more flexible.

           

          Create a list view summary report based on your portal's table. Place fields from the parent table in the header or in sub-summary parts.

          Be careful to sort your records in an order that includes the fields specified as "when sorted by" for each sub-summary part you create and the Sub-summary parts will not be visible in browse mode if you are using FMP 9 or earlier.