SSRS Text formatting when exporting to excel

I am having problems when I export files from SSRS to Excel.   All of the text sizes are off in the one i get from SSRS.   I am compairing it to a report that was written in excel before I started creating these reports.  When you look at the text side by side the one from ssrs is bigger though it is only 10 point font and the one that was created in Excel is 12 point font.  I have attached files screenshots of what I am talking about.

Is there just a problem with exporting from ssrs?
myReport.PNG
TheirReport.PNG
Josh_BladeAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

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

lcohanDatabase AnalystCommented:
You can adjust the fond on that column or columns properties if you edit the SSRS report in BI then save it. As far as I'm aware export to excel inherits properties from the report you see on screen but in my opinion this must not be an issue as the client can change the fonts in excel easily after they export.
0
ValentinoVBI ConsultantCommented:
So you're saying that Times 10 points displays larger than Times 12 points, right?  Are you sure the zoom level in both sheets is equal?  It's the slider at the bottom-right corner. (Excel 2007/2010)
0
Josh_BladeAuthor Commented:
Is there any way to tell Excel to default to less then 100% for exported documents?
0
Acronis Data Cloud 7.8 Enhances Cyber Protection

A closer look at five essential enhancements that benefit end-users and help MSPs take their cloud data protection business further.

ValentinoVBI ConsultantCommented:
I don't think that's possible.  The only option that I see is changing the font size in the report.  Or changing the zoom level once the report is exported.
0
Josh_BladeAuthor Commented:
The main problem is that I am trying to get the report to print to one page.  The zoom really doesn't play into printing at all.  In order to get it to the same text size that they have in the report which Excel says it 12 point font is to make it 8 point in SSRS and then expoort and it comes out close to what they have.  That is what I'm trying to figure out.  Is there a reason for this?
0
Nico BontenbalCommented:
I never noticed this. I always thought MS did a wonderful job to create an Excel sheet that looks exactly like my SSRS report. What version of SSRS are you using? Can you create a sample report, without data but only a few captions, that has this strange behavior. If you can upload this report here we can all make sure we are talking about the same thing.
0
Josh_BladeAuthor Commented:
Apparently the reports that were manually created had Fit To Page turned on so it was auto shrinking stuff. No one told me this and I didn't think to check for a long time.
So the SSRS exports were fine the whole time, it was what I was comparing them to that was goofy.
0

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
Josh_BladeAuthor Commented:
This was the problem.
0
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
SSRS

From novice to tech pro — start learning today.