Multiple rows when exported to Excel..

rbuser

Hi Team,

D10.1, Latest RB. Adt data files.

I have a report with Memo fileds in it which generally appear over two or three rows in the report. Stretch for the
field is checked.

Reviewing and printing is fine, but when I print to .xls Data format the second and third rows of the Memo appear in
their own row in the .xls.

Is there some property to tell it to include all the memo data in just the one cell in the .xls?

Regards & TIA,
Ian

rbuser

Ahhh So! The thicken plots...
If I select XLS Report file I get my report Header/Title but multiple lines/fields for the Memos.
If I select XLS Data file I don't get the Header/Title but the memos are all in the one line/field.

So I, or specifically my Customer, need Report File Header with Data file detail????

Regards,
Ian

nardmoseley

Hi Ian,

Check out the RBuilder Help topics for TppXLSDataDevice/TppXlsxDataDevice
and TppXLSReportDevice/TppXlsxReportDevice.





Best regards,

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

rbuser

Nard Moseley (Digital Metaphors) wrote:

Hi Nard,

Thanks for the pointer. btHeader did it.

Regards,
Ian