BI Reporting: Reports and Subscriptions Solution

    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.
    • Note:There are multiple files available for this download.Once you click on the "Download" button, you will be prompted to select the files you need.


      File Name:







      Date Published:


      File Size:

      3.0 MB

      620 KB

      112 KB

      61 KB

      726 KB

      1.7 MB

        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.
    • Supported Operating System

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

    Popular downloads

    Loading your results, please wait...

    Free PC updates

    • Security patches
    • Software updates
    • Service packs
    • Hardware drivers

    Microsoft suggests

    The power of Office. Everywhere. Learn more.
    The power of Office. Everywhere.
    Start your free month of Office 365 now.
    Learn more