5 Replies Latest reply on May 14, 2012 9:23 AM by jbante

    Vertical Lines for Reporting in FM12

    jda76

      Most of our reports (Invoices, Order Confimations, etc.) in FM11 used vertical lines which extended from the header to the footer between columns. We also used container fields to display watermark-like text behind the body records, such as "PAID". These layout objects started in the header and crossed layout part boundaries.

       

      Now, with FM12, the objects cut off after the header and that messes up a lot for us. Is there a way to achieve the same result as described above with FM12?

       

      Thanks!

        • 1. Re: Vertical Lines for Reporting in FM12
          beverly

          I never could get one line to extend like that. Can you slit the lines for each part?

           

          Also, for 'watermark' would a text set with conditional formatting work for you? I found that I could toss many of these kinds of fields with the text.  This, of course does not display across records in list view.

           

          -- sent from my iPhone4 --

          Beverly Voth

          --

          • 2. Re: Vertical Lines for Reporting in FM12
            datastride

            jda76,

             

             

             

            I have been doing exactly the same thing to create vertical lines in Invoices, Order Acknowledgments, Proposals, etc. And like you, I now find that the behavior changes in FM 12.

             

             

             

            Browse Mode: Things seem to work the same in FM 11 and FM 12, at least for my forms that use vertical lines extending from top to bottom of a portal. I use this in the area of my invoice form (portal) where line items are entered.

             

             

             

            Preview Mode: This is where the behavior change occurs for me. Previously a vertical line stretching from above the body to below the body was drawn thru the height of the body, and was automatically sized correctly as the size of the body changed based on “sliding”. Now no vertical line appears in the body. I would report this as a bug, and I plan to do the same.

             

             

             

            P.S. I have experimented to try and find an alternate means of positioning vertical line(s) such that I can get a continuous line from top to bottom of the body, but no luck. If a line starts in the body and extends to the very last point (pixel), the line will be drawn, but it overrides the (desirable) sliding up of the data in the body, and thus negates the usefulness of this approach for forms such as invoices.

             

             

             

            Peace, love & brown rice,

             

            Morgan Jones

             

             

             

            FileMaker + Web:  Design, Develop & Deploy

             

            Certifications: FileMaker 9, 10 & 11

             

            <http://www.onepartharmony.com/> One Part Harmony 

             

            Austin, Texas • USA

             

            512-422-0611

            • 3. Re: Vertical Lines for Reporting in FM12
              jda76

              The loss of this functionality is a documented change with FM 12.  It has been a real issue with some of my clients who want vertical column rules on invoices, statements, etc.  Many people have suggested vertical lines in the body part the same height as the body.  If an invoice only has two line items, they are not likely to extend all the way to the footer and it looks silly.

               

              I has also been suggested to me that I submit a request to bring this functionality back through links on this site and FM's main site.  Please join me in doing so!

               

              Thanks!

              • 4. Re: Vertical Lines for Reporting in FM12
                stephensexton

                Have you tried placing a narrow empty field (global or otherwise) that extends the height of the body and has sliding up & resize enclosed part enabled.  You could set one of the field boundaries to the line thickness that you need so that you have a vertical line extending from header to footer.  I just tried this and it worked well.  You may also be able to use one of your existing fields on the layout as long as it extends the entire height of the body with sliding features enabled.... perhaps setting left or right margin to 3mm or equivalent in pixels so any text doesn't run in to the boundary.  Basically, you are using a field border instead of a line to create the vertical line effect.

                • 5. Re: Vertical Lines for Reporting in FM12
                  jbante

                  I have used the vertical lines within the body part combined with a bottom border on the body part with a conditional format so that it only shows up on the last item for a page, which creates a satisfying box to contain the vertical lines. It isn't exactly what the client wanted, but it was acceptable.