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

Memo Fields - Keep together

edited July 2007 in End User
Chaps

Sorry if this is the wrong place for this post.

I have a report that is a bit like this

MEMO Field DBTEXT1 DBTEXT2

If the memo field has a few lines on it the detail band grows in size
accoringly - all great.

If the last record on the page grows then part of the memo appears at the
bottom of page 1 and then continues to page 2.

What I want to do is force the entire record to stay together so that the
memo does not print on page 1 as it does not fit. I want it to print on page
2.

I am getting this on bottom of page 1

MEMO Data No Data No data

Then on top of page 2

Memo Data part 2 Data Data

Can you help?

Thanks

mark

Comments

  • edited July 2007

    Add a Group to the report and set Group.KeepTogether to True. Define the
    group on a datafield that is unique for each record.


    --
    Nard Moseley
    Digital Metaphors
    www.digital-metaphors.com

    Best regards,

    Nard Moseley
    Digital Metaphors
    www.digital-metaphors.com
  • edited July 2007
    I have a group..and yes its set to KeepTogether..

    I am confused by your statement of a datafield that is unique for each
    record...each group of records will have the same grouped field surely.

    In my example my group field is Room (its a list of furniture items by
    room). So I group on this field. I am experiencing the problem that I
    described.

    Thanks

    Mark


  • edited July 2007
    Nard

    I have a memo field in the detail band. I adjusted the size of this (made it
    smaller) and I now have huge improvements.

    I think this is where I was having the problems

    Cheers

    Mark


  • edited July 2007

    If you want to keep data from the same record together, then you essentially
    want something like a 'detail band' keep together behavior. We do not
    currently have a Detail.KeepTogether property. So a couple of approaches
    that can try...

    - my prior suggestion, which is to create a group on a field that is unique
    for each record and set the group keep together to true. That would give you
    'keep detail together' behavior.

    - another approach might be to create a Region and put the memo and dbtext's
    inside the Region. Then set Region.KeepTogether to true.



    --
    Nard Moseley
    Digital Metaphors
    www.digital-metaphors.com

    Best regards,

    Nard Moseley
    Digital Metaphors
    www.digital-metaphors.com
This discussion has been closed.