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!
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=10882
Printed Date: 29 Nov 2022 at 7:54pm


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
Smile
Hello everybody :)
i have records as
fdNo FDAMT ENCFDNO ENCAMT 
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.



Replies:
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.

www.sunoptique.com - Designer Sunglasses



Print Page | Close Window