Crystal reports 11 export to excel
Posted on 2011-03-17
I work in an environment where Crystal is the only reporting tool I am allowed to use.
All reports must be exported to excel for users.
When I use subreports on my main report, the Crystal export function places the output of the subreport on a different/separate line than main report data that resides in the same section even when I modify export options. I need subreport output to remain on the same line with main report data in the same section. Right now I am using an excel macro to resolve this issue after the report has been exported.
Is there any way that Crystal export to excel can be custom formatted. I have used "Maintain relative object position" and "Maintain column alignment" but always get the same results.