Alpha Video Training
Results 1 to 5 of 5

Thread: Allow growth when printing; Memo field not growing

  1. #1
    Member wburchell's Avatar
    Real Name
    Will Burchell
    Join Date
    Jun 2010
    Posts
    82

    Default Allow growth when printing; Memo field not growing

    Hi, I have a report issue in an A5 v10.5 web app where I cannot get a memo field to re-size to fit its contents. I have been reading some interesting work arounds to the "Allow growth when printing" issues discussed on the forum and have tried the following:
    • Checked that the field is a memo field
    • tried dropping the field on to a Rich Text object
    • tried using a calculated field based on the memo
    • tried dropping the calculated field on to the Rich Text field
    • tried different fonts and sizes since there was mention that this affected the growth property
    • all of the above, making sure that the fields/objects were not touching other fields/objects

    The field is in the "Page Header" of the report, also I am mostly checking the report as a preview. Should this give the identical results as actually printing off the report? Here are sceen shots of the settings for the Rich Text object:
    Capture1.JPG
    ...here's the settings for the calculated value (AuditObs = SQLDATASOURCE->Audit_Observations):
    Capture2.JPG
    ...and how the report looks in preview:
    Capture3.JPG
    As always, I am very greatful for any assistance offered.
    Last edited by wburchell; 12-21-2011 at 10:57 AM. Reason: lnik not showing
    Take care,
    Will Burchell.

  2. #2
    Volunteer Moderator
    Real Name
    Alan Buchholz
    Join Date
    Oct 2000
    Location
    Delavan, Wisconsin
    Posts
    9,618

    Default Re: Allow growth when printing; Memo field not growing

    Look at the placement of the memo field in the band. The field(s) below the memo field are in a fixed position, so the memo field can't expand.

    Either move the fields or use printhtml() to define the band. It's more flexible.
    Al Buchholz
    Bookwood Systems, LTD
    Weekly QReportBuilder Webinars Thursday 1 pm CST

    Occam's Razor - KISS
    Normalize till it hurts - De-normalize till it works.
    Advice offered and questions asked in the spirit of learning how to fish is better than someone giving you a fish.
    When we triage a problem it is much easier to read sample systems than to read a mind.

  3. #3
    Member wburchell's Avatar
    Real Name
    Will Burchell
    Join Date
    Jun 2010
    Posts
    82

    Default Re: Allow growth when printing; Memo field not growing

    Hi Alan, many thanks for the answer to my report problem! I have used the printhtml() function in a calculated field and moved the field into the detail band. The memo now expands as required, happy days!!!
    Take care,
    Will Burchell.

  4. #4
    Volunteer Moderator
    Real Name
    Alan Buchholz
    Join Date
    Oct 2000
    Location
    Delavan, Wisconsin
    Posts
    9,618

    Default Re: Allow growth when printing; Memo field not growing

    Quote Originally Posted by wburchell View Post
    Hi Alan, many thanks for the answer to my report problem! I have used the printhtml() function in a calculated field and moved the field into the detail band. The memo now expands as required, happy days!!!
    Glad to hear that solved the problem.

    Please post an image or sample for others to follow...
    Al Buchholz
    Bookwood Systems, LTD
    Weekly QReportBuilder Webinars Thursday 1 pm CST

    Occam's Razor - KISS
    Normalize till it hurts - De-normalize till it works.
    Advice offered and questions asked in the spirit of learning how to fish is better than someone giving you a fish.
    When we triage a problem it is much easier to read sample systems than to read a mind.

  5. #5
    Member Scott Kurimski's Avatar
    Real Name
    Scott Kurimski
    Join Date
    Jul 2009
    Posts
    330

    Default Re: Allow growth when printing; Memo field not growing

    If you are using a memo field with multiple lines of text (where the lines of text end with a carriage return) and would like to retain that format. Use a calculation on the report something similar to the one shown below. This will retain the format and allow the field to grow/shrink as needed on the report.

    cName_Of_Calculation = printhtml(*plain_to_html(cName_Of_Calculation))

Similar Threads

  1. Allow growth when printing; failure and work around.
    By irwincohen in forum Alpha Five Version 9 - Desktop Applications
    Replies: 4
    Last Post: 11-17-2011, 01:03 PM
  2. Can't Disable Allow Growth when Printing on Report
    By totallycovered in forum Application Server Version 10 - Web/Browser Applications
    Replies: 2
    Last Post: 05-12-2011, 02:01 PM
  3. Memo field not allowing growth in reports
    By islassoc in forum Alpha Five Version 10 - Desktop Applications
    Replies: 3
    Last Post: 11-19-2010, 11:27 AM
  4. Allow growth when printing - doesn't
    By CALocklin in forum Alpha Five Version 7
    Replies: 2
    Last Post: 01-17-2006, 12:01 PM
  5. Allow growth when printing trouble
    By Chris A in forum Alpha Five Version 6
    Replies: 13
    Last Post: 01-05-2005, 08:46 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •