4 Replies Latest reply on Jul 26, 2010 3:33 PM by LaRetta_1

    How Do I Get Multiple Line Items to Print

    PROFT

      Title

      How Do I Get Multiple Line Items to Print

      Post

      Hi,

      I have a standard invoice database set up w/ Customers, Line Items, Products, and Invoices Tables.  On the Invoices table, I have a portal to the Line Items table where I enter the items for the invoice.  The set up is working well and I can enter the individual items in the portal, including quantity, and the individual line totals and the overall amount due are working correctly.  

      What I can't figure out is how to get all of the line items to show up in a print layout.  I've tried setting up the print layout both based on the invoices table and based on the line items table, but no matter what I try, only the first portal row is shown.  

      Any direction you can give towards solving this would be greatly appreciated.

        • 1. Re: How Do I Get Multiple Line Items to Print
          sunmoonstar.13

          You should be using the print layout based on the line items table. Open this layout and then go to Layouts menu > Part Setup then double-click the Body part and make sure that "page break before each occurence" is NOT checked.

          Nick

           

           

          • 2. Re: How Do I Get Multiple Line Items to Print
            LaRetta_1

            Two ways:

            1) From Invoices side - Place the Invoice information in leading part with the portal in the body.  Create as many portal rows as you will EVER need - keep expanding the body to allow for them.  The Header, Body and Footer must total less than 5,000 px total.  You can usually fit approx. 400 portal rows. Then select both the portal and any fields inside and select Format > Set Sliding/Printing and Sliding up Based Upon.  Also check 'also reduce size of enclosing part.'

            2) Print from LineItems - each body row will be a lineitem (skip using a portal).  Create a leading part (based upon your LineItems Invoice ID).  Sort by the LineItems InvoiceID (critical).  Then go to Preview mode.

            If only the first portal row shows, I suspect that you have the fields within the portal either too high or too far to the left.  Use your Object Info (or Inspector) to see how high (and to the left) on the layout that your portal sits.  Then make sure that your fields are not even 1 px further left or high.

            • 3. Re: How Do I Get Multiple Line Items to Print
              PROFT

              Thanks Sunmoonstar_13 and LaRetta.  It's working now.  I had included the fields, but not as a portal on the layout.  Once I recreated the portal everything worked fine.

              LaRetta, thanks for the extra tip on sliding/printing.  The receipt is adjusting as it should based on the number of items purchased.

              • 4. Re: How Do I Get Multiple Line Items to Print
                LaRetta_1

                Hey Nick, it is a fallacy that one should always print from the LineItems table.  It was started by those who have no idea that portals can reduce.  Invoices and their lineitems is good example .  There are also times when it is REQUIRED to print from a parent layout because there is a mix of left-outer joins and a summarized report with several parts and a portal of related records (placed in the body) is required.  And yes, it is usually easier to print from LineItems and that's why I provided both perspectives.

                It is always a good idea to never say never or always. :^)