Home General
New Blog Posts: Merging Reports - Part 1 and Part 2

How to get variable length memo field

edited June 2008 in General
Hi,
I've got a field represented in Nexusdb as a shortstring, which I use as
a comments field.
I'm trying to print thses comments in a report region.
I use a region beacuse I fin it's the best way to otpionally show a
group of fields.
The region contains 2 fields only, a pplabel 'comments' and a ppdbmemo
field which is directly linked to the shortstring database field.
How do I gte the region (and the comments field) to expand and contract
so that I don't waste space between records when ther is only one
line(or no lines) to be printed in the dbmemo field.
Cheers
Tony

Comments

  • edited June 2008
    I should add I'm using 10.06
  • edited June 2008
    Hi Tony,

    1. Be sure the DBMemo is in fact inside the region. Use the report tree to
    be certain.

    2. Set the Stretch property of the region and the memo to True.

    3. Set the PrintHeight property of the band you are using to phDynamic.

    --
    Regards,

    Nico Cizik
    Digital Metaphors
    http://www.digital-metaphors.com

    Best Regards,

    Nico Cizik
    Digital Metaphors
    http://www.digital-metaphors.com
  • edited July 2008
    Hi Nico,

    Finally got around to trying it and it works fine. Thank you. I now have
    another related problem relating to switching the display of the region
    on and off.
    In order not to display the region at all I set the visible property to
    false. This successfully suppresses display of the pplabel field, but
    not the dbmemo filed. It still displays. I have double checked that the
    dbmemo filed is in fact inside the region by reference to the report
    tree as per your suggestion.

    Regards

    Tony
  • edited July 2008
    can you reproduce this in a small demo? I've never seen anything like
    it--and I use regions & sub reports in this fasion quite a bit.

    Ed Dressel
    Team DM

  • edited July 2008
    Fixed it. Removed reference to the group in the ShiftRelativeTo property
    in the dbmemo and the dbmemo field no longer shows
  • edited July 2008

    Hi Ed,

    See my subsequent post where I took off the shiftrelativeto field. It
    was set to the region in which it lived. Just put it back in and the
    problem reappeared..repeatable.

    Tony
This discussion has been closed.