Trace Id is missing

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.

Important! Selecting a language below will dynamically change the complete page content to that language.

  • Version:

    2.0

    Date Published:

    27/8/2010

    File Name:

    ContosoBIRptDetail.rdl

    ReportingScenarioMindMap.pdf

    ContosoProductDetails.xlsx

    Reporting_Solution_Package.zip

    ContosBIRptSummary.rdl

    BI_Reporting_Solution.docx

    File Size:

    60.6 KB

    1.7 MB

    725.0 KB

    3.0 MB

    111.6 KB

    619.7 KB

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