CODEWITHSUNDEEP
vb.netreporting-servicesreport
Kres
Kres

Reputation: 58

c# report returns #error

I get #Error in reportviewer when I use the following expression:

    =IIf(Fields!PaymentNumber.Value>0,
         IPmt(Fields!Annual_Interest_Rate.Value/1200,
              Fields!Payment.Value,
              Fields!No_of_Monthly_Payments.Value,
              Fields!Total_Amount_Financed.Value),0)

When I remove the IPmt() function and use some static value instead, it works. Is there a way to find out the exact error ?

Upvotes: 0

Views: 1593

Answers (3)

Chris Latta
Chris Latta

Reputation: 20560

Based on the equation used to calculate an annuity I'd say you are passing either 0 for the number of periods per year or 0 for the interest rate and thus getting a divide by zero error.

You are checking that PaymentNumber is greater than zero, but PaymentNumber is not used in your IPmt calculation so maybe you are using the wrong field in the calculation?

Anyway, regardless of that, you need to be aware IIF is not a statement, it is a function that gets passed two parameters. Therefore those two parameters are evaluated prior to the function call and thus BOTH sides of the "if statement" get evaluated. This can be confusing because you will still get divide by zero errors when you are checking your divisor is non-zero. Just remember it is a function, not a statement, and so there is no short-circuit evaluation to prevent the erroneous part from being executed. However, there are workarounds, mostly involving doing two IIF calls to remove the zero value from being used in the division calculation:

=IIF(Fields!DivideBy.Value <> 0, Fields!Something.Value / IIF(Fields!DivideBy.Value <> 0, Fields!DivideBy.Value, 1), 0)

Upvotes: 1

Jamie F
Jamie F

Reputation: 23789

'IIF' in SSRS does not have short-circuit evaluation. Make sure that when you call this function, even when PaymentNumber is 0 or less, that you have valid values for IPmt().

Several workarounds are possible:

Upvotes: 0

Sir Crispalot
Sir Crispalot

Reputation: 4844

It's not particularly easy to debug #Error in Reporting Services.

In my experience, the best way is to break it down into its component parts and see if any of those are the problem. You've already narrowed it down to the IPmt function which is expecting to be passed four Double parameters.

Have you checked that the four parameters you're passing in all have values and are of the correct type?

Upvotes: 0

Related Questions