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?
Patrick Genest replied
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.