Sage Alert w/Custom Crystal Report Date in Group

SOLVED

Hello, I have a custom crystal report for Sage 100 v2021 Advanced that has a group that uses the PO Required Date and groups it by week. Sage Alerts will only send this report successfully if I remove this group. The alerts error I receive when generating is that report "cannot be printed because its condition field is non existent or invalid". Does this mean I somehow have to convert the grouping by week to sql?