Hidden column after export to excel when table has less than 4 columns (SSRS)

excel reporting-services ssrs-2008 export-to-excel ssrs-2012
Konrad Z. picture Konrad Z. · Dec 4, 2013 · Viewed 14.9k times · Source

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: enter image description here

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: enter image description here

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.

Answer

David F Mayer picture David F Mayer · Mar 5, 2015

Easy solution: Work in POINTS, not Inches or Centimeters. Excel renders in points, so this prevents all roundoff in positioning. It is that easy.

Related questions

SSRS 2008 R2 Globals!RenderFormat.Name=EXCELOPENXML

In an existing 2008R2 report, I have a concern about reports being exported to Excel. I have this concern since the result is related to the visibility of tablixes, columns, and rows based upon the export option chosen by the …

Read More
How can I unmerge cells in ssrs when exporting to excel to try to sort

I'm exporting an SSRS Report to Excel and when the user tried to sort it for some column. They got the message "This operation requires the merged cells to be identically sized. How can I generate the report in SSRS …

Read More
Exporting from SSRS to Excel with no headers

Is there a way to export to excel from an SSRS report so that the header that displays on the first page of the report is omitted only in the excel export? Currently, it adds a frozen frame to the …

Read More