Pulling History data

[mercadi]

CR 9.0

I hope this is easy. I currently have a report that I pull in current employees.(EmployeePos_Stat_Curr.Fullname) It shows basic stuff, how many employees per department.

What I need is to pull past current data. For example, I need to see how many current employees we had back in January 2005.

I was trying to set a parameter using hire date. My start date I set to 01/01/1900 to 01/31/2005 to pick up all employees that were active. Will this work or is there a better way to make sure I'm getting the correct number? I'm still learning how to write formulas to pull in correct data needed. Thanks!!!

 

[synapsevampire]

Depends on how your database is capturing the info.

More simply, one would probably create a parameter for the hire date, go to Report->Select Formulas->Record and place something like (assumes a terminated date as well):

(
(
isnull({table.termdate})
or
{table.termdate} > {?HireDateParm}
)
and
{table.hiredate} <= {?HireDateParm}
)

-k