hi all
please i need help, i want to design employee CV like this :
(Group Header)
from "Employee Profile" table in "Personal DB"
ID -------
Name --------
DateOfBirth -------
PlaceOfBirth --------
(Details)
employee transfers(Departments) from "Trans" table in "Tranfers DB"
-----------------------------------------------------
TransDept | TransDate | DecreeNO '
Dept1 TDate1 Decr1
Dept2 TDate2 Decr2
' ' '
' ' '
employee promotions from "Promot" table in "Promotion DB"
----------------------------------------------------
PromotDate | PromotNo | Grade
PromotD1 ProNo1 G1
PromotD2 ProNo2 G2
PromotD3 ProNo3 G3
and so on, but the problem is it show like this in details :
TransDept | TransDate | DecreeNO
PromotDate | PromotNo | Grade
Dept1 TDate1 Decr1
PromotD1 ProNo1 G1
Dept2 TDate2 Decr2
PromotD2 ProNo2 G2
hope explain my problem in a good way, please help me its importent for me coz i have many reports like that or if there any sample can help me.
thank you all ............
IP Logged
