SQL Server Performance

Working with fields already in my SSRS 2005 report

Discussion in 'SQL Server Reporting Services' started by dba123, Feb 1, 2006.

  1. dba123 New Member

    In my SSRS 2005 Report I have 5 calculation fields added to my table Group and they are:

    =IIf(Fields!New_Old_CC.Value = 0, Fields!PDC.Value, 0) (the Label is Field1)

    =IIf(Fields!New_Old_CC.Value = 1, Fields!PDC.Value, 0) (the Label is Field2)

    =IIf(Fields!New_Old_CC.Value = 0, Fields!CC.Value, 0) (the Label is Field3)

    =IIf(Fields!New_Old_CC.Value = 1, Fields!CC.Value, 0) (the Label is Field4)

    =Fields!FeeGoal_AZ.Value Fields!FeeSchedule.Value (the Label is Field5)

    I want to take SUM(Fields 1-4) Field 5. Is there a way to reference fields already in your report that you added earlier?



    I tried to do this also below but it doesn't work:

    =SUM(IIf(Fields!New_Old_CC.Value = 0, Fields!PDC.Value, 0) + IIf(Fields!New_Old_CC.Value = 1, Fields!PDC.Value, 0) + IIf(Fields!New_Old_CC.Value = 0, Fields!CC.Value, 0) + IIf(Fields!New_Old_CC.Value = 1, Fields!CC.Value, 0)) – (Fields!FeeGoal_AZ.Value Fields!FeeSchedule.Value))

Share This Page