Friday, February 24, 2012

Export to Excel - Multiple Columns

I have a pretty simple report that when exported to excel some columns span multiple excel columns?

Anybody know how to correct this?

The renderer tries to mimic the layout you created in the report designer. That may be the reason that some columns expand multiple columns.

Try the CSV renderer if you want very basic output.

|||

The renderer will merge columns in order to preserve the layout you defined in the RDL file.

Most often, merged cells are caused when there are report items either below or above the table that has borders that do not align precisely with the table columns.

A classic example of this is a single text box above the table acting as a header. If that textbox's left and right edges begin and end exactly at one of the below table's columns then merging should not occur.

-Chris

No comments:

Post a Comment