PowerPoint Report Template - Supplier Profile

See Microsoft ® PowerPoint ® Report

Function and SQL

/* Current Date */
@F0=Report(slide=1 type=form cell=Date)
SELECT Now

/* Supplier Profile*/
@F1=Report(slide=2 type=form cell=SlideTitle,Company,ContactName
,ContactTitle,Address,City,Country,PostCode,Phone,Fax,HomePage)
SELECT CompanyName
,CompanyName
,ContactName
,ContactTitle
,Address
,CityName
,CountryName
,PostalCode
,Phone
,Fax
,HomePage
FROM Suppliers, Countries, Cities
WHERE Suppliers.CityCode = Cities.CityCode
AND Suppliers.CountryCode = Cities.CountryCode
AND Suppliers.CountryCode = Countries.CountryCode
ORDER BY CompanyName

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)