Choose the appropriate one for wat you are attempting to do. This report also illustrates the use of drillthrough links and conditional formatting. SQL Server 2012 AdventureWorks - All files, scripts, backups, data files. This report illustrates the use of a table data region that provides drilldown from summary data into detail data by showing and hiding rows. This report drills down through salesperson and order number with drillthrough to individual orders. The Sales Reason Comparisons report requires SQL Server Analysis Services and the AdventureWorks Analysis Services database.Īdventure Works sales by territory.

Also illustrates the use of a multivalued parameter. Shows sales reason comparison data from an Analysis Services cube. This report illustrates the use of lists, tables, parameters, and expressions. This report can be accessed as a drillthrough report from the Employee Sales Summary and Territory Sales drilldown report. It also illustrates the use of tables, charts, parameters, calculated fields, and drillthrough links.ĭetail of an individual Adventure Works order. This report illustrates a dataset with queries containing the TOP clause. This report illustrates the use of embedded images, database images, page breaks, page footers, tables, conditional formatting, and a document map.Īdventure Works top five sales people and stores.

This report illustrates the use of multiple datasets, charts, tables, drillthrough, and dynamic parameters.Īdventure Works full product catalog with pictures. This report includes Sales Comparison and Current Month Sales Comparison charts in addition to a Current Month Order Summary table with drillthrough to individual orders. This report also illustrates the use of background images.Īdventure Works sales for an individual employee. This report illustrates the use of a matrix data region that provides drilldown from summary data into detail data by showing and hiding rows. Adventure Works sales by quarter and product category.

Adventureworks sample database 2012