Avatar of Auerelio Vasquez
Auerelio Vasquez
Flag 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....
SSRS

Avatar of undefined
Last Comment
Auerelio Vasquez

8/22/2022 - Mon
Megan Brooks

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.
ASKER CERTIFIED SOLUTION
irudyk

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
Megan Brooks

I don't recall having had that work for us. If it does, go for it.
irudyk

Also, forgot to mention that the text box(s) in the page header should also have the Properties | General | CanShrink set to True
I started with Experts Exchange in 2004 and it's been a mainstay of my professional computing life since. It helped me launch a career as a programmer / Oracle data analyst
William Peck
Auerelio Vasquez

ASKER
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 ?
irudyk

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.
irudyk

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
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
Auerelio Vasquez

ASKER
is that under alignment ? padding options ? that's the only places I see the words "Top" or "Bottom"
irudyk

For the textbox it would be under Properties | Location | Top
irudyk

The height would be under Properties | Size | Height
All of life is about relationships, and EE has made a viirtual community a real community. It lifts everyone's boat
William Peck
Auerelio Vasquez

ASKER
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
Megan Brooks

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).
Auerelio Vasquez

ASKER
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.
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.