Trying to create a Report Totals page/fields 1

[klkuab]

I'm a newbie using Crystal Reports 10. I am in the process of creating a report and have come across an issue that has stumped me.

My report needs to consist of 2 parts. The first part being the detail lines which is working fine, and the second part being the report totals page which is where i am stumped.

Here is an example of what I am trying to do:

<these are the detail lines, each dept prints on a new page, the values are hours worked etc, the DEPT is a group and the Jobs are grouped also in order to get the data summarized>

DEPT 1
Job 1 1.00
Job 2 3.00
Job 3 1.00

DEPT 2
Job 1 2.00
Job 3 4.00

at the end of the report, i am wanting to generate a report total that would look like:

JOB TOTALS
Job 1 3.00
Job 2 3.00
Job 3 5.00

Any advice would be appreciated. Thanks!

 

[kskid]

Create a subreport and group on Job only. Then insert a count by job

 

[lbass]

Insert a crosstab in the report footer that uses job as the row, and sum of hours as the summary.

-LB