Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2020 : Report Design
Message Icon Topic: total by specific table Post Reply Post New Topic
Author Message
south
Groupie
Groupie


Joined: 31 Jul 2012
Online Status: Offline
Posts: 82
Quote south Replybullet Topic: total by specific table
    Posted: 01 Jul 2014 at 8:35am
I would like to have my report show total hours allotted to each center.  Example:
Center 1          1.5 hours
Center 2          1.0 hours
Center 3           0.5 hours
I am able to have the report show me each center but it gives me the total hours 3 instead of the total for that specific center.


Edited by south - 01 Jul 2014 at 8:43am
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 02 Jul 2014 at 3:38am
group on center and insert the summary at the group footer level
or is you want these in a report header or footer use a crosstab with the center as the grouped on row field and the hours as teh summarized field
IP IP Logged
south
Groupie
Groupie


Joined: 31 Jul 2012
Online Status: Offline
Posts: 82
Quote south Replybullet Posted: 02 Jul 2014 at 5:02am
I'm probably not explaining it very well.  I already have it grouped on center, I wanted to select a center and have it list each of the hrs by name. My report should look like
Center 1
name            hrs (for that specific center)
Steve             1
Mike               2

What I get is either 1(I added the hrs table as a subreport):
Center 1
name             hrs
Steve              1
                       3 (this is for center 3 and shouldn't be listed)
Mike                2
                       1 (this is center 2)
or 2 (this is when the table was just added to the actual report):
Center 1
name            hr
Steve            4
Mike              3



IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 02 Jul 2014 at 7:40am
how are you joining the hours table to the centers table.
What youar edescribing sounds more like an issue iof you finding the proper way to join the tables than a formula fix 
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.