I usually drag my data field to the CR and then the header automatically lines up. I make sure the header field is right on the line where the header is separated from the detail. If I have the header field too high in the report - it doesn't print, or it might print out of sequence if just a little higher than the other header fields in that same line on the page. We've got some reports that we use a different report style if they want to export it, so the user has the option for a pretty printable report style or one that exports data only.
--- In vantage@yahoogroups.com, "Jennifer" <Jennifer.Lisser@...> wrote:
>
> Clean exports from CR to Excel is a little bit of an art form...
> Your best bet is to put markers along the top ruler, then size each of the column headings the same as the data element. Leave as little space as possible between columns (go into file options and set your "snap to grid" to .01). This will help avoid extra columns.
>
> To avoid extra rows, select all elements in each section (right click, select all section objects). Set them all to the same height and align them all to top (make sure the element you right-click on is at X position 0 when you align top). Right click the section and select shrink to fit.
>
> One trick I've found too is to start your report headers (e.g. title) at position 0,0 and stretch them across the entire report. Then move your first data column slightly to the right of that. When users export this into Excel they can then highlight columns B on through the end and autosize the columns more easily.
>