Tips and Tricks
 Crystal Reports Forum : Crystal Reports .NET 2003 : Tips and Tricks
Message Icon Topic: conditional addistion of field's value Post Reply Post New Topic
Author Message
vikas.sun
Newbie
Newbie
Avatar

Joined: 19 Aug 2010
Online Status: Offline
Posts: 3
Quote vikas.sun Replybullet Topic: conditional addistion of field's value
    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.
IP IP Logged
comatt1
Senior Member
Senior Member
Avatar

Joined: 19 May 2011
Online Status: Offline
Posts: 337
Quote comatt1 Replybullet Posted: 25 May 2011 at 5:10am
group by fdNo

create a running total to evaluate FDAMT and then reset by group.
IP IP Logged
sunoptique
Newbie
Newbie


Joined: 17 Jun 2011
Location: United States
Online Status: Offline
Posts: 1
Quote sunoptique Replybullet Posted: 19 Jun 2011 at 4:02am
Great post. I think I would make this pinned on my desktop to connect easily.

Designer Sunglasses
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.031 seconds.