Formula/Sub Report

[blairclw]

OK, let me see if I can explain this so you know what is going on. This is a subreport that was created in my report.

Let's say I have this pay period of 06/27/05 - 07/10/05
and the employees Annual eval is due 07/04/2005. (which falls in between these two dates)

If the eval falls in between this date the eval would be effective 07/11/05 which is the beginning of the next payroll. BUT if the eval happens to fall at the beginning of the pay period on 06/27/05 the eval SHOULD be effective on 06/27/05 (same pay period) and this report is showing the effective date to be the following payperiod on 7/11/05.

How can I tell the report the effective date is the current payperiod IF the eval is due ONLY on the beginning of that payperiod.

Here is what is in the report currently:

THIS SHOWS IN MAIN REPORT
{PERFORMANCE.PerformanceReason} = {?Eval Type} and
totext (month({PERFORMANCE.NextPerformanceReviewDate}),0) = {?EvalMonth} and
totext (year({PERFORMANCE.NextPerformanceReviewDate}),0,"") = {?EvalYear} and
{PERSON_STATUS_POSITION_JOB.PositionPrimaryInd} and
{PAY_STATUS.BasePayInd} and
{PAY_GRADE_CODES.PayGradeCodeToEffectDate} = DateTime (3000, 01, 01, 00, 00, 00) and
{PAY_STATUS.PayStatusToEffectDate} = DateTime (3000, 01, 01, 00, 00, 00) and
{PERSON_STATUS_POSITION_JOB.JobCodeToEffectDate} = DateTime (3000, 01, 01, 00, 00, 00) and
{PERSON_STATUS_POSITION_JOB.PositionCodeToEffectDate} = DateTime (3000, 01, 01, 00, 00, 00) and
{PERSON_STATUS_POSITION_JOB.PositionToEffectDate} = DateTime (3000, 01, 01, 00, 00, 00) and
{PERSON_STATUS_POSITION_JOB.pesPositionOrgToEffectDate} = DateTime (3000, 01, 01, 00, 00, 00) and
{PERSON_STATUS_POSITION_JOB.EmploymentStatusToEffectDate} = DateTime (3000, 01, 01, 00, 00, 00) and
{PERSON_STATUS_POSITION_JOB.PersonToEffectDate} = DateTime (3000, 01, 01, 00, 00, 00) and
{Organizations_Curr.Department} <> "Confidential Payroll" and
{PERSON_STATUS_POSITION_JOB.EmployeeStatus} <> "Terminated"

THIS SHOWS IN SUBREPORT

{CHECK_GROUP_CALENDARS.CheckGroupCalendarDefaultInd} and
{PERFORMANCE.PerformanceToEffectDate} = CDateTime (3000, 01, 01, 00, 00, 00) and
{PERSON_PAYROLL_SETUPS.PersonPayrollSetupEndDate} = CDateTime (3000, 01, 01, 00, 00, 00) and
{PERSON_PAYROLL_SETUPS.TaxLocationCodeToEffectDate} = CDateTime (3000, 01, 01, 00, 00, 00) and
{PERSON_PAYROLL_SETUPS.PersonToEffectDate} = CDateTime (3000, 01, 01, 00, 00, 00) and
{CHECK_GROUP_CALENDARS.CheckGroupCalendarToEffectDate} = CDateTime (3000, 01, 01, 00, 00, 00) and
{CHECK_GROUP_CALENDARS.PayrollCalendarToEffectDate} = CDateTime (3000, 01, 01, 00, 00, 00) and
{CHECK_GROUP_CALENDARS.CheckGroupToEffectDate} = CDateTime (3000, 01, 01, 00, 00, 00) and
{CALENDAR_DETAILS.PayrollCalendarToEffectDate}= CDateTime (3000, 01, 01, 00, 00, 00) and
{CALENDAR_DETAILS.CalendarDetailToEffectDate} = CDateTime (3000, 01, 01, 00, 00, 00)
and
{PERSON_PAYROLL_SETUPS.PersonIdNo} = {?Pm-PERSON_STATUS_POSITION_JOB.PersonIdNo}
and
{PERFORMANCE.NextPerformanceReviewDate} = {?Pm-PERFORMANCE.NextPerformanceReviewDate}