Technical Questions
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Technical Questions
Message Icon Topic: Adding columns Post Reply Post New Topic
Author Message
louisville2k10
Groupie
Groupie
Avatar

Joined: 13 Sep 2010
Location: United States
Online Status: Offline
Posts: 45
Quote louisville2k10 Replybullet Topic: Adding columns
    Posted: 30 Sep 2010 at 3:37am
When I select two months, my report gives me two rows of data for each person working. For an example, for August and September 2009, I get:
 
Name                Calls          Hours Worked            Expense
Joe Smith           1155                 140                        $1400
Joe Smith           1176                 145                        $1450
 
I want to add each row within each column together, rather than break them up. So, I am looking to make it a single row of data, like:
 
Name                 Calls          Hours Worked             Expense
Joe Smith            2331                  285                        $2850
 
Any recommendations?
 
Thanks for your help!
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 30 Sep 2010 at 4:22am
group on the name
do summaries of each column at group footer 1 level.
place all on the group footer and suppress the details and header sections (if desired)
IP IP Logged
louisville2k10
Groupie
Groupie
Avatar

Joined: 13 Sep 2010
Location: United States
Online Status: Offline
Posts: 45
Quote louisville2k10 Replybullet Posted: 30 Sep 2010 at 5:41am

This doesn't seem to work because I have multiple users that are displayed (in addition to John Smith).

For example, I have...
John Smith       DataX1
John Smith       DataY1
Jane Doe          DataX2
Jane Doe          DataY2
 
And I want...
John Smith        DataX1+DataY1
Jane Doe          DataX2 + DataY2
 
I don't see how I can sum it all into a single footer and suppress the repeated columns (as was suggested) when there are multiple agents listed...please correct me if I am wrong. Confused
Thanks for your help!
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 30 Sep 2010 at 5:49am
You have to group on the name field first so it sticks all of one workers rows togther then you can sum for each sepecific worker on the group footer
like this:
GH1   - John Smith
Detail - Joe Smith           1155                 140                        $1400
Detail - Joe Smith           1176                 145                        $1450
GF1    - Joe Smith            2331                  285                        $2850
IP IP Logged
louisville2k10
Groupie
Groupie
Avatar

Joined: 13 Sep 2010
Location: United States
Online Status: Offline
Posts: 45
Quote louisville2k10 Replybullet Posted: 30 Sep 2010 at 6:00am

DBlank, you are a man of genius.

 
Much appreciated.Clap
Thanks for your help!
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.