1 Reply Latest reply on Sep 26, 2013 9:09 AM by philmodjunk

    Printing With Porals



      Printing With Porals


           I have a client who uses a form set up in FilePro with a portal on it to allow for the import from another table to all the relevant information can be pulled to the front and be accessed from a simple view. However, when this information is printed, only the information that is currently visible in the box at the time can be seen. Is there a way to change it so the box expands for printing so that all the information can be seen?


           We've tried it with a separate form, but the client wants it in as few pages as possible, and keeping the relevant information grouped together.

        • 1. Re: Printing With Porals

               The best way to print data in a portal is to use a layout that does not have a portal. Use a list view layout based on the portal's table with data from the parent table included in the header, footer, grand summary or sub summary layout parts of that layout. The script performs a find or uses Go To Related records to pull up the correct set of records and then prints, previews or saves as PDF depending on the needs of the user.

               The Invoices starter solution uses this method to print invoices if you want to see a working example.

               And the user need not know that this extra layout even exists. They can just click a print button on the current layout and the script can do the rest, returning to the original layout when finished.

               The second best way--and this sometimes cannot be avoided, is to set up a second layout with a very tall portal with many more rows than you expect to need. You then set the portal and all objects in the same layout part located below it, to "slide up" and to "resize enclosing part". This then causes the portal to shrink down to just the number of rows needed to show the data in the portal.

               And here's a big part about why this is the "second best" approach:

               Key facts about sliding layout objects:

          1.           It's only visible in preview mode and when you print/save as PDF...
          3.           Sliding fields will shrink but not expand.
          5.           All layout objects below and in the same layout part as the slide/resize field need to also be set to slide up and resize.
          7.           Objects in headers and footers will not slide.
          9.           Portals will shrink/slide to fit the number of rows of records, but fields within the portal row will not shrink/slide.
          11.           Fields will slide up only if Top alignment is specified for it and will slide left only if Left alignment is specified.
          13.           Consistent side borders are difficult to achieve with sliding fields.