Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design
Message Icon Topic: How to sum based on two fields Post Reply Post New Topic
Author Message
kenh426
Newbie
Newbie
Avatar

Joined: 08 Oct 2007
Location: United States
Online Status: Offline
Posts: 7
Quote kenh426 Replybullet Topic: How to sum based on two fields
    Posted: 08 Oct 2007 at 6:23am

I need to sum a value based on date and a paycode. Example: An employee works on the 19th (Field: ApplyDate) and works 6hrs of Regular (Field: Paycode) and then works two more hours of Regular on the same day. Ia m trying to sum the 6 and the 2 based on date and paycode.

 

Currently in the Table:

09/10/2007 6hrs Regular
09/10/2007 2hrs Regular
 
I want the report to show
09/10/2007 8hrs Regular
Ken Hamilton
IP IP Logged
socrates
Newbie
Newbie
Avatar

Joined: 20 Mar 2007
Online Status: Offline
Posts: 15
Quote socrates Replybullet Posted: 08 Oct 2007 at 6:44am
insert two groups based on applydate and regular and in the
group-footer2 insert sum(paycode)  and supress detail sections  Smile
IP IP Logged
kenh426
Newbie
Newbie
Avatar

Joined: 08 Oct 2007
Location: United States
Online Status: Offline
Posts: 7
Quote kenh426 Replybullet Posted: 08 Oct 2007 at 8:44am
Thank you very muh that worked. I have another question if I wanted to throw another group in there for a third one how would i do that. Example:
 
The employee worked on 09/13/2007 (Field: ApplyDate), 2hours in regular(Field: Paycode) and 2hours regular in Non-Productive (Field: LL6) group should look something like this:
 
09/13/2007  Regular Productive         2.00
09/13/2007  Regular Non-productive  2.00
 
Any info would be greatly appreciated!
 
Thank You!
Ken
Ken Hamilton
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.016 seconds.