Post reply

SSRS 2005

  • October 13, 2011 at 3:22 am

    #250074

    i have written this code,

    =iif(Parameters!Number_Format.Value=1,

    (iif(IsNothing(sum(Fields!sum_of_iss.Value))=True,"N.A.",(iif(Parameters!District_Code.Value="All Districts",Format(sum(Fields!sum_of_iss.Value)/10,"F2"),Format((sum(Fields!sum_of_iss.Value)/10)/2,"F2"))))),

    (iif(IsNothing(sum(Fields!sum_of_iss.Value))=True,"N.A.",(iif(Parameters!District_Code.Value="All Districts",Format(sum(Fields!sum_of_iss.Value)/10,"F6"),Format((sum(Fields!sum_of_iss.Value)/10)/2,"F6")))))

    )

    but it generates error (#ERROR) in the cell after viewing the report while the same code run in another cell for different field,but when we find total of those field it generates #ERROR.

    Please send me the valuable solution.THANKS

  • October 13, 2011 at 7:31 am

    #1394011

    What is the error?

  • October 15, 2011 at 8:16 am

    #1394962

    The error is #ERROR.This #ERROR is printed on textbox after viewing the report.Actually there is no error to run the report.After running the report ,the result in the total column is as #ERROR.

  • October 15, 2011 at 8:43 am

    #1394968

    Open the output window. The real error will be there.

Viewing 4 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply