Lawson History Table help

[Bronnad]

I am running a report that pulls from a history table.
I have 2 fields...

1- salary on 2/27/2012 (date of merit increase)

if {Salary History.BEG_DATE} = #2/27/2012#
then
if{Salary History.SALARY_CLASS}="Hourly"
then{Salary History.PAY_RATE}*{Salary History.ANNUAL_HOURS}
else{Salary History.PAY_RATE}

2- salary before 2/27/2012 (salary before merit increase)

if {Salary History.BEG_DATE} < #2/27/2012#
then
if{Salary History.SALARY_CLASS}="Hourly"
then{Salary History.PAY_RATE}*{Salary History.ANNUAL_HOURS}
else{Salary History.PAY_RATE}

Your assistance would be greatly appreciated.

 

[Bronnad]

Okay...

I created a s Sub-Report that gives me the data I want to populate in the Pre-Merit field.
The reports are not linked.
I Just want to display the results from the formula in the Group Footer from the Sub-Report.

The date range in the Main is {PRRATEHIST.BEG_DATE} in DateTime (2008, 01, 01, 00, 00, 00) to DateTime (2012, 02, 27, 00, 00, 00)

The date range in the SUB is {PRRATEHIST.BEG_DATE} in DateTime (2008, 01, 01, 00, 00, 00) to DateTime (2012, 02, 26, 00, 00, 00)