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

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics