Microsoft Download Center Archive

BI Reporting: Reports and Subscriptions Solution

  • Published:
  • Version: 2.0
  • Category: Document
  • Language: English

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


Status: Live

This download is still available on The downloads below will come directly from the Microsoft Download Center.

FileSHA1 HashSize
BI_Reporting_Solution.docx5362311789779a6a398028531026609014c2cd2a600 KB
ContosBIRptSummary.rdl77241bd228e7e812d4dfd194b155059c2da5b84e7 KB
ContosoBIRptDetail.rdl46fd5b8f8f0674fa95e037e72fcb427c20c19bb65 KB
ContosoProductDetails.xlsx41210ace80e167ad8960f6e6881ba60702d32c22590 KB
ReportingScenarioMindMap.pdf40cc06a9a6dd5012b796565cbf6ff2f9356dcad61.69 MB
Reporting_Solution_Package.zip32f4c5aa17176d6ff4cb3c647e2bbb29f6e7d1d82.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.

System Requirements

Operating Systems: Windows 7, Windows Server 2003, Windows Server 2008, Windows Vista, Windows XP

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

Installation Instructions

  • 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.