CODEWITHSUNDEEP
reporting-servicesfontsssrs-2008-r2
Silvano Bini
Silvano Bini

Reputation: 23

Default Chinese Characters in SSRS

We use SSRS (2008 R2) to present data from several languages. We use labels with the Arial font. If the characters loaded from the database cannot be presented by Arial, SSRS converts them automatically to the relevant font that includes the special characters. It works well with several languages. However, with Chinese the default choice of SSRS is font MingLiu. This font is quite uncommon in mainland China and the locals say that it is unusable. I would like to use the SimSun font instead. How do I configure SSRS to force SimSun instead of MingLiu? Of course, I can create new labels with the SimSun font, but that will require recreation of all the existing reports that are already configured with Arial.

Thanks

Upvotes: 0

Views: 1728

Answers (2)

Sanushi Salgado
Sanushi Salgado

Reputation: 1436

Double click on the field value for which you want Chinese Characters in your table. It will display the Placeholder Properties window. Or else right click on the field value & select Placeholder Properties option. In the Placeholder Properties window under the General tab select 'HTML - Interpret HTML tags as styles' radio button. Click OK.

Placholder Properties window

Then open the code (XML) of the .rdl file. Add the <FontFamily>SimSun</FontFamily> tag under the <Style> tag of the relevant field value for which you want Chinese characters.

XML code

Finally close Report Builder & re-open it. Now it will display Chinese characters in the given field when the report is rendered.

Upvotes: 0

Silvano Bini
Silvano Bini

Reputation: 23

My boss found a solution to force the SimSun font:

  1. Each one of the report's Placeholder should be configured as HTML. This is done via the placeholder's properties / General, and then choose "HTML - Interpret HTML tags as styles" instead of the default "None - Plain text only"
  2. The value to be assigned to the placeholder should include the HTML tags to force the SimSun font. For example: <font face="SimSun">订单确认</font>

Upvotes: 2

Related Questions