Problems with RTF conversion

[Sara Ferrarese via AccessMonster.com]

Hi

I have some troubles exporting reports to RTF: some words are messed up.
My reports are something like
label text label
label text label
label text label
and so on.

When I export I get
text label label text label text
label label label

What can I do? Any help would be greatly appreciated

Thanks in Advance
Sara

 

[Chris Mills]

As I recall, make certain aligned "things" are precisely aligned.

I don't mean "to the pixel". I mean to the precise same Top/Left (whatever is
appropriate) numeric value in the properties. Maybe even heights.

Otherwise the converter might think something is higher/left"er", and
therefore comes before something else in the report.

If this is true, I suppose you could put the things you want later, "a pixel
lower!"

Otherwise I don't know.
Chris

 

[\Sara Ferrarese via AccessMonster.com\]

Hi Chris,
I tried, but It doesn't work.
Actually the reports are much more complicated than what I wrote, much longer
and with subreports. Sometimes it's enough to put the part of messed up
report in a subreport, sometimes not (even if the only subreport is perfectly
exported). Maybe, is there a maximum length? the messed up part is quite
always at the end...

 

[Chris Mills]

I don't know.

I can't find any report I have which messes up in RTF (A2k2).
(except images in background or things overlapped really messes up)

I would be suspicious of putting anything in-line with a subreport.

I can't see max length being a problem. I've gone to some 20 pages/record with
expandable subreports.

You could see if forms work differently. (Forms can be used as reports)

You could try Bring-to-front/Send-to-back as a means of "ordering".

Forse dovete riscriverli appena.

Chris

 

[Chris Mills]

If items across the page have Can Shrink/Can Grow, I would set them
identically.

 

[\Sara Ferrarese via AccessMonster.com\]

Subreports are not in-line with other texts, but when I export it lines of
the subreports are messed up with lines outside the subreport.

I noticed that exporting the report from the button instead of exporting it
from the module (using OutputTo) i get an overflow error (shouldn't they be
the same?).

forse dovrò riscriverlo da capo...

S.

 

[Chris Mills]

I noticed that exporting the report from the button instead of exporting it

from the module (using OutputTo) i get an overflow error (shouldn't they be
the same?).

One would hope so, but neither would I be surprised if (say) error-handling is
a bit different, since one is "manual" and the other is "automatic" of sorts.
It was a good test I might not have thought of.

Clearly, your report/RTF has (multiple) serious problems. At some stage, it
may be necessary to start the report again from scratch, and keep it simple. I
have sometimes spent many "happy" hours taking things out and putting them
back. If re-starting from scratch, I would not even copy/paste from one report
to another, if it's as troublesome as you say.

I note that sometimes I have 2 reports 1) For screen 2) For RTF/Word
conversion. Sometimes the required output is just different.

I would never discount the possibility of "corruption", either in the report,
or even in the test data you are using (which could explain a report only
getting so-far). But then, it's not my place to suggest general desperate
remedies, which you no doubt know.

As no-one else has responded, there does not appear to be a simple answer like
"do this!". Which may put some validity into my advice (start again, knowing
RTF can be tricky esp. if a report gets complex)

forse dovrò riscriverlo da capo...

"Caution. Access can mess with your Head?" ;-)) ;-))

Chris