Crystal Reports Shift Reporting

See more:

CrystalReports

not {Command.REVERSED} and
CTIME({Command.DOWN_TIME}) IN
Switch
    (
    {?Shift} = "1st Shift",
        (ctime("07:30") to_ ctime("16:00")),
    {?Shift} = "2nd Shift",
        (ctime("15:30") to_ ctime("00:00")),
    {?Shift} = "3rd Shift",
        (ctime("23:30") to_ ctime("08:00")),
    {?Shift} = "All Shifts",
        (ctime("00:00") to_ ctime("23:59"))
    ) and
{Command.DOWN_TIME}={?Date Range} and
{Command.DESCRIPTION} = {?Reason Code}

I am tasked with adding a shift parameter to a downtime report. The above filter should filter out records where downtime starts within the switch case. However when I run the report, all values still persist and are not filtered out. Any ideas.

Command.Down_time is a datetime field.