1 Reply Latest reply on Apr 18, 2014 7:12 AM by philmodjunk

    How to export portal data to PDF

    happyho

      Title

      How to export portal data to PDF

      Post

           Dear All,

           In my invoice layout: I using portal to show invoice intems, the maximum row from 1 - 7 rows. My problem is: I have over 30 items when I export the Invoice layout to pdf file, It shows only 7 items. How can I make the pdf show 30 Items in other pages?

           Thanks

        • 1. Re: How to export portal data to PDF
          philmodjunk

               Use a different layout. The invoices starter solutions that came with FileMaker 11, 12 or 13 all use the method I am about to describe to print invoices so you can examine them to find a working example of this method.

               Create a list view layout based on your portal's table instead of the invoice table. Put the fields that you need from the invoices table in the header and/or footer of this layout. Make the body a narrow row just tall enough to contain the fields from the portal's table that you want on your invoice. Starting from the invoice table and from the invoice record that you want to print, perform a script that either uses a scripted find or Go To Related Records to pull up the correct set of records from your portal on this new layout. If you then print or save as PDF from this layout, your invoice can print out with as many pages as needed to list all the items on the invoice.