Position: from date to date hired

[eyeclatcher]

Hi everyone! is there anyone can help me to my problem? I created reports that will show all the history records of employee base from his/her designation with corresponding date of hired and promotion due to his/her range of term.
My problem is i don't know how to do this. I want my report be print out like this:

EXAMPLE:

Mark S. Dayao has been employed in this company with the following capacities:

1. Accounts Clerk - from 1/1/2007 to 1/2/2008"
2. Book Keeper - from 1/2/2008 to 6/28/2009"
3. Accounting Head - from 6/28/2009 to 2/29/20012"


I don't know if i will use parameters or running fields using crystal reports for this problem. pls. help me...

[wes4dbt]

It will depend on how you've designed your database. Have you already designed your database? Is this a new app or are you adding to an existing app?

[eyeclatcher]

Yes! my database design is just like this:

NO    Emp_No     Emp Name             Position                     Date Hired

1      8888          Mark S. Dayao       Accounts Clerk           1/1/2007
2      8888          Mark S. Dayao       Book Keeper               1/2/2008
3      8888          Mark S. Dayao       Accounting Head         6/28/2009

Note that the date 2/29/20012 is base from current date ex: the last date of hired (6/28/2009) up to the current date.


[Code tags added by moderator]