Why is my IIF expression in my RDLC report giving me an #Error

Asked Nov 16 '21 at 20:46

Active Nov 16 '21 at 20:46

Viewed 488 times

We have an RDLC report that needs to perform a calculation based on two values but before we do the calculation we want to check that the divisor is NOT zero. This is our expression:

=IIF(Fields!FundCatTotal.Value > 0, (ReportItems!tbfChangeAmt.Value/Fields!FundCatTotal.Value) * 100, 0)

The "True" part of the expression works fine. Its the "False" part that is giving us an issue. If the Fields!FundCatTotal.Value is not greater than zero the expression generates an #Error in the RDLC report. We are stumped as to why it would do that. The expression is a rather simple one but perhaps we are missing something.

Any ideas?

asked Nov 16 '21 at 20:46

PearsonJames

dupe of [VB.NET - IIF(,,) - Both "sides" are evaluated. What situations should I watch out for?](https://stackoverflow.com/questions/1220411/vb-net-iif-both-sides-are-evaluated-what-situations-should-i-watch-ou) et al. – underscore_d Nov 16 '21 at 20:55
i.e. if your divisor is zero, the division is still done, hence the error. use `if()` instead. – underscore_d Nov 16 '21 at 20:57
Is the IF() function available in an RDLC expression? I'm not seeing it. – PearsonJames Nov 16 '21 at 21:28
Not seeing it where? In what version of Report Builder or Visual Studio?? – underscore_d Nov 20 '21 at 12:36
We are using VS2019 Professional. In the expression builder for the RDLC report we do not see an option for IF(). Should it be there? – PearsonJames Nov 23 '21 at 14:39
I dunno. Type it manually and see if it works. – underscore_d Nov 23 '21 at 23:11

Why is my IIF expression in my RDLC report giving me an #Error

0 Answers0