Print Page | Close Window

total by specific table

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Report Design
Forum Discription: The best way to design a report and problems you have encountered
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=20858
Printed Date: 28 Apr 2024 at 7:22pm


Topic: total by specific table
Posted By: south
Subject: total by specific table
Date 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.


Replies:
Posted By: DBlank
Date 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

Posted By: south
Date 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

Posted By: DBlank
Date 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 


Print Page | Close Window