Word Report Template - Product Catalog
Function and SQL
/* Product Catalog */ @F1=Report(type=form cell=CategoryName,Description ,ProductName,ProductID,QuantityPerUnit,UnitPrice range=Product group=1,2 grouprange=Category) SELECT CategoryName ,Description ,ProductName ,ProductID ,QuantityPerUnit ,UnitPrice FROM Products, Categories WHERE Products.CategoryID = Categories.CategoryID ORDER BY 1,3 ;
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 (691KB)