H4K (10/15/2012)

---

For 2nd table, what is the expression for showing year where error occurred ?

I mean there are 3 years from 2009 to 2011. So which of them are you trying to show in the year column ?

And also the sales values in 2nd table for those 3 years don't match with the 1st table ?

Tim Paulsen (10/17/2012)

---

I believe you are having a data type mismatch issue. The sales value is a decimal and specifying "0" is an integer. You should be able to change it to Sum(IIf(Fields!Year.Value > 2008 And Fields!Year.Value < 2012 , Fields!Sales.Value, 0.00)) or else explicitly cast both values such as Sum(IIf(Fields!Year.Value > 2008 And Fields!Year.Value < 2012 , CDbl(Fields!Sales.Value), CDbl(0))).

H4K (10/16/2012)

---

I don't know if it works or not. But you can try to create a calculated field with the 'iif' expression.

And include sum(new calculated field) into the textbox...

H4K (10/30/2012)

---

I think "0.00" did provide some part of the solution but you need to look for NULL's and handle them which is giving you the error, i guess.

Use the function IsNothing to handle NULL.=:

iif( IsNothing(Fields!Sales.Value), 0.00, Fields!Sales.Value)

Create a calculated field with the above expression.. just to check ...