Excel Report Template - Product Catalog

See Microsoft ® Excel ® Report

Function and SQL

@F1=Report(sheet="Product Catalog"
	cell=A5,A6,B6,A9 
	group=1,2,3 grouprange=5:10 
	image=2 pagebreak = 1g)
SELECT CategoryName
,Picture
,Description
,ProductName
,ProductID
,QuantityPerUnit
,UnitPrice
FROM Products, Categories
WHERE Products.CategoryID = Categories.CategoryID
ORDER BY 1,3
;

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)