SSRS Expression returning an #Error
Posted on 2013-06-10
Hi, I have this expression in the report header that takes the value from the first record in the main recordset and pops it into the report title. The problem is when NO records are returned by the main recordset, I get an error.
Maybe I've got this all wrong to begin with b/c it assumes records will be returned. What's the best way to handle no records in my report header expression?
="Total Number of Widgets: " & IIF(IsNothing(First(Fields!NbrOfWidgets.Value, "MainRecordset")), "0", First(Fields!NbrOfWidgets.Value, "MainRecordset").ToString)