Is this easy?

[rickm4]

I have a report i am generating that has 2 columns(for example purposes) REG1 Clocked Hours
REG1 Non clocked hours

The department heads want to see a "Total" of REG1 hours, They don't care if they are clocked or non clocked. How can I have 1 column named REG1 hours but have the hours combined per employee? Example:

Dept Name RG1 Nonclocked RG1 Clocked
IS B.Jones 8
IS J.Doe 8

IS department has 16 hours of REG1 Time.
The hours are in different columns. Can this be done?? Thanks in advance

 

[synapsevampire]

Group by Dept

Create a formula which has something like:

{Table1.RG1 Nonclocked}+{Table1.RG1 Clocked}

Place that column in the detail section, right click it and select insert summary->Sum, and make sure that you select sorted and grouped by Dept.

You may need to check for nulls, or you can avoid it by selecting File->Report Options->Convert null values to default.

-k

http://www.informeddatadecisions.com

kai@informeddatadecisions.com