Word Report Template - Monthly Sales 4
Function and SQL
/*********************************************************
Sales by Countries
*********************************************************/
@F3_1=REPORT(table=Report3 type=var cell=A2)
SELECT c.CountryName
, SUM(d.Quantity)
, Sum(d.UnitPrice * d.Quantity * (1-d.Discount))
FROM Orders o
,OrderDetails d
,Countries c
WHERE o.OrderID = d.OrderID
AND o.ShipCountryCode = c.CountryCode
AND YEAR(o.OrderDate) = YEAR('$ReportMonth-01')
AND MONTH(o.OrderDate) = MONTH('$ReportMonth-01')
GROUP BY c.CountryName
ORDER BY c.CountryName
/* For chart */
@F3_2=CHART(chart=Chart3 cell=A0)
SELECT c.CountryName
, Sum(d.UnitPrice * d.Quantity * (1-d.Discount))
FROM Orders o
,OrderDetails d
,Countries c
WHERE o.OrderID = d.OrderID
AND o.ShipCountryCode = c.CountryCode
AND YEAR(o.OrderDate) = YEAR('$ReportMonth-01')
AND MONTH(o.OrderDate) = MONTH('$ReportMonth-01')
GROUP BY c.CountryName
ORDER BY c.CountryName
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)