Hidden column after export to excel when table has less than 4 columns (SSRS)
excel, export-to-excel, reporting-services, ssrs-2008, ssrs-2012
Solution
Easy solution: Work in POINTS, not Inches or Centimeters. Excel renders in points, so this prevents all roundoff in positioning. It is that easy.
Problem
I faced following problem with exporting ssrs report to excel. When I create a table having 4 columns and then exporting it to excel I get the proper layout: But when I remove at least one of the column in ssrs designer (when table consists of less than 4 columns), after exporting it to excel, one column is being hidden: When I manually changed the width (by typing width in properties window) to at least 3 cm, after exporting it to excel the additional column disapeared (even if the table has less than 4 columns). Does anyone know why this happens? Any help will be appreciated.