格式化报告服务中的日期(Formatting Date in reporting services)

格式化报告服务中的日期(Formatting Date in reporting services)

我正在编写报告服务报告。 我想将报告的标题改为：

审核日志 - 2011年6月1日至2011年6月6日

目前我读它：

审核日志 - 06/01/2011至06/06/2011

我正在使用的表达方式是

="Audit Log - " + Parameters!DateStart.Value + " To " + Parameters!DateEnd.Value

我确信这很容易，我只是使用报告服务的新手。 我正在Visual Studio 2005中构建报告，如果它有所作为的话。

谢谢

I am building a report in reporting services. I would like the title of the report to read:

Audit Log - June 1, 2011 to June 6, 2011

Currently I have it reading:

Audit Log - 06/01/2011 to 06/06/2011

The expression I'm using is

="Audit Log - " + Parameters!DateStart.Value + " To " + Parameters!DateEnd.Value

I'm sure this is pretty easy I'm just fairly new to using reporting services. I'm building the report in visual studio 2005 if it makes a difference.

Thanks

最满意答案

使用Format()函数如下：

="Audit Log: " + Format(Parameters!DateStart.Value,"MMMM dd, yyyy") + " To " + =Format(Parameters!DateEnd.Value,"MMMM dd, yyyy")

Use the Format() function as follows:

="Audit Log: " + Format(Parameters!DateStart.Value,"MMMM dd, yyyy") + " To " + =Format(Parameters!DateEnd.Value,"MMMM dd, yyyy")