Working with fields already in my SSRS 2005 report | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Working with fields already in my SSRS 2005 report

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))
]]>