Link to home
Start Free TrialLog in
Avatar of Auerelio Vasquez
Auerelio VasquezFlag for United States of America

asked on

Removing Headers from report before exporting to Excel

Is there a way to remove the merging and headers before exporting to excel ? what's happening, is that when exporting, the excel is doing some weird merging with the headers and columns.

All I really want to export is the column names and data. OR maybe i'm doing something wrong with the headers....
Avatar of Megan Brooks
Megan Brooks
Flag of United States of America image

This is an issue that I had to deal with repeatedly over the years, from RS 2005 to RS 2012, and I can't say that I ever found a particularly good solution for it. You can end up with column splits and merges that complicate use of the spreadsheet, and may not even render correctly in some situations.

If you have your own front end UI for the reports then you can launch a "headerless" version of the RDL when exporting to Excel. You could conceivably produce that RDL automatically from the normal version using XSLT or code, as a post-build step, although I never went that far. I even thought about rendering the header as an image. But for the most part we just passed it on to the customer as it was.
Avatar of irudyk
Flag of Canada image

Link to home
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
I don't recall having had that work for us. If it does, go for it.
Also, forgot to mention that the text box(s) in the page header should also have the Properties | General | CanShrink set to True
Avatar of Auerelio Vasquez


This solution almost works! I got rid of the header, and I know this is nitpicky, but this is what my users complained about. They want the column headings to start at row one, it looks there is a tiny bit of white space, between the tablix and header..... So the column headers start on row 2. Know if there is a way around that ?
Okay. Say there is one text box within the page header. If that is the case, set the top of the text box = 0 and the height of the text box = the the height of the page header.
If the height of the text box = the height of the page header, then the gap exists with the page where the tablix is.  In that case, ensure the the top of the tablix = 0
is that under alignment ? padding options ? that's the only places I see the words "Top" or "Bottom"
For the textbox it would be under Properties | Location | Top
The height would be under Properties | Size | Height
So, close, i'll award the points, but it still starts on row 2..... Thre is so little white space now, I can't even delete it lol
You might have to disable the header area in the RDL to get rid of that. Still, you fared better than I did (given that my employers didn't want me to spend any time on the problem).
This was a request from the customer, so I have to try and figure it out. But it's much better than before, being that all they have to do is delete one row, and not have to worry about all the merged columns.