SSRS 2008 R2 export to Excel leaves row one as blank

reporting-services ssrs-2008 ssrs-grouping
user1816979 picture user1816979 · Nov 13, 2013 · Viewed 15.2k times · Source

In an SSRS 2008 R2 existing report, I want to change the report so the users have the option to hide headers when they export the report to excel. By allowing the users to hide headers when they export the SSRS 2008 report to excel, they can sort and filter the data. This avoids allowing excel to display an error in a popup window saying there are merged cell.

My question is when I hide the headers and export the report to excel, there is a blank line in excel before the data and column headers appear. Basically row # 1 in cell in blank and data and column headers show up starting in column #2.

Thus can you tell me how to remove the blank row in row #1 when the data is exported to excel?

Answer

jaysonseaver picture jaysonseaver · Nov 13, 2013

I believe I have been able to duplicate your issue. Be sure that there is no space between your table and the report header. I find that setting the location property of the tablix to 0,0 is the best way to ensure that there is no space there. By removing the space, you should get your tablix headers as the first row in excel.

Here's an article I wrote giving screen shots and step-by-step instructions.

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

Related questions

How to sum the Group totals only?

I'm trying to sum only group HourTarget totals. 7:00 8:00 HourTarget Line 1 2715 1008 3224 A 2307 1008 3224 B 408 0 3224 Line 2 2308 2432 2656 A 2308 2432 2656 Line 3 2318 1622 2800 A 345 1258 2800 B 762 0 2800 C 1211 364 2800 I'm trying to achieve 8680 as a result of sum of HourTarget. But I'm getting 17504. It is because HourTarget in a database table …

Read More
How to create a report with sections and page breaks using SSRS

I'm trying to create a report that looks like this: using a select from this table: (fiddler here for query and data) CREATE TABLE StudentData ( id int PRIMARY KEY IDENTITY, name varchar(30), subject varchar(30), currentGrade varchar(2), targetGrade varchar(2), note1 varchar(100), …

Read More
Is it possible to create a row that spans all columns of a Matrix in SSRS 2008?

Is it possible to have add a row to an SSRS 2008 Matrix that spans all of the matrix's columns? This crude diagram shows roughly what I'm looking for: The basic idea is that each line item is a person, and …

Read More