Reports Library
| Adventure Works Cycles sales by quarter and product category. This report illustrates the use of a matrix data region that provides drilldown from summary data into detail data by showing and hiding rows. This report also illustrates the use of background images. Report Pack: Adventure Works 2008; Source Database: Adventure Works; Tags: sales, matrix data region, drilldown; |
| Adventure Works Cycles sales for an individual employee. 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 illustrates the use of multiple datasets, charts, tables, drillthrough, and dynamic parameters. Report Pack: Adventure Works 2008; Source Database: Adventure Works; Tags: employees, sales, orders, drillthrough, dynamic parameters; |
| The Adventure Works Cycles full product catalog with pictures. This report illustrates the use of embedded images, database images, page breaks, page footers, tables, conditional formatting, and a document map. Report Pack: Adventure Works 2008; Source Database: Adventure Works; Tags: product, images, footer, page break, table, conditional formatting; |
| Detail of an individual Adventure Works Cycles order. This report can be accessed as a drillthrough report from the Employee Sales Summary and Territory Sales drilldown report. This report illustrates the use of lists, tables, parameters, and expressions. Report Pack: Adventure Works 2008; Source Database: Adventure Works; Tags: Orders, drillt hrough, lists, tables, parameters, expressions; |
| Adventure Works Cycles sales by territory. This report drills down through salesperson and order number with drillthrough to individual orders. 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 also illustrates the use of drillthrough links and conditional formatting. Report Pack: Adventure Works 2008; Source Database: Adventure Works; Tags: sales, territory, drill down, drill through, orders, conditional formatting; |
| AdventureWorks store contacts. Each store can have one or more store contacts. This report is a subreport used in Sales Order Detail to show all contacts for a store and a drillthrough report for the Product Line sales chart. The border style for the table is None so that borders do not appear in the main report. Note that the page header and footer content are not included when the report is a subreport. Report Pack: Adventure Works 2008; Source Database: Adventure Works; Tags: subreport, drill through; |
| AdventureWorks sales trend analysis that compares year over year (Y/Y) growth for products by category and subcategory. This report illustrates the following features: a Tablix with conditionally hidden static columns, repeat column and row headers, and KeepTogether static Tablix member; the aggregate function Previous that calculates Y/Y trends; custom code; conditional font, background cell color, KPI images, and drillthrough parameters. Report Pack: Adventure Works 2008; Source Database: Adventure Works; Tags: sales, tablix, drill through parameters; |
| Adventure Works Cycles top five sales people and stores. This report illustrates a dataset with queries containing the TOP clause. It also illustrates the use of tables, charts, multivalued parameters, end-user sorting, calculated fields, and drill through links. Report Pack: Adventure Works 2008; Source Database: Adventure Works; Tags: tables, charts, sorting, drilltrhrough; |
