I am using Crystal reports 10 and would like some help with grouping.
I want to run a report on calls received during third shift (11:00PM to 7:AM). This report will be run for multiple days so I will need to group by date. The problem is it will pull calls for a persons shift from the morning and the night.
For example
person x worked from 12:00AM to 7:00 AM Monday morning. Then came back at 11:00PM and worked until 11:59 PM Monday night.
I need the grouping to be able to distinguish between calls received on these two seperate shifts for this person.
I would like idealy to have a group that is a range - currentdate, 23,00,00 to currentdate + 1,7,00,00.
Is there a way to do this? I am also open to other ideas.
I can supply what ever information you may need to figure this out.
Thank you.
I want to run a report on calls received during third shift (11:00PM to 7:AM). This report will be run for multiple days so I will need to group by date. The problem is it will pull calls for a persons shift from the morning and the night.
For example
person x worked from 12:00AM to 7:00 AM Monday morning. Then came back at 11:00PM and worked until 11:59 PM Monday night.
I need the grouping to be able to distinguish between calls received on these two seperate shifts for this person.
I would like idealy to have a group that is a range - currentdate, 23,00,00 to currentdate + 1,7,00,00.
Is there a way to do this? I am also open to other ideas.
I can supply what ever information you may need to figure this out.
Thank you.