Calculate Calls that Occurred - Weekend vs. Weekday

[KalebsDad78]

I have searched the forums and read numerous threads but none that seemed to help me with a report I am working on.

I am an administrator with an ambulance service and I am trying to trend the number of late calls we have on weekends versus weekdays and want to show that in text form and then also create a graph to show the percentage of late calls on weekends versus weekdays.

I am using Crystal XI with an ODBC and WinXp.

Any help would be greatly appreciated.

Thank you!

 

[lbass]

What constitutes a "late call"? You need to provide some sample (mock) data so we can see what fields you are working with, along with sample values. Please label the fields clearly.

-LB

 

[Madawc]

You need to define two groups, using formula fields. Something like

if DatePart("w", {your.datetime}) in [7, 1]
then "Weekend"
else "Weekday"

That's with Sunday as Day 1, the default.

[code=@LateTest]if DatePart("h", {your.datetime}) > 18 then "Late"
else "Normal"

That is taking six in the evening as the limit, you can also get minuetes using "n", "m" gives months.

Display the fields against your data to check that they work OK. Then use them to define groups and count within groups. (If you're not already familiar with Crystal's automated totals, see FAQ767-6524.)

You should also be able to make graphs from this data.

Madawc Williams (East Anglia, UK). Using Crystal 2008 with SQL and Windows XP