Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
dba123
Yak Posting Veteran
90 Posts |
 Posted - 2006-02-01 : 14:58:09
|
| 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)) |
|
|
|
|
|
|
|
Working with fields already in my SSRS 2005 report