Filter failing?

Question

Hello,

I have the folloiwing on tablix1

Expression = 

=CDate(IIF(Fields!SCOMDate.Value

is nothing,IIF(Fields!IPDate.Value is nothing,IIF(Fields!HPSIMDate.Value is nothing,IIF(Fields!DCWalk_Date.Value is nothing,IIF(Fields!FCSDate.Value is nothing,IIF(Fields!Legato_Date.Value is nothing,IIF(Fields!DPMDate.Value is nothing,IIF(Fields!Veeam_Date.Value is nothing,IIF(Fields!Ex_DBDate.Value is nothing,IIF(Fields!Ex_User_DBDate.Value is nothing,IIF(Fields!PWScript_Date.Value is nothing,IIF(Fields!SCCMDate.Value is nothing,IIF(Fields!Storage_Date.Value is nothing, Fields!Storage_Date.Value, Fields!Storage_Date.Value),Fields!SCCMDate.Value),Fields!PWScript_Date.Value),Fields!Ex_User_DBDate.Value),Fields!Ex_DBDate.Value),Fields!Veeam_Date.Value),Fields!DPMDate.Value),Fields!Legato_Date.Value),Fields!FCSDate.Value),Fields!DCWalk_Date.Value),Fields!HPSIMDate.Value),Fields!IPDate.Value),Fields!SCOMDate.Value))

TEXT

OPERATOR: >

Value =

=DateAdd(Day(CDate(Fields!Date_Result.Value)),-1*Weekday(Today()),Today())

Error	1	[rsCompilerErrorInExpression] The FilterValue expression for the tablix ‘table1’ contains an error: [BC30519] Overload resolution failed because no accessible 'DateAdd' can be called without a narrowing conversion:	C:\Users\dominiqued\Documents\Visual Studio 2008\Projects\Report Project1\Report Project1\Report on Daily Maintenance Tasks-Weekly.rdl	0	0	

ThanksDom

---

System Center Operations Manager 2007 / System Center Configuration Manager 2007 R2 / Forefront Client Security / Forefront Identity Manager

Answer 1

Hi,

I can see one issue with your Dateadd() method. Give a try to following expression and give more details about the use of weekday() method in your expression.

=DateAdd("d",Day(CDate(Fields!Date_Result.Value)),Today())

 Please refer this link for syntax of the dateadd method

http://msdn.microsoft.com/en-us/library/aa337194(v=sql.90).aspx

---

Aftab Ansari

Answer 2

Hello,

I am not sure this will give me what I need, the report to be limited to the last 7 days... (-1*WeekDay(Today)), is it possible?

This formula applied in the Tablix > Filter is giving me the same result as before no fileter at all...

Thanks,

Dom

---

System Center Operations Manager 2007 / System Center Configuration Manager 2007 R2 / Forefront Client Security / Forefront Identity Manager