Exporting to Excel adds a blank column in the middle

[SBendBuckeye]

Hello All,

I am exporting to Excel using CR 8.5. This particular report has some blank columns added to facilitate the user adding some additional data. I had to add a dummy field for a couple of them to force other data to align properly but everything is working just fine except that there is a completely blank column between two ordinary columns. It is not a huge deal as it can be easily deleted but it bugs me that I can't explain how it got there. Any ideas?? Thanks!

Have a great day!

j2consulting@yahoo.com

 

[synapsevampire]

Move the 2 columns closer together.

Exporting is always a bit tricky, the service pack helps with Excel exports:

http://support.businessobjects.com/fix/hot/si75/?ref=default.asp_selectlist

-k

 

[lyanch]

Sometimes the only way to keep it from adding the extra columns is to have the columns touching and narrow (smaller than standard excel columns. Wider columns seems to encourage the "extra blank" columns". A lot of this is fixed in ver 9, but everything you formatted to export nicely in ver 8,5 will probably need to be reformatted for exports in 9.

Lisa

 

[fredp1]

What I found was to make sure that the fields are 'touching' a guideline on both side of the field. The field should then have red marker on the left and right hand side of the field. Zoom in at 200% to have a close look to ensure they field is touching the guide lines.

Also make sure that any fields above and below the sections are also touch guide lines on the left and right of the field. Sometimes a heading may not be snapped to a guide line.

Fred

 

[synapsevampire]

Good advice, Fred.

That should always be the case when you design reports.

Here's a whitepaper:

http://support.businessobjects.com/library/kbase/articles/c2006244.asp

-k