An Approach to a Graphical Report

[tmozer]

My administration would like a report that would graph the monthly and/or quarterly (30/90 day) production turn-around-times. The calculation of TAT is simply {LABREPT.Date Completed} minus {LABREPT.Date Assigned}. I need to filter for Unit and Location ({LABREPT.section} and {LABREPT.Lab Code}).

Can anyone suggest the best plan of attack to group these averages so that I can attach a line graph of the TAT trend over time?

I am using Crystal Reports 8.5 and Oracle tables.

 

[Madawc]

I'd advise getting a printed report first. Turn it into a graph once you are happy with the figures.

DateDiff gives you the difference between two dates, while DatePart lets you find the calendar month or quarter for a particular date. Look it up on Crystal Help, and try a search here if that isn't enough.

Madawc Williams (East Anglia, UK)