1 Reply Latest reply on Mar 19, 2014 1:54 PM by philmodjunk

    Empty Fields Print Issue



      Empty Fields Print Issue


           Hi, In a db. there are some fields. Some are empty and some have data. I want the print of fields with data. But title of empty fields is also printed which i don't want. And one thing is that if it is possible then spacing is also required with equal gap among all data fields. See image also


        • 1. Re: Empty Fields Print Issue

               You can add calculation fields for each of these fields to use as field labels. The calculation returns the text for the label only if there is data in the field.

               Example: If ( Not Isempty (colour) ; "Colour" )

               Then you can set both the calculation label fields and data fields to "slide up" and possibly to "resize enclosing part"--if you want to remove unused space when printing or previewing.

               To close up the unused space in Browse mode would require a restructuring of your table to put these fields in a related table where you can use a portal for this data entry.

               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.
          15.           In FMP13, hidden objects (”Hide object when”) will slide/resize.