Subreport below Memo
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
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
This discussion has been closed.
Comments
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.
--
Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com
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
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.
--
Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com
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
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.
--
Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com
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
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
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.
--
Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com
The same thing happen even I upgrade to version 7.03,
I have send a sample to support@digital-metaphors.com
Rgds
Vincent