Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Suppress Line Feed/Carriage Return in Subreport

When exporting a report in tabular format, with one "field" actually being a subreport, the export to excel places the subreport "field" on a separate line and adds an extra line below that. How do you suppress the line feeds when the export from crystal sees the subreport?


Former Member

Hi Ralph,

When exporting to MS Excel data only, it will always display the subreport data on the next line.

My suggestion will be to export the report to MS Excel, not MS Excel Data Only, and the subreport will appear on the same line.

When exporting to MS Excel the information will look as close as possible to the way it look in Crystal Reports, but to acheive this result it might add extra columns and rows. This happen because objects are not aligned in the design of the report and the exporting driver have to create those extra rows or colums. To avoid this situation, use guidelines to align your object on the report horizontally and vertically.

0 View this answer in context

Helpful Answer

Not what you were looking for? View more on this topic or Ask a question