SSRS Text formatting when exporting to excel

Posted on 2012-03-13
Medium Priority
Last Modified: 2012-06-27
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?
Question by:Josh_Blade
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
LVL 40

Expert Comment

ID: 37717148
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.
LVL 37

Expert Comment

ID: 37718659
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)

Author Comment

ID: 37719451
Is there any way to tell Excel to default to less then 100% for exported documents?
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

LVL 37

Expert Comment

ID: 37719620
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.

Author Comment

ID: 37720089
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?
LVL 22

Expert Comment

by:Nico Bontenbal
ID: 37731045
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.

Accepted Solution

Josh_Blade earned 0 total points
ID: 37754047
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.

Author Closing Comment

ID: 37770420
This was the problem.

Featured Post

Get MongoDB database support online, now!

At Percona’s web store you can order your MongoDB database support needs in minutes. No hassles, no fuss, just pick and click. Pay online with a credit card. Handle your MongoDB database support now!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article describes a serious pitfall that can happen when deleting shapes using VBA.
It is possible to export the data of a SQL Table in SSMS and generate INSERT statements. It's neatly tucked away in the generate scripts option of a database.
Viewers will learn how the fundamental information of how to create a table.
This Micro Tutorial demonstrates how to create Excel charts: column, area, line, bar, and scatter charts. Formatting tips are provided as well.

800 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question