Hello all!

I have a report that is evaluating employee rates from a date driven table. Each rate has an effective start date and a rate end date. My report is based off a start date and an end date that the user will supply to the report before running and what I'm trying to do (and failing miserably) is:

If an employee received a rate change show the date of the change and show the new salary. That part is easy enough and works perfectly however, the client would also like to see the difference between the new salary and old salary.

to get the new salary I'm able to use :
If {Rate.startDate} IN {@YYYStartDate} TO {@YYYEndDate} Then
    {@Salary}

and to get the old salary I'm using:
If {Rate.endDate} IN {@YYYStartDate} TO {@YYYEndDate} Then
    {@Salary}

to be as clear as i can the YYYStartDate and YYYEndDate are supplied from the user and Salary is a basic math formula taking the rate * pay frequency * number of pays in a year

If there is anything that maybe I'm doing wrong or if anyone has any ideas I'd love to hear them as I have tried everything that I can to get the old rate to figure the old salary. If i pull the SQL data from the report i can see that the old rate is there and for whatever reason not coming through to my report.

Thank you in advance.

basically.

rate.startdate(day rate started)
rate.enddate(08/24/2013) unless the rate is still active then it shows as rate.enddate(12/31/2100)

what i need to show is if the employee got a raise i need to show his name, the startdate of the new rate, the new salary and the difference between old and new salary

so....

employee: john smith
rate.startdate: 08/01/2013
rate: 10.00
rate.startdate: 08/24/2013
rate: 12.00
rate.enddate: 08/23/2013
rate.enddate: 12/31/2100

this would need to show like this
name         | new rate date | salary      | difference
john.smith | 08/24/2013     | 24960.00 | 4160.00

well, luckily when looking throught he database no one has yet.....although i'd wanna do a cya and make sure that I am able to see that as well providing that they all fall in during the dates provided.

this report would really only ever run on a 30 day window so i doubt that someone would get several raises in that time but it;s possible.

yeah, that's pretty much how my report is already. the only thing I'm trying to not use max or min because some of the employees who got a pay change actually stepped down in pay. so max would pull the wrong data for rate. 

ill give this a try and see what i come up with.

i'm not sure what you meant by link to hr department. did i miss something heh.