asked on

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

lcohan

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.

ValentinoV

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)

Josh_Blade

ASKER

Is there any way to tell Excel to default to less then 100% for exported documents?

ValentinoV

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.

Josh_Blade

ASKER

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?

Nico Bontenbal

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.

ASKER CERTIFIED SOLUTION

Josh_Blade

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Josh_Blade

ASKER

This was the problem.