Position: from date to date hired
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...
Re: Position: from date to date hired
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?
Re: Position: from date to date hired
Yes! my database design is just like this:
Code:
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]
