Sunday, February 26, 2012

export to excel has merged cell problem

I have noticed that after my report exported to excel, some of the cells are
merged.
For example, I have report as following
ID Project Name Author Description
1 xxxx dfdf fdfdfdfd
after export in the excel, the data shows correctly, but on the top of the
excel file, it may show something like this
A B C D E F
ID Project Name Author Description
1 xxxx dfdf fdfdfdfd
The problem is some of the columns has one column data but excel treat them
as two columns.
Does anyone have any idea? thanks.The Excel renderer will merge cells in order to preserve the report item
alignment you defined when you designed the report.
Merging usually happens when there are report items either below or above
the table whose left or right edges do not exactly match that of the table
cells below.
A classic example of this is a single textbox above a table that functions
as a header. Make sure this textbox starts and ends at the border of one of
the below table's cells.
Best,
-Chris
SQL Server Reporting Services
"Helen" <Helen@.discussions.microsoft.com> wrote in message
news:8EDC7FB7-BC51-473E-A29B-4CDB47E9C4F4@.microsoft.com...
>I have noticed that after my report exported to excel, some of the cells
>are
> merged.
> For example, I have report as following
> ID Project Name Author Description
> 1 xxxx dfdf fdfdfdfd
> after export in the excel, the data shows correctly, but on the top of the
> excel file, it may show something like this
> A B C D E F
> ID Project Name Author Description
> 1 xxxx dfdf fdfdfdfd
> The problem is some of the columns has one column data but excel treat
> them
> as two columns.
> Does anyone have any idea? thanks.
>

No comments:

Post a Comment