Summarize expression

• Ashok-148808

  SSC Veteran

  Points: 217

  More actions

  July 1, 2005 at 1:16 am

  #165145

  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

   

   

• philcart

  SSC-Forever

  Points: 47796

  More actions

  July 1, 2005 at 1:24 am

  #570245

  Rather than referring to the fields in the dataset, use the ReportItems collection in the SUM.

  EG: Sum(ReportItems!Balance.Value)

   

  --------------------
  Colt 45 - the original point and click interface