Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design
Message Icon Topic: Trying to combine two report values Post Reply Post New Topic
Author Message
shabbaranks
Groupie
Groupie


Joined: 06 Oct 2013
Location: United Kingdom
Online Status: Offline
Posts: 66
Quote shabbaranks Replybullet Topic: Trying to combine two report values
     Posted: 18 Sep 2015 at 1:02am
Hi,

Im trying to combine two report values based on their PO number for example:

PO        Supplier          Actual Cost
1234      ABC Ltd           £12
1234      ABC Ltd           £15
9876      Test Ltd          £2

Combining the two PO's 1234 and sum the value in the actual cost - any ideas please?

Thanks

IP IP Logged
niha
Newbie
Newbie
Avatar

Joined: 05 Jun 2015
Online Status: Offline
Posts: 28
Quote niha Replybullet Posted: 18 Sep 2015 at 2:22am
You can use two thing one is group concept and second one is suppress if duplicate

in second option for po field
right click on po filed and check the checkbox suppress id duplicated and
for actual cost
right click on actual cost filed-> insert-> running total in reset-> use formula
and write formula
like
{abc.po}=next{abc.po}

here abc. means store procedure or command name


IP IP Logged
shabbaranks
Groupie
Groupie


Joined: 06 Oct 2013
Location: United Kingdom
Online Status: Offline
Posts: 66
Quote shabbaranks Replybullet Posted: 18 Sep 2015 at 2:28am
Thanks worked a treat :)
IP IP Logged
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