SQL报告服务报告未正确显示日期 [英] SQL reporting services report not showing date in correct format

问题描述

我已经在SQL Server 2005上构建了一个报表服务报告，并且无法使日期在一个独立的文本框中正确格式化。

i have built a reporting services report off SQL server 2005 and am having trouble getting the date to format correctly in a stand-alone textbox.

我的代码是使用如下：

="Date: " & FormatDateTime(Parameters!date.Value, 2))

- 根据MSDN，系统文化设置为2，但不是。

-- According to MSDN it should work off my systems culture when set to '2' however it is not.

目前正在显示= MMDDYYYY，
想要显示= DDMMYYYY

Currently being displayed = MMDDYYYY, Want to display = DDMMYYYY

有谁知道我在做错什么？

Does anyone know what i am doing wrong?

推荐答案

报告有自己的国际化设置 - 他们不使用系统。

The reports have their own Internationalisation settings - they don't use the systems.

打开报告属性页面（单击报告的空白区域，然后选中属性面板），然后查看语言设置。它将设置为英语（美国）。将其设置为 =用户！语言，使其符合用户的区域设置。

Open your report Properties page (Click on the blank area of the report and check the Properties panel) and look at the Language settings. It will be set to English (United States). Set it to =User!Language to make it respect the user's regional settings.

这篇关于SQL报告服务报告未正确显示日期的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！