1 Reply Latest reply on Jul 18, 2013 4:20 PM by philmodjunk

    Reports that Look like Excel with "wrap text on" setting

    bokenrosie

      Title

      Reports that Look like Excel with "wrap text on" setting

      Post

           I'm trying to clone a report that we do in Excel with data that I have migrated to FM.  I've attached a sample of the report that is challenging me.  I cannot seem to figure out how to tell FM to treat the cells as fixed width and lay the page out like a grid.

           Thanks,

      reportformat.PNG

        • 1. Re: Reports that Look like Excel with "wrap text on" setting
          philmodjunk

               You cannot set this up with a table view, but you can with a list view.

               In a layout designed for use with list view, you can size the fields in the body to be several rows of text tall (Make sure that they are taller than you expect to need. THen select the sliding and visibility settings on the Inspector's position tab to set them to slide up/ resize enclosing part.

               Key facts about sliding layout objects:

                 
          1.           It's only visible in preview mode and when you print/save as PDF...
          2.      
          3.           Sliding fields will shrink but not expand.
          4.      
          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.
          6.      
          7.           Objects in headers and footers will not slide.
          8.      
          9.           Portals will shrink/slide to fit the number of rows of records, but fields within the portal row will not shrink/slide.
          10.      
          11.           Fields will slide up only if Top alignment is specified for it and will slide left only if Left alignment is specified.
          12.      
          13.           Consistent side borders are difficult to achieve with sliding fields.