Personalization, Customization and Productivity Tools

[busterp]

Payroll, 3.71.

Company is based in IL.

One employee from WI.

In employee master, primary state is WI.

In setup default state tax code is IL ( only one employee - at one time there was IL employee too)

So, in my CR 8.5 subreport I have PR3 taxsummary state code and the following two formulas

IF {PR3_EmployeeTaxSummary.StateCode}="WI" and
{PR_22PerpetChkHistoryHeader.CheckDate}={?Pm-?Check Date}
then
{PR_22PerpetChkHistoryHeader.StateWitholding}

IF {PR3_EmployeeTaxSummary.StateCode}="IL" and
{PR_22PerpetChkHistoryHeader.CheckDate}={?Pm-?Check Date}
then
{PR_22PerpetChkHistoryHeader.StateWitholding}

I would expect only a WI to show up but I get 3 detail entries, one with no state, one with IL and one with WI.

So, my code is creating a code total for IL even though the employee is WI. What am I doing wrong?

[TomTarget]

My guess is that your data does actually have an IL entry in it (without any values?). 

The blank state code is the Federal records.  The WI and IL are obvious.

If in doubt,  use data file display and maintenance to review the data in the file.  If you see three records that way,  at least you know your crystal report is not the culprit.

If there is an IL entry and it does have non-zero values,  odds are that somewhere along the way you processed a payroll with that imployee set to IL.