SSRS Rendering format Excel Change ?

Question

Post reply

SSRS Rendering format Excel Change ?

feniss

SSC Enthusiast

Points: 112
More actions
July 16, 2022 at 10:00 am

#4064161

I was wondering if anyone knew how I can change the Excel rendering format in the reportserverconfig file
so the default cell format is text and not General. If not, is there any way to format my fields in the stored procedure so when I download to Excel it formats as text?
Thanks
August 22, 2022 at 11:35 pm

This was removed by the editor as SPAM
September 6, 2022 at 6:47 am

This was removed by the editor as SPAM

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

Site Owners SSC Guru Points: 80330 More actions · Answer 1

Thanks for posting your issue and hopefully someone will answer soon.

This is an automated bump to increase visibility of your question.

sgmunson SSC Guru Points: 110640 More actions · Answer 2

How about posting the solution so that everyone can benefit from the knowledge?

Steve (aka sgmunson) 🙂 🙂 🙂
Rent Servers for Income (picks and shovels strategy)

Lynn8968 Newbie Points: 8 More actions · Answer 3

Thanks to this article I can learn more. Expand my knowledge and abilities. Actually the article is very real.

Jeff Moden SSC Guru Points: 1004324 More actions · Answer 4

feniss wrote:

I was wondering if anyone knew how I can change the Excel rendering format in the reportserverconfig file
so the default cell format is text and not General. If not, is there any way to format my fields in the stored procedure so when I download to Excel it formats as text?
Thanks

Posting kinda late on this one but... have you tried encapsulating the item in double quotes?

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)