Home General

Multiple rows when exported to Excel..

edited September 2016 in General
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

Comments

  • edited September 2016
    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
  • edited September 2016
    Hi Ian,

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





    Best regards,

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

    Best regards,

    Nard Moseley
    Digital Metaphors
    www.digital-metaphors.com
  • edited September 2016
    Nard Moseley (Digital Metaphors) wrote:

    Hi Nard,

    Thanks for the pointer. btHeader did it.

    Regards,
    Ian
This discussion has been closed.