New call-to-action
Results 1 to 11 of 11

Thread: Report: Variable Not Shrinking

  1. #1
    "Certified" Alphaholic
    Real Name
    Louis Nickerson
    Join Date
    Aug 2002
    Posts
    1,039

    Default Report: Variable Not Shrinking

    I have placed a Global Variable in my Report Footer and selected the Allow Shrinking Field Property, but the field does not shrink as expected.

    Other objects (memo fields for example) shrink as expected.

    Thanks in advance for any help that can be offered.

    Louis

  2. #2
    "Certified" Alphaholic
    Real Name
    Tom Cone Jr
    Join Date
    Apr 2000
    Location
    Florida
    Posts
    23,317

    Default Re: Report: Variable Not Shrinking

    What value does the variable hold when you expect the object to shrink?

    If no simple explanation is found, consider using a conditional object.

  3. #3
    "Certified" Alphaholic
    Real Name
    Louis Nickerson
    Join Date
    Aug 2002
    Posts
    1,039

    Default Re: Report: Variable Not Shrinking

    Tom,

    Thanks for your reply.

    This is a character variable (Global) which holds the contents of a memo field from a table that is not part of the set the report is based on.

    If I create a report based on the table that the memo field belongs to and place the memo field itself on the report, then it does shrink as expected.

    I suppose I could write the contents of the unrelated table's memo field to a memo field in the table the report is based on, but that would mean that every record would have a field full of otherwise unnecessary data, and... since it is a memo field, it could potentially be quite a bit of data.

    Regardless, I wonder why a report field based on a variable won't shrink?

    Thanks again,

    Louis

  4. #4
    "Certified" Alphaholic
    Real Name
    Tom Cone Jr
    Join Date
    Apr 2000
    Location
    Florida
    Posts
    23,317

    Default Re: Report: Variable Not Shrinking

    Ok. What does "doesn't shrink as expected" mean? Are you trying to suppress an empty object, or are you trying to for something else?

  5. #5
    VAR
    Real Name
    Martin W. Cole
    Join Date
    Apr 2000
    Location
    Terrell, Texas (near Dallas)
    Posts
    5,962

    Default Re: Report: Variable Not Shrinking

    put it in an rtf object
    Cole Custom Programming - Terrell, Texas
    972 524 8714
    martin_w_cole@msn.com

    ____________________
    "A young man who is not liberal has no heart, but an old man who is not conservative has no mind." GB Shaw

  6. #6
    "Certified" Alphaholic
    Real Name
    Raymond Lyons
    Join Date
    Apr 2000
    Location
    Carlsbad, CA
    Posts
    2,143

    Default Re: Report: Variable Not Shrinking

    This is interesting to me because just tonight I experienced the following with report footer placement:

    1. A memo field in the footer would not grow when printing, and if shrink is also checked it won't print at all. Move the same field into the detail section and it grows (not sure I tested shrinking in the detail section).

    2. An rtf in the footer would also not grow when printing whereas it does in the detail.

    Ray Lyons

  7. #7
    "Certified" Alphaholic
    Real Name
    Louis Nickerson
    Join Date
    Aug 2002
    Posts
    1,039

    Default Re: Report: Variable Not Shrinking

    Tom,

    Quote Originally Posted by Tom Cone Jr View Post
    Ok. What does "doesn't shrink as expected" mean? Are you trying to suppress an empty object, or are you trying to for something else?
    The variable object that is placed on the report is 2 inches high and almost as wide as the report. If the text within the variable only takes up 1 inch of vertical space, then I would expect that only 1 inch of vertical report space would be occupied by the variable at print time.

    As I indicated earlier, this is exactly how the "Allow Shrinking" feature works if the object is a memo field instead of a variable.

    I did resolved the issue by making the memo field one of the fields in the set. It works properly now.

    Thanks to all who responded!

    Louis

  8. #8
    VAR
    Real Name
    Martin W. Cole
    Join Date
    Apr 2000
    Location
    Terrell, Texas (near Dallas)
    Posts
    5,962

    Default Re: Report: Variable Not Shrinking

    Raymond - also, neither grow nor shrink works in page footers rtfs. I reported all this at least twice at least 6 months ago.
    Cole Custom Programming - Terrell, Texas
    972 524 8714
    martin_w_cole@msn.com

    ____________________
    "A young man who is not liberal has no heart, but an old man who is not conservative has no mind." GB Shaw

  9. #9
    "Certified" Alphaholic
    Real Name
    Raymond Lyons
    Join Date
    Apr 2000
    Location
    Carlsbad, CA
    Posts
    2,143

    Default Re: Report: Variable Not Shrinking

    Quote Originally Posted by martinwcole View Post
    Raymond - also, neither grow nor shrink works in page footers rtfs. I reported all this at least twice at least 6 months ago.
    Thanks martin. My guess is we have seen the last update patch so nothing else will be fixed for v7. Of course arguably this is not a bug--they might just say, "who would want growing and shrinking in a footer?" Me for one.

    Last night I also noticed that color equations do not work if a field on a form is any kind of drop down rather than a Type-in field. Kind of a critical issue in an app of mine--I Mickey Moused [new verb!] a solution but it is crude (2 fields side by side, 1 type-in read only with a color equation, 1 drop down so narrow that the value does not show--very crude but it more less works). I put this one on the wish list cuz I just do not think anything more is going to happen with v7, though I am suspect they have fixed a bunch of things. (I certainly hope I am wrong about having seen the last v7 patch.)

    Ray

  10. #10
    VAR
    Real Name
    Martin W. Cole
    Join Date
    Apr 2000
    Location
    Terrell, Texas (near Dallas)
    Posts
    5,962

    Default Re: Report: Variable Not Shrinking

    Selwyn told me they may issue a last patch for V7 after V8 is out.
    Cole Custom Programming - Terrell, Texas
    972 524 8714
    martin_w_cole@msn.com

    ____________________
    "A young man who is not liberal has no heart, but an old man who is not conservative has no mind." GB Shaw

  11. #11
    "Certified" Alphaholic
    Real Name
    Raymond Lyons
    Join Date
    Apr 2000
    Location
    Carlsbad, CA
    Posts
    2,143

    Default Re: Report: Variable Not Shrinking

    Quote Originally Posted by martinwcole View Post
    Selwyn told me they may issue a last patch for V7 after V8 is out.
    That would be wonderful!!!

    Ray

Similar Threads

  1. Detail Region Not Shrinking For Me
    By Vince McGinnis in forum Alpha Five Version 5
    Replies: 11
    Last Post: 03-21-2003, 04:41 AM
  2. Shrinking text field in report
    By Ohlen Cartmell in forum Alpha Five Version 4
    Replies: 3
    Last Post: 01-11-2003, 11:46 AM
  3. Shrinking Fields
    By Larry F. Carraher in forum Alpha Five Version 5
    Replies: 1
    Last Post: 08-01-2002, 01:11 PM
  4. Shrinking Region
    By Phil Rolf in forum Alpha Five Version 4
    Replies: 4
    Last Post: 07-15-2001, 03:04 PM
  5. Fields not shrinking
    By Becky McNichols in forum Alpha Five Version 4
    Replies: 4
    Last Post: 06-04-2001, 03:02 PM

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
  •