Export to Excel creates hidden columns and rows

• jerry-621596

  SSCertifiable

  Points: 6096

  More actions

  January 6, 2015 at 2:42 pm

  #314329

  One of my customers noticed that SSRS reports exported to Excel contain hidden rows and columns. These rows and columns contain no data and are either between a textbox and a tablix or they are in the middle of a tablix.

  Does anyone know why SSRS would create these? If so, has anyone managed to tell SSRS not to create hidden/empty rows and columns?

  Thanks!

• Koen Verbeeck

  SSC Guru

  Points: 259165

  More actions

  January 6, 2015 at 2:44 pm

  #1768270

  This seems an interesting post about the subject:

  How to eliminate merged and hidden Cells issue from Excel Export of a SSRS report

  Need an answer? No, you need a question
  My blog at https://sqlkover.com.
  MCSE Business Intelligence - Microsoft Data Platform MVP

• jerry-621596

  SSCertifiable

  Points: 6096

  More actions

  January 6, 2015 at 2:51 pm

  #1768271

  Wow! That was fast!

  I will try those and update with the level of success.

  Thanks!