PowerPoint Report Template - Employee Profile

See Microsoft ® PowerPoint ® Report

Function and SQL

/* Employee Profile*/
@F1=Report(slide=2 type=form 
cell=SlideTitle,Name,Photo,Title,BirthDate,HireDate
,HomePhone,Extension,Address,Notes image=3)
SELECT LastName & ',' & FirstName
	,FirstName & ' ' & LastName
	,Photo
	,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 PTReportGen (Report Generator for Microsoft PowerPoint). The sample reports in Microsoft PowerPoint 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 PowerPoint format  PPT (468KB)