SSRS 2012: Can column headers be different between preview and Export to Excel?

Hello Experts

(I think the answer is 'no', but it's Monday and I have an unlimited number of points to give away, so I'll throw this out anyways.)

I have various SSRS 2012 report users that would like to see column headers cosmetically perfect in Preview mode, but when exported to Excel changed to a format that is less so, such as all caps, underscores instead of spaces.

Q:  In SSRS can I change column header text between preview and Export to Excel?
LVL 66
Jim HornMicrosoft SQL Server Developer, Architect, and AuthorAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

ValentinoVBI ConsultantCommented:
Hey Jim,

I think that should be possible by using the Globals!RenderFormat.Name property.  You could build an expression for each header, when exporting to Excel it should be equal to 'EXCEL'.

I wrote an article about that property a while ago btw: Hide/Show Items Dependant On Export Format (SSRS)


Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Jim HornMicrosoft SQL Server Developer, Architect, and AuthorAuthor Commented:
That worked, but for 2012 instead of 'EXCEL' it's 'EXCELOPENXML', so you'll want to make a quickie edit to the article.
ValentinoVBI ConsultantCommented:
Ow right, that's indeed a new renderer to support the XLSX format!  Thanks Jim, noted down on my TODO list :)
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.