Export Report to EXCEL with Subreport Fields

[ldalessio]

I have created a report that produces one line of data per customer. The last three fields are generated through a subreport. When I export to EXCEL the main report data is on one line and the subreport data is beneath it on another line. Is there a way to export so that it remains on one line?
Thank you.

 

[hilfy]

Since you're talking about subreports, I assume this is a Crystal report.

Unfortunately, there are quirks to the way Crystal exports to Excel that have been in the software for a long time. Have you tried making sure that the subreport and the other fields on the same line are all exactly the same height and have their tops all aligned? You'll probably have to do some creative sizing and alignment to get everything to line up correctly. If that doesn't work, there's not much that can be done about it.

-Dell

A computer only does what you actually told it to do - not what you thought you told it to do.