Exporting to Word and then modifying the report uses wrong font

Question

HI,

I have created an Invoice report that has Several tables and tex boxes, including  two place holder textboxes. The font on all of these is Arial 9. I have this same font set as my default in MS word 2010. Now I run the rerpot and export the report from Reporting Services 2008. If I attempt to add additional content in the 'placeholder' textbox it defaults to Times New Roman 10. Is there a way to have this default to Arial 9?

Thanks,

Trish

---

Trish Leppa

Answer 1

Hi There

Thanks for your posting. Can you please have a look on these links that might help you

http://marcbeacom.wordpress.com/2007/07/15/sql-server-reporting-services-ssrs-templates-and-styles/

http://social.msdn.microsoft.com/Forums/is/sqlreportingservices/thread/cc34b3a1-2029-4a20-a671-99393e3121c5

Many thanks

Syed Qazafi Anjum

Answer 2

Hi Trish,

According to your reply, I have tried to reproduce the issue in my test environment; however, everything goes well.

Supposing that there is a textbox containing more than one placeholder and different placeholders have different fonts. Based on my test, after we export the report to Word format, and open the Word document to add text in the textbox, the font format of the text will inherit that of the placeholder in front of it. In that case, I suggest you make sure the fonts of all the placeholders are set to “Arial 9”. Simply, we can uniform the placeholders’ fonts by setting the font of the textbox. 

In addition, if the textbox or the placeholder in the textbox is blank, it does not inherit the font you have set in Report Designer. To work around the issue, we can insert a space in the textbox or set the value of the placeholder to =" ".
(Note: The value of the placeholder includes a space in the expression.)

If the issue persists, please capture a screenshot of the issue for further analysis.

Regards,
Fanny Liu

---

Fanny Liu

TechNet Community Support