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?

Improve company productivity with a Business Account.Sign Up

x
 
Josh_BladeConnect With a Mentor Author 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
 
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
What Kind of Coding Program is Right for You?

There are many ways to learn to code these days. From coding bootcamps like Flatiron School to online courses to totally free beginner resources. The best way to learn to code depends on many factors, but the most important one is you. See what course is best for you.

 
Josh_BladeAuthor Commented:
Is there any way to tell Excel to default to less then 100% for exported documents?
0
 
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:
This was the problem.
0
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.

All Courses

From novice to tech pro — start learning today.