[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1337
  • 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
Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

 
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

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

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