Monday, September 06, 2010
        Account, Demo 678
   
ICPC-TE-ReportXP
Company Sales 2008
Adventure Works sales by quarter and product category. This report illustrates the use of a tablix data region with nested row groups and column groups. You can drilldown from summary data into detail data by showing and hiding rows. This report also illustrates the use of a logo image and a background image.
Last Modified: IDIHQ\fnguyen9/30/2009 9:19:59 AM
Sales Order Detail 2008
Detail of an individual Adventure Works 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 a free form layout, a table, parameters, a subreport that shows multiple store contacts, and expressions.
Last Modified: IDIHQ\fnguyen9/30/2009 11:19:58 AM
Employee Sales Summary 2008
Adventure Works 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, a line chart, a column chart with scale breaks, a table, drillthrough, and dynamic parameters.
Last Modified: IDIHQ\fnguyen9/30/2009 11:19:55 AM
Sales Trend 2008
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.
Last Modified: IDIHQ\fnguyen9/30/2009 11:19:59 AM
Product Catalog 2008
Adventure Works full product catalog with pictures. This report illustrates the use of embedded images, database images, page breaks, page footers, a tablix with three nested row groups and details but no grouping cells, conditional formatting, and a document map.
Last Modified: IDIHQ\fnguyen9/30/2009 11:19:56 AM
Store Contacts 2008
AdventureWorks store contacts. This report is a subreport used in Sales Order Detail to show all contacts for a store. Borderstyle is None so lines do not display in main report.
Last Modified: IDIHQ\fnguyen9/30/2009 11:19:59 AM
Product Line Sales 2008
Adventure Works top five sales people and stores. This report illustrates a dataset with queries containing the TOP clause. It also illustrates the use of a tablix and a bar chart that synchronize sort order when you click the interactive sort button on the column headers, a tablix and pie chart, parameters, calculated fields, and drillthrough links.
Last Modified: IDIHQ\fnguyen9/30/2009 11:19:57 AM
Territory Sales Drilldown 2008
Adventure Works sales by territory. This report drills down through salesperson and order number with drillthrough to individual orders. This report illustrates the use of a tablix 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.
Last Modified: IDIHQ\fnguyen9/30/2009 11:20:00 AM
Demo Explanation

The AdventureWorks sample reports are a set of predefined report definition files that use the AdventureWorks databases as data sources. You can upload and view each report separately; however, some reports are designed to work together through the use of links. You can use the sample reports to familiarize yourself with the capabilities of Reporting Services or as templates for designing new reports.

Adventure Works Cycles publishes product and sales information that is accessed by employees throughout the company. The reports present this data in a variety of formats. Users can view these reports on demand by opening them in Report Manager.

Report Description

Company Sales

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.

Employee Sales Summary

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.

Product Catalog

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.

Product Line Sales

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 drillthrough links.

Sales Order Detail

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.

Territory Sales

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.

Sales Reason Comparison

Shows sales reason comparison data from an Analysis Services cube. Also illustrates the use of a multivalued parameter. The Sales Reason Comparisons report requires SQL Server Analysis Services and the AdventureWorks Analysis Services database.

Go Back
To leave the demo site and go back to opensource.indyneinc.com, click here
Demo Accounts
Login as:
Privacy Statement  |  Terms Of Use Copyright 2008 by ICPC