While working on SSRS reports , i have encountered the merge cell issue when exporting to excel as shown below
To resolve this all i had to do was ,
1. Make sure that while designing the report in the report layout, all the report’s rows (header row as well data rows) should start at (0,0) location and there is no additional space on the left-hand side of the report in the design layout. This can be
done by making the Left and Top values under the Location section in the properties window, 0
2.I have removed the header completely as I was using controls like textbox etc which were the root cause for the merge issue.
3.For header names , i have created a parent group with a group name and formatted it in such a way that it looked as a header.I have set the properties such that the header names repeated on each and every page.
To resolve this all i had to do was ,
1. Make sure that while designing the report in the report layout, all the report’s rows (header row as well data rows) should start at (0,0) location and there is no additional space on the left-hand side of the report in the design layout. This can be
done by making the Left and Top values under the Location section in the properties window, 0
2.I have removed the header completely as I was using controls like textbox etc which were the root cause for the merge issue.
3.For header names , i have created a parent group with a group name and formatted it in such a way that it looked as a header.I have set the properties such that the header names repeated on each and every page.
No comments:
Post a Comment