Hi All,
I've faced a difficult problem. After exporting any report from reporting services to excel file format, in excel sheet there are several merged cells appearing in a cell. I'm using SQL Server 2000 & Microsoft Visual Studio .Net 2003.
Can anyone help me out regarding this? Is there any method in reporting services, so that every column will appear into one cell in excel sheet after exporting the report?
Thanks,
Uttam Kr. Dhar
Medi Assist India Pvt. Ltd.
Do you have any report items either above or below the table in your report? If so, that's probably the cause of the merged cells.
The Excel rendering extension will merge cells throughout the worksheet in order to preserve the defined report layout. Most often, this happens when there is a textbox above the table that functions as a header. If the boundary of the textbox ends in the middle of a table cell, cells will need to be merged.
Try to ensure that the left or right edges of the report item line up with table columns in order to minimize cell merging.
For more information, see the "Excel" section of this article:
http://www.microsoft.com/technet/prodtechnol/sql/2005/rsdesign.mspx
-Chris
