[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1321
  • Last Modified:

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
0
Josh_Blade
Asked:
Josh_Blade
1 Solution
 
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
NEW Veeam Agent for Microsoft Windows

Backup and recover physical and cloud-based servers and workstations, as well as endpoint devices that belong to remote users. Avoid downtime and data loss quickly and easily for Windows-based physical or public cloud-based workloads!

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

Featured Post

How to Use the Help Bell

Need to boost the visibility of your question for solutions? Use the Experts Exchange Help Bell to confirm priority levels and contact subject-matter experts for question attention.  Check out this how-to article for more information.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now