Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 Development Tools
 Reporting Services Development
 Unicode characters in chart legend

Author  Topic 

micponc
Starting Member

2 Posts

Posted - 2009-05-20 : 11:54:07
Hello,

I have a report translated in Japanese. The report contains a chart and I would like the elements of the charts legend to be also in Japanese, but instead of my Japanese strings, I have ?????? displayed in the legend. What should I do to see my Japanese string in the legend? The OS of the report server is also in Japanese.

Thank you.

micponc
Starting Member

2 Posts

Posted - 2009-05-21 : 05:14:24
Hi,

If anyone needs this, I found the solution. The problem was in the sql query. I have a column name Color for which I defined a translated alias, so I can see the translation in the legend. The translated string which contains Unicode characters must have the N prefix. Like this: SELECT N'??? ???' AS Color
Go to Top of Page
   

- Advertisement -