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.

All Forums  Development Tools  Reporting Services Development  Summarize an expression

Author  Topic  Ashok_S Starting Member 5 Posts Posted - 2005-07-01 : 03:12:28 I have an expression with value =iif( (Fields!OverDueDays.Value - Fields!CrDays.Value) > 15 , (iif( ( Fields!OverDueDays.Value - Fields!CrDays.Value) <=30 , (Fields!Balance.Value), 0)) ,0) I want to sum this expression and place it in three group headers, If i use it again as an expression like =iif( (Fields!OverDueDays.Value - Fields!CrDays.Value) > 15 , (iif( ( Fields!OverDueDays.Value - Fields!CrDays.Value) <=30 , Sum(Fields!Balance.Value), 0)) ,0) or =Sum(iif( (Fields!OverDueDays.Value - Fields!CrDays.Value) > 15 , (iif( ( Fields!OverDueDays.Value - Fields!CrDays.Value) <=30 , (Fields!Balance.Value), 0)) ,0)) It is not coming right. How can i summarize this field in the groups. Urgent !! Regards. Rohini