Regional Language setting Chinese (Hong Kong S.A.R.) is not working for Long date in SSRS report.

Regional Language setting Chinese (Hong Kong S.A.R.) is not working for Long date in SSRS report. by Vir14

Active

Type:	Bug
ID:	772455
Opened:	11/27/2012 10:22:10 PM
Access Restriction:	Public

Workaround(s)

view

User(s) can reproduce this bug

Working on SSRS 2008 R2. As per my requirement report should run as per regional setting (Number and date). I have used expression to run report as per regional setting is '=User!Language'. It is working for regional setting like English, French, Russian, Chinese (Taiwan) etc. but It is not working for Chinese (Hong Kong S.A.R.).

In Chinese (Taiwan), It display Long Date as 2012年11月5日 = (Monday, November 5, 2012).

In Chinese (Hong Kong S.A.R.), It display Long Date as Monday, 5 November, 2012 = (Monday, November 5, 2012).

It should display like 2012年11月5日.

SQL Server Collation : SQL_Latin1_General_CP1_CI_AS.

Details (expand)

English

SQL Server 2008 R2

Reporting Services

Windows 7 Professional (SP1)

US English

SQL Server 2008 R2.
reporting service : SSRS 2008 R2.
SQL Server Collation : SQL_Latin1_General_CP1_CI_AS

Steps :
1) Create report having at least one date field as Long Date in report Body.
2) Long Date field format of Report should work as per regional setting. Example. If English (US) : Monday, November 5, 2012, Chinese (Taiwan) : 2012年11月5日 etc.
3) Apply regional setting Chinese (Hong Kong S.A.R.)
4) See Long date field format of report. It is displaying Monday, 5 November, 2012.

Long Date field is displaying Monday, 5 November, 2012.

Long Date field should display 2012年11月5日.

0 attachments

Thank you for filing this connect case. .Net 3.5 has all localization stored in the DLL. In .Net 4.0 and 4.5, it looks at the OS to determine the datetime format for all localization information. In Reporting Services, we use .Net 3.5 and leverage what's stored in the .Net framework.
See below link for the datatime format for different version of .Net.
http://msdn.microsoft.com/en-us/goglobal/bb896001