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 ...
I added the suggestion above and I got the same results 🙁
I need to get this report finished so I just modified my query. I added this line to my select statement:
SUM(CASE WHEN YEAR(INVOICEDATE) > 2008 AND YEAR(INVOICEDATE) < YEAR(GETDATE()) THEN LINEAMOUNT ELSE 0 END) AS 'Past Sales'