Time Range

[Gizmo0917]

We operate on a 24X7 hour time range. I need to do a report that will allow me to capture the time range for my 2nd shift people. The time will be 7Pm to 7:30AM This allows me to do a productivity report. I have a report set up and it is getting my information for the dayshift just fine but the night shift is not giving me accurate information. We are using a SQL Based Server and I use Crystal Reports V8.5 in order to pull reports. Is there a way that I can get the correct times in Crystal? I think the SQL pgm has a 24X7 clock but it goes from 12 to 12. Can anyone help?

 

[Gizmo0917]

The Therapists all belong to a certain leadperson they are designated this by a team number and it doesn't show what time they work. 4 Teams and they are divided up among the teams. Some are not on the correct teams even as the guy that does are SQL support has not updated the information in the master tables. The {PRACTWORK.DATE}is a date table but you can specify it to be a datetime field when creating the parameter field. How else can I get the time?

 

[kskid]

If the team number is on the record, then do the following

//@Team
//Formula to reassign indiviual employees into the
//correct team until the database is fixed

if EmployeeName = "John Jones" and {TeamNumber} <> "1" then
"1" // place the correct team number here
else if EmployeeName = "Sue Smith" and {TeamNumber} <> "2" then
"2"
else
{TeamNumber}

//Shift
//Formula to assign shift
if {@team} in ["1","3"] then
"Shift 1"
else
"Shift 2"

Place both into the detail section and suppress

Create Group 1 by Shift
Create Group 2 by Employee Name

Create summary count of date records by employee name with subtotal and grand totals

Have I left anything out?