Working with Report Builder 3.0 - Learning SQL Server Reporting Services 2012 - page 305

The map is showing the ten data points from our query on the Adventure
Works database.
15. Click on Finish .
16. Run the report and save as LosAngelesData .
The data selected is not that great. It is very essential that you know your data very
well before you embark on creating a report.
SELECT SUM([Order Details].UnitPrice * [Order Details].
Quantity) AS 'Total sales', Categories.CategoryName
FROM [Order Details] INNER JOIN
Orders ON [Order Details].OrderID = Orders.
OrderID INNER JOIN
Products ON [Order Details].ProductID =
Products.ProductID INNER JOIN
Categories ON Products.CategoryID =
Categories.CategoryID
GROUP BY Categories.CategoryName