Remove additional column from Exporting to Excel from SSRS
reporting-services, sql, sql-server
Solution
This is common problem in SSRS - the way how I removing this problem is to use rectangle's . Insert rectangle then CUT your table/matrix PASTE inside rectangle - make sure there is not empty spaces. If you using more than one table/matrix , then insert rectangle inside rectangle etc. ( my record is 14-th depth ) - this is VERY annoying but I know only this way.
Problem
I have a two Matrix Report Items with different DataSet same number of columns and rows of result. matrix table 1 is on the left side and the other one is on the other side, there are no spaces between the two table in design view. The problem is after exporting to excel between the Matrix Report Items it creates additional column in Excel. How can i avoid this? http://www.4shared.com/download/6w5JljQu/Sample.jpg