Exporting to Excel - Memofields do not show

rbuser

We are using RB 7.01. When we export the reports from the preview mode into
Excel we lose data which are in DBMemo or Memo components. In RB 5.0, we
were previously able to see the data in these components after exporting to
Excel.

Any suggestions for solving this problem.

Thanks.
Prathy

digitalmetaphors

Are you using Waler's TExtradevices or Pragnaan's devices? Please state
this info or contact the 3rd party device author directly for the best
support of their product.

Can you create a new report that only has a memo in it and export it to
Excel?


Cheers,

Jim Bennett
Digital Metaphors

rbuser

We are not using Waler's TExtradevices or Pragnaan's devices.

When I tried to export a new report with only memos in it to Excel, the
Excel file was blank.

Any suggestions.

Thanks.

Prathy

digitalmetaphors

Sorry, the memo controls will not export to a delimited text file. They will
export to a report emulation text file, but not a delimited text file.
Perhaps you could create a report that uses a report emulation text file to
create a report that is formatted the way you want. The alternative is to
break the report up using TppDBText controls and TppLabels instead of
TppDBMemos and TppMemos.


Cheers,

Jim Bennett
Digital Metaphors

rbuser

Any ideas why we were able to export the memo controls from the report into
Excel when we were using RB5.0 ?
Only since we have upgraded to RB7.01 have we come across memos controls
from the report not exporting to Excel.

Thanks
Prathy

digitalmetaphors

Memos should not have been able to export. You must have used a TppDBText or
a custom file device class? The device architecture is open so you can write
your own device.

Try using a TppDBText that is invisible. Then hook it up to the memo
database field. Then when you are printing to the file device, set it to be
visible and use it to write the memo contents to the delimited text file.


Cheers,

Jim Bennett
Digital Metaphors