SSRS / Report Builder在工作日内处理(SSRS/Report Builder datediff in working days)

SSRS / Report Builder在工作日内处理(SSRS/Report Builder datediff in working days)

我在报告中有一个计算字段，它给了我两个字段之间的天数。 这是在日历天。

=则DateDiff（ “d”，菲尔兹！Date_Reported.Value，菲尔兹！EventDate.Value）

我被要求包括工作日的数量，我正在挣扎！

是否可以使用仅工作日计算这些字段之间的天数？ 例如。 这种情况周一到周五？ 预先感谢您的帮助。

I have a calculated field in my report that gives me the number of days between two fields. This is in calendar days though.

=DateDiff("d",Fields!Date_Reported.Value,Fields!EventDate.Value)

I have been asked to include number of working days and I'm struggling!

Is it possible to count the number days between these fields using only working days? eg. Monday to Friday in this case? Thanks in advance for any help.

最满意答案

尝试这个：

=datediff("ww",Fields!Date_Reported.Value,Fields!EventDate.Value, vbMonday) +datediff("ww",Fields!Date_Reported.Value,Fields!EventDate.Value, vbTuesday) +datediff("ww",Fields!Date_Reported.Value,Fields!EventDate.Value, vbWednesday) +datediff("ww",Fields!Date_Reported.Value,Fields!EventDate.Value, vbThursday) +datediff("ww",Fields!Date_Reported.Value,Fields!EventDate.Value, vbFriday)

^来源

Try this:

=datediff("ww",Fields!Date_Reported.Value,Fields!EventDate.Value, vbMonday) +datediff("ww",Fields!Date_Reported.Value,Fields!EventDate.Value, vbTuesday) +datediff("ww",Fields!Date_Reported.Value,Fields!EventDate.Value, vbWednesday) +datediff("ww",Fields!Date_Reported.Value,Fields!EventDate.Value, vbThursday) +datediff("ww",Fields!Date_Reported.Value,Fields!EventDate.Value, vbFriday)

^{The source}