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

Status : 

  Won't Fix<br /><br />
		Due to several factors the product team decided to focus its efforts on other items.<br /><br />
		A more detailed explanation for the resolution of this particular item may have been provided in the comments section.

Sign in
to vote
ID 772455 Comments
Status Closed Workarounds
Type Bug Repros 0
Opened 11/27/2012 10:22:10 PM
Access Restriction Public


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.
Sign in to post a comment.
Posted by Microsoft on 12/18/2012 at 4:01 PM
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.