SSRS reports when rendered to an excel format , some times creates cell spreading and this can become an issue ,when the end user want to analyze the results and do some analysis on the worksheet.
The cause of the problem usually lies with the use of any text boxes or rectangles on any header or on the top of tablix or table structure .
In the above report i have placed a text box on the report header to display the report name Contoso Adventure Works and as a result cell spreading of subcategory field has occurred and it occupies two cells B and C
One of the solution' to this problem is set those items to be hidden when rendered,in my case as i was using SSRS 2012 and rendering to an excel format i have used a global parameter in SSRS called Globals!RenderFormat. Name and set the hidden expression like below
IIF(Globals!RenderFormat.Name="EXCELOPENXML",True,False)
After setting this property now the cells remain intact as shown below
Another Common issue is the format setting on the data columns is not preserved when the report is exported to excel ,the solution to this problem is to use the same format expression in the format function of the actual fields and leave the format property to empty as we are not setting any custom formatting on the format property the excel render will display whatever value in that column
The cause of the problem usually lies with the use of any text boxes or rectangles on any header or on the top of tablix or table structure .
In the above report i have placed a text box on the report header to display the report name Contoso Adventure Works and as a result cell spreading of subcategory field has occurred and it occupies two cells B and C
One of the solution' to this problem is set those items to be hidden when rendered,in my case as i was using SSRS 2012 and rendering to an excel format i have used a global parameter in SSRS called Globals!RenderFormat. Name and set the hidden expression like below
IIF(Globals!RenderFormat.Name="EXCELOPENXML",True,False)
After setting this property now the cells remain intact as shown below
Another Common issue is the format setting on the data columns is not preserved when the report is exported to excel ,the solution to this problem is to use the same format expression in the format function of the actual fields and leave the format property to empty as we are not setting any custom formatting on the format property the excel render will display whatever value in that column
