How to show chinese characters in rdl report in C# ?

Question

0.00/5 (No votes)

See more:

, +

I want to display chinese characters in report (rdl) in C#. I am getting the text from database and showing the same on report.
in database, I can see the chinese characters properly without any issue but they are not getting rendered on UI.

On UI, I can see garbage characters instead of chinese.

Appreciate help here !!

What I have tried:

I added below code in rdl where I want to see chinese text but it didn't help.

<FontFamily>SimSun</fontfamily>
<FontSize>9pt</fontsize>

Also, I set the the placeholder properties as "HTML - Interpret HTML tags as styles"

Posted 15-May-23 3:01am

Member 9346617

Add a Solution

Comments

mtoha 17-May-23 17:27pm

As far as I know, Your custom fonts should be installed on Operating System (eg : Windows),
Have you install SimSun font?

Member 9346617 18-May-23 1:02am

Yes. In control panel, I can see that SimSun font was already installed.
Even I tried adding the chinese language in browser but still no luck.
Appreciate your thought on this.

mtoha 18-May-23 1:38am

have you succeed to save chinese characters on database? Sometimes, if SQL Server and some databases failed to detect encoding, the characters saved it to unreaded characters. if you debug it, when characters loaded from SQL server, is it on correct chinese format?

Member 9346617 18-May-23 6:01am

Thanks for your reply.
I have taken the datatype of column as "nvarchar" and I can save chinese characters properly in database. I can also retrieve them very well. But while showing it on rdl report, it's showing as "?????"
I tried setting the language of the designer under Localization as "zh-CN" and also set the same language for the text box but still it didn't help me.

mtoha 18-May-23 6:10am

If you see the designer, try to check the Font. Like my picture at answer. The Font Type is SimSun. Previously, the default is Arial

Member 9346617 18-May-23 6:40am

Yes. I have already set it to SimSun.

mtoha 18-May-23 1:48am

can you add picture and codes how you make components on your report?

Are you using RDL or RDLC?
If you use RDL, I read from this site, it is can add component and use Style block to modify FontStyle.
https://www.grapecity.com/blogs/how-to-create-rdl-report-net-c-sharp-code#Creating_an_RDL_report

Like this:
customerFooter[0].ReportItems.Add(new GrapeCity.ActiveReports.PageReportModel.TextBox()
{
Name = "Company Name",
Value = "=\"Total Customer Count: \" & CountRows()",
Style = {
VerticalAlign ="Middle",
PaddingLeft="3pt",
TextAlign = "Left",
FontWeight = "Bold" }
});

If you giving up about this case, consider to move to RDLC format. it is easier to modify from UI designer set the FontStyle by UI. Like my program shown

Member 9346617 18-May-23 6:13am

<textbox name="textbox3">
<cangrow>true
<canshrink>true
<keeptogether>true
<paragraphs>
<paragraph>
<textruns>
<textrun>
<value>=Fields!value.Value
<markuptype>HTML

<FontFamily>SimSun</fontfamily>
<FontSize>9pt</fontsize>
<Language>zh-CN</language>

</paragraph>
</paragraphs>
<Style>
<PaddingLeft>4pt</paddingleft>
<PaddingRight>6pt</paddingright>
<PaddingTop>4pt</paddingtop>
<PaddingBottom>4pt</paddingbottom>

This is how I am adding the text box and setting it's properties.

mtoha 18-May-23 6:30am

I would recommend you change report type to RDLC format. Instead of RDL
This code is painful. RDLC has report designer, you can use report viewer too.
This case is like when I am forgotten to install Font, and the characters being ???????.
Or when I use RDLC to show barcode, if I forgotten to install font, the barcode is not showing.

Is this happened to client or at server? If this is happened to all Computers, maybe bugs.

1 solution

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

mtoha · Answer 1 · 2023-05-17T15:52:00

Solution 1

At my case, you should install chinese keyboard, to type chinese characters.

At textbox at RDLC, you can select SimSun font. Like this picture

https://live.staticflickr.com/65535/52906143304_e0f58c375e_b.jpg[^]

After I generate the report, the chinese characters is showing well.

Posted 17-May-23 15:52pm

mtoha

Updated 17-May-23 17:58pm

v2

How to show chinese characters in rdl report in C# ?

1 solution

Solution 1

Add your solution here

Preview 0

How to show chinese characters in rdl report in C# ?

1 solution

Solution 1

Add your solution here

Preview 0

Existing Members

...or Join us