Print Page | Close Window

conditional addistion of field's value

Printed From: Crystal Reports Book
Category: Crystal Reports .NET 2003
Forum Name: Tips and Tricks
Forum Discription: Have you learned some great tricks to share with the group? Post them here!
Printed Date: 24 Sep 2023 at 1:20pm

Topic: conditional addistion of field's value
Posted By: vikas.sun
Subject: conditional addistion of field's value
Date Posted: 19 Aug 2010 at 8:00am
Hello everybody :)
i have records as
101  100        1                40                      
102  500        2                400
101  100        3                60                      
102  500        4                100
         600                        600
i want 600 as summation of both the columns FDAMT and ENCAMT.
is it possible to sum the FDAMT field on unique FDNo field basis ???? 
thanks in advance.

Posted By: comatt1
Date Posted: 25 May 2011 at 5:10am
group by fdNo

create a running total to evaluate FDAMT and then reset by group.

Posted By: sunoptique
Date Posted: 19 Jun 2011 at 4:02am
Great post. I think I would make this pinned on my desktop to connect easily. - Designer Sunglasses

Print Page | Close Window