Geek Answers Handbook

SSRS 2008 R2 export to Excel leaves blank line

In an existing SSRS 2008 R2 report, I want to modify the report so that users can hide the headers when exporting the report to Excel. By allowing users to hide the headers when exporting the SSRS 2008 report to Excel, they can sort and filter the data. This eliminates the possibility of displaying a pop-up error in Excel in a pop-up window that indicates the presence of a merged cell

My question is: when I hide the headers and export the report to Excel, an empty row appears before the data headers and columns appear in Excel. Basically, row number 1 in the cell is empty, and the data and column headers are displayed starting from column number 2.

So you can tell me how to remove the empty row in row # 1 when the data is exported to Excel?

+4
source share
3 answers

I believe that I was able to duplicate your problem. Make sure there is no space between the table and the report title. I believe setting the location tablix property to 0.0 is the best way to make sure there is no space. By removing the space, you should get the tablix headers as the first line in excel.

Here the article I wrote gave screenshots and step-by-step instructions.

http://jaysonseaverbi.blogspot.com/2013/11/ssrs-exporting-options-for-excel.html

+4
source

Use the rendering format in the expression to switch the visibility of the text field so that the title looks blank.

=iif(Globals!RenderFormat.Name = "EXCEL" ,  true, false

, EXCEL Excel 2003 (xls) EXCELOPENXML Excel 2007-2010 (xlsx), SQl 2012

0

0 , 0 , .

0
source

More articles:


All Articles