Microsoft Excel Reporting Tool
 

Excel Report Template - Customer Profile

See Microsoft ® Excel ® Report

Excel Report Template - Customer Profile

Function and SQL

@F1=Report(sheet="Customer Profile" 
	cell=A6,B7,C7,D7,D8,E7,E8,E9 range=6:9 
	group=1 pagebreak = 6r)
SELECT LEFT(CompanyName,1)
,CompanyName
,ContactName
,'Phone: ' & Phone
,'Fax: ' & Fax
,Address
,CityName & ', ' & CountryName
,PostalCode
FROM Customers, Cities, Countries
WHERE Customers.CityCode = Cities.CityCode
AND Customers.CountryCode = Cities.CountryCode
AND Customers.CountryCode = Countries.CountryCode
ORDER BY CompanyName
;

These sample reports are generated by XLReportGen (Report Generator for Microsoft Excel). The sample reports in Microsoft Excel spreadsheet 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 Excel spreadsheet format  XLS (293KB)

 


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