Word Report Template - Employee Profile
Function and SQL
/* Employee Profile*/ @F1=Report(table=1 type=var cell=B1,D3,D5,D7,D9,D11,D13,D15,D19 copyrange=1:21 PageBreak = 2r) SELECT LastName & ',' & FirstName ,FirstName & ' ' & LastName ,Title ,BirthDate ,HireDate ,HomePhone ,Extension ,Address & ' ' & CityName & ', ' & CountryName & ', ' & PostalCode ,Notes FROM Employees, Countries, Cities WHERE Employees.CityCode = Cities.CityCode AND Employees.CountryCode = Cities.CountryCode AND Employees.CountryCode = Countries.CountryCode ORDER BY LastName ;
These sample reports are generated by WDReportGen (Report Generator for Microsoft Word). The sample reports in Microsoft Word document format can be download for your report templates, and changed to adapt to your own needs. It is free.
Download the report samples in Microsoft Word document format DOC (691KB)