Hi Lucy, 

Since it looks like you are using Sage 300 CRE, I am going to move this post to that Support Group so that other users of this software will see it and can offer you their thoughts and insight.

Thanks,

Erzsi

Off the top of my head (and I am by no means an expert in crystal) I think if you remove the last condition from Report conditions and instead set that condition on the fields returning the deduction amounts in the Format editor that should work.  The condition in the report is going to exclude employees that do not have one of those deductions

Thank you!!

Hi Denise, thank you. I've tried but to no avail.

In Crystal Report formula editor window, above the center section of the three panels, change ""Exceptions for Nulls" to "Default Values from Nulls" from the drop-down list.  That has solved many a report problem in Crystal when working with Sage 300 CRE data.

I would suggest grouping the Fringe and Deduction IDs in an "OR" statement so your formula would look like this:

({PRT_CURRENT__CHECK_FRINGE.Fringe_ID} in ["MEDEMP", "SCORPMED"] or

{PRT_CURRENT__CHECK_DEDUCT.Deduction_ID} in ["SCORPMED", "MED02", "MED01"])

and

{PRT_CURRENT__CHECK.Period_End_Date} = Date (2021, 01, 24) and

{PRT_CURRENT__CHECK.Period_Begin_Date} = Date (2021, 01, 18) and

(isnull({PRM_MASTER__EMPLOYEE.Termination_Date}))