2 Replies Latest reply on Feb 22, 2011 9:59 AM by fluffyone

    field expansion on reports



      field expansion on reports


      Hi Group

      When running a report, i have fields that are edit boxes and can have more data than the report has room for in the field, how can i set the field to expand to print the whole fields text if it overflows?



        • 1. Re: field expansion on reports

          Fields cannot be set to expand, but--when printing--they can be set to shrink and slide up.

          Often, you need a special layout just for printing if there's a lot of variation in the amount of data entered into the field from one record to the other. A "browse" layout can include a scroll bar on the text fields, on your "print" layout, you can resize the fields to be very large, then use the inspector to set the fields to slide up and to "resize enclosing part".

          Key facts about sliding:

          1. It's only visible in preview mode and when you print/save as PDF...
          2. All layout objects below a slide/resize field need to also be set to slide up and resize.
          3. Only objects in the body will slide.
          4. Portals will shrink/slide to fit the number of rows of records, but fields within the portal row will not shrink/slide.
          5. Consistent side borders are difficult to achieve with sliding fields.
          • 2. Re: field expansion on reports

            Thanks Phill that works well.

            Regards Fluffy