Expression - IF - Is Null
Hi, I'm trying to call a method with a null value in IF statement: =Iif(IsNothing(Sum(Fields!BuildTypeInt.Value, "TestExecutions")),"Not Defined",Enums.Parse.IntValueToString(Sum(Fields!BuildTypeInt.Value, "TestExecutions"))) I mean, I need to call the method only if the value is not null, But, I can see that even if the value is null the expression looks at Enums.Parse.IntValueToString(Sum(Fields!BuildTypeInt.Value, "TestExecutions")) and returns #Error. Can you please help me solve this issue? Regards, Bader
August 26th, 2012 9:25am

Hi Bader, Could you please describe the expression "Enums.Parse.IntValueToString(Sum(Fields!BuildTypeInt.Value, "TestExecutions")" with more detail? In Reporting Services, we can use custom code references in expressions. For more information, please see: http://msdn.microsoft.com/en-us/library/ms155798(v=sql.100).aspx Regards, Bin Long TechNet Subscriber Support If you are TechNet Subscriptionuser and have any feedback on our support quality, please send your feedback here. Bin Long TechNet Community Support
Free Windows Admin Tool Kit Click here and download it now
August 29th, 2012 6:50am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics