Matrix report exporting to Excel hidding columns
Hi All,
I am facing a problem when exporting my data into Excel 2010.
I am using SSRS 2008 r2 and I have done a report in matrix which is working fine but when i am exporting to Excel version it's hidding some Columns.
When exported to excel screen shot below
on the above I am missing B,C,D etc ??
Is there any property I need to set up with in the matrix when exporting to excel ??
Thanks and looking forward to hearing some suggestions.
Dasari
June 6th, 2012 10:12pm
Hi,
Based on your screeshot, I guess if you see this tablix in the Design mode their wont be any blank columns between first and second column. If so,
Check what you are having in the header section. You have any heading which is cross the columns and ended in between the tablix columns then there is a chance to have the blank columns. I had provided the solution for this type of issues kindly check the below
link for the solution.
http://social.msdn.microsoft.com/Forums/en-US/sqlreportingservices/thread/df0c8d1b-9c5d-47ac-9d69-0556717b9997
Thanks
Sridhar V
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
Please click "Mark as Answer" if this resolves your problem or "Vote as Helpful" if you find it helpfulSridhar
Free Windows Admin Tool Kit Click here and download it now
June 11th, 2012 2:26am