Crystal Report Formulas

Question

Employee 
 Emp Name 
 Per Begin Date 
 Period End Date 
 Fringe ID 
 Amount 
 Deduction ID 
 Amount

1001 
 Jackson, One 
 1/4/2021 
 1/10/2021 
 MEDEMP 
 $ 220.00 
 MED01 
 $ 95.00

1003 
 Jackson, Three 
 1/4/2021 
 1/10/2021 
 MEDEMP 
 $ 221.00 
 MED02 
 $ 96.00

1002 
 Jackson, Two 
 1/4/2021 
 1/10/2021 
 MEDEMP 
 $ 221.00 
 MED01 
 $ -

Current Formula

{PRT_CURRENT__CHECK_FRINGE.Fringe_ID} in ["MEDEMP", "SCORPMED"] 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})) and

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

The above formula does not pick up the employees that have Fringe Benefit but no deductions (example green Above)

Can anyone help me with fixing the formula to pick up the example employee in green above ? Thank you

Art Minds · Answer

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.

Drew M · Answer

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}))

Sage Construction & Real Estate

Crystal Report Formulas

Top Replies

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING