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

  • 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.

    Monday, December 10, 2012 12:44 PM

All replies

  • User-1716253493 posted

    What is TypeID datatype? Check if any leading space

    Try convert to number before compare it

    Monday, December 10, 2012 7:51 PM
  • 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. 

    Tuesday, December 18, 2012 1:52 PM
  • 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.


    Wednesday, December 19, 2012 1:14 AM