Crystal reports 11 export to excel

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.
Who is Participating?
mlmccConnect With a Mentor Commented:
Nope.  They designed the export to work that way since a subreport can grow.

BuddyToAuthor Commented:
Thanks. I was afraid that was the answer.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.