I've just started using Crystal Reports 8 at work, and have been
picking it up quite well.  However, I have a little problem.  I want to
be able to display the total amount of minutes worked by a department
in my company.  I created a formula, and put it into the detail section
of the report, and it looks like this:

If {timeperiod.attendanceflag} = 1 and {employeetreelink.treenode3} =
3013 and {timeperiod.periodstartdatetimerounded} >= #01/10/2000# and
{timeperiod.periodenddatetimerounded} <= #31/10/2000# Then
(
    (Sum({timeperiod.PERIODDURATIONMINSROUNDED}))/60
);

where attendanceflag is 1 if the person is in, treenode3 is the
department id.  I've selected the data to be within the month of
October, hence the periodstartdaterounded and periodenddaterounded.

When I use the above formula, it produces a list on the report like
this:

10,195.60
0.00
10,195.60
0.00
10,195.60
0.00
10,195.60
0.00
...

where I only want it to display 10,195.60, and only display it once!

I hope all that made sense...any help on this matter would be
gratefully appreciated!

Kind Regards,

Mario Sarno
--
*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-
 _  // Mario Sarno

  \/   Website: http://www.*-*-*.com/

Sent via Deja.com http://www.*-*-*.com/
Before you buy.