Legacy Update: Get back online, activate, and install updates on your legacy Windows PC

The files on this page show a scenario that uses Report Builder 3.0, SharePoint Server 2010, and Microsoft Excel 2010 together to create a reporting solution. The scenario features data analysis, rich report design, and flexible delivery of content.

• Together, the files on this page provide a business intelligence reporting scenario, a visual summary diagram of the solution described in that scenario, and details about the fictional company, Contoso. The scenario describes the report requirements and how Contoso employees used Microsoft applications to provide a meaningful and useful reporting solution. Download the materials on this page for comprehensive information about this reporting scenario. Documents:
  1. BI_Reporting_Solution.docx: The complete, step-by-step Business Intelligence reporting scenario
  2. * ContosBIRptSummary.rdl: A report definition file for a summary report featuring sparkline charts, with parameterized links to a detailed report
  3. * ContosoBIRptDetail.rdl: A report definition file for a flat detailed report with parameters for product channel and category
  4. ContosoProductDetails.xlsx: An Excel workbook containing data that was exported from ContosoBIRptDetail.rdl, cleaned up, and then saved to the current Excel format
  5. Reporting_Solution_Package.zip: A compressed file that contains the scenario and all supporting files
  6. ReportingScenarioMindMap.pdf: A visual representation of the steps taken in the BI Reporting and Subscriptions solution
  * Note: These Report Builder 3.0 report definition (.rdl) files require a connection to a Contoso data source like the ones described in this scenario. After you have configured the data sources as described, modify the .rdl files to connect to your data sources. Download the Microsoft Contoso BI Demo Dataset for Retail Industry.

Files

Status: Live This download is still available on microsoft.com. The downloads below will come directly from the Microsoft Download Center.

File	SHA1 Hash	Size
BI_Reporting_Solution.docx	5362311789779a6a398028531026609014c2cd2a	600 KB
ContosBIRptSummary.rdl	77241bd228e7e812d4dfd194b155059c2da5b84e	7 KB
ContosoBIRptDetail.rdl	46fd5b8f8f0674fa95e037e72fcb427c20c19bb6	5 KB
ContosoProductDetails.xlsx	41210ace80e167ad8960f6e6881ba60702d32c22	590 KB
ReportingScenarioMindMap.pdf	40cc06a9a6dd5012b796565cbf6ff2f9356dcad6	1.69 MB
Reporting_Solution_Package.zip	32f4c5aa17176d6ff4cb3c647e2bbb29f6e7d1d8	2.96 MB

File sizes and hashes are retrieved from the Wayback Machine’s indexes. They may not match the latest versions of files hosted on Microsoft servers.

• • Server:
  • SharePoint Server 2010, Enterprise Edition
  • SQL Server 2008 R2, including the following:
  • Analysis Services
  • Reporting Services
  • Client:
  • Office 2010, including the following:
  • Excel

• Five individual files are available for this scenario. You can download them separately, or you can download the compressed .zip file, which includes all the files. To extract the entire contents of a compressed folder, right-click the folder, click Extract All, and then follow the instructions.