July 11, 2012 at 5:24 pm
Hi.
I need you help in writing SSRS Expression which counts the Total Values from Start of Month(Date) and GetDate.
For Example:
=SUM(
IIF(Fields!rpt_date.Value = Parameters!RptDate.Value
And Fields!Mot.Value
Like "*In*", Fields!Total.Value, 0), "CoMethod"
)
I want that Fields!Total.Value to be the Start of Month(Date) and Parameters!RptDate.Value
Thanks.Arman
July 13, 2012 at 12:40 pm
Arman Khan (7/11/2012)
Hi.I need you help in writing SSRS Expression which counts the Total Values from Start of Month(Date) and GetDate.
For Example:
=SUM(
IIF(Fields!rpt_date.Value = Parameters!RptDate.Value
And Fields!Mot.Value
Like "*In*", Fields!Total.Value, 0), "CoMethod"
)
I want that Fields!Total.Value to be the Start of Month(Date) and Parameters!RptDate.Value
I'm not sure what you mean by "values". Could you clarify?
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply