Crystal Reports 2011 - can't get my Sub Reports detail to print on same line as other detail

[deborahyr]

I can't get my subreports detail to print (export to excel) on the same line as my container report's detail. It displays correctly when I run it in Crystal but when I export it to Excel, the sub report detail prints on separate rows.

 

[groggle]

Have a read of this "old" Crystal Decisions article.

http://hosteddocs.ittoolbox.com/ST030504.pdf

It explains how to produce Crystal Reports that export neatly to excel. With subreports it is a little more tricky than a "simple" report but it is possible. Make sure you have hidden every section in the subreport you don't need to see. Make sure the subreport is perfectly aligned to the guideline of the column it needs to line up with in the main report. Make sure the first column in the subreport is perfectly aligned to the left hand edge of the subreport. Make sure the gaps between columns in the main and sub reports is as small as possible. I try to make them less than 1 mm.