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: 19 Apr 2024 at 12:59pm
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 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 |