SSRS returns data after database query had the data retrieved but not in report

Question

User-1510915226 posted

I am actually in a bit of a hassle trying for a couple of hours to figure why the SSRS report is not returning anything for the Manager Proceeds which got an expression as :

FormatCurrency(iif(Fields!TypeID.Value = 226, Fields!Amount.Value, 0))

This returns the Amount if the TypeID=226  else it brings the value $0.00

Note: The error in this is that it brings $0.00 even if the TypeID=226.

The non 226's are correct bringing the correct data. Why is it doing it this to me?

Help Please.

Answer 1

User-1716253493 posted

What is TypeID datatype? Check if any leading space

Try convert to number before compare it

Answer 2

User-1510915226 posted

I found it is a decimal and therefore had made the changes to the expression for the textbox that displays ManagerProceeds field as:

=FormatCurrency(Sum(CDec(Fields!ManagerProceeds.Value))) . this did not work at all. 

Answer 3

User-830595639 posted

Try comparing your field as character like the following

IIF(Fields!TypeID.Value = '226',yourfields,0) or convert the TypeID field to integer.

Also you can check by taking the TypeID value in your table that whats the value its returning while you selected 226.