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

Subreport below Memo

edited May 2004 in General
Hi,
I have a report which print out as follow:

XXX XXX XXXX XXXX MMMMMMMMMMM
SSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSS

Where MMMM is a Memo field which may contain empty or multi-line and SSSSSS
is a subreport below
the memo. XXX's are others detail data. My problem is, if I set the
ShiftRelativeto of the subreport to the Memo field, when the memo contain
multi-line, it do shift relative to it, but if the memo is empty, the
subreport detail will shift up and overlap with other detail data. Is there
any other way to do this kind of report??

Thanks

Vincent

Comments

  • edited May 2004
    Hi Vincent,

    My suggestion would be to place the DBText and Memo components inside the
    TppRegion with stretch set to True. Then have the memo shift relative to
    the region. This way event if the memo is empty, the subreport will not
    overlap the text fields.

    --
    Best Regards,

    Nico Cizik
    Digital Metaphors
    http://www.digital-metaphors.com
  • edited May 2004
    Hi, Nico,
    I did try this before, but the problem using this method is, when I try to
    print the report into text file,
    sometime a blank line will be in the report no matter how I adjust the
    TppRegion. Is there any I have to
    take care if print this kind of report into text file??

    Rgds

    Vincent
  • edited May 2004
    Hi Vincent,

    Are you printing to a Report Emulation TextFile, or are you creating a
    delimeted text file to be loaded in a spreadsheet of some sort? If you are
    trying to get the text to show up in the same order as on the report, be
    sure you are using a Report Emulation Text file.

    --
    Best Regards,

    Nico Cizik
    Digital Metaphors
    http://www.digital-metaphors.com
  • edited May 2004
    Hi, Nico,
    I am trying to print to a Report Emulation Text file, and a blank line is
    always appear in the report no matter
    how I adjust the TppRegion's size.

    Rgds

    Vincent
  • edited May 2004
    Vincent,

    Which version of ReportBuilder are you using? In my testing, I was unable
    to recreate the behavior you are experiencing. If possible, please send a
    sample of the report you are trying to run in .zip format to
    support@digital-metaphors.com and I'll try it on my machine.

    --
    Best Regards,

    Nico Cizik
    Digital Metaphors
    http://www.digital-metaphors.com
  • edited May 2004
    Hi, Nico
    I am using Report Builder 7.0, and I found that the weird thing will happen
    when the memo
    contain multiline. Will send u a sample soon. Thanks

    Rgds

    Vincent
  • edited May 2004
    Hi, Nico,
    In preparing the sample of report to u, I found a funny behaviour for the
    ppMemo.
    If the memo field contain only one line, the ppMemo will print it as font
    we set in the designer,
    but if the memo field contain more than one line, it will somehow change the
    font(This can be seen
    if you print and preview it in the preview form).
    I think this is the reason which cause the additional blank in the Text
    emulation report.
    Please correct me if I am wrong! Thanks!!

    Rgds

    Vincent
  • edited May 2004
    Hi Vincent,

    As a test, you might want to update your version of ReportBuilder to the
    latest version... 7.03. This is a free update since you already have RB
    7.0. Contact sales@digital-metaphors.com for more information.

    --
    Best Regards,

    Nico Cizik
    Digital Metaphors
    http://www.digital-metaphors.com
  • edited May 2004
    Hi, Nico,
    The same thing happen even I upgrade to version 7.03,
    I have send a sample to support@digital-metaphors.com

    Rgds

    Vincent

This discussion has been closed.