Microsoft Word Reporting Tool
 

Word Report Template - Employee Profile

See Microsoft ® Word ® Report

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 (472KB)

 


Copyright © 2004 - 2014 LJZsoft Corporation. All rights reserved.