Reporting Services Tutorials (SSRS)

This section contains tutorials for SQL Server 2012  Reporting Services.

  • Create a Data-Driven Subscription (SSRS Tutorial)
    Reporting Services provides data-driven subscriptions so that you can customize the distribution of a report based on dynamic list of subscribers that will receive the report. Data-driven subscriptions are typically created and maintained by report server administrators. The ability to create data-driven subscriptions requires expertise in building queries, knowledge of data sources that contain subscriber data, and elevated permissions on a report server.

  • Create a Basic Table Report (SSRS Tutorial)
    Follow the steps in this tutorial to learn how to create your first report. This tutorial shows you how to work with SQL Server Data Tools (SSDT) to create a data connection (data source), define a simple query (dataset), and configure a data region to contain your data.

  • Accessing the Report Server Web Service Using Visual Basic or Visual C# (SSRS Tutorial)
    Follow the steps in this tutorial to learn how to access the SQL Server 2012 Reporting Services (SSRS) Web services from an application created with Microsoft Visual Basic or Microsoft Visual C#.

  • Updating Reports Using Classes Generated from the RDL Schema (SSRS Tutorial)
    Follow the steps in this tutorial to learn how to use the XML Schema Definition Tool (Xsd.exe) to generate classes that allow you to serialize and deserialize report definition files (.rdl and .rdlc) with the Microsoft .NET Framework.

  • Create a Drillthrough (RDLC) Report with Parameters using ReportViewer (SSRS Tutorial)
    Follow the steps in this tutorial to learn how to create a drillthrough report with parameters and a filter using the ReportViewer control.

  • Tutorial: Create a Sample Report in Power View
    Follow the steps in this tutorial to learn how to create a Power View report that demonstrates what Power View can do, using a small sample model created in PowerPivot for Excel. You create tables and convert them into a number of different visualizations. You create tiles and add visualizations to them. You create multiple pages, or views, in your report. You create a bubble chart and add a play axis to it, so you can see how the values change over time. You create small multiples – a set of small charts, one per series, with the same axes. Then you experiment with different ways to filter the data in the visualizations. In the end, you export your report to PowerPoint.

  • Tutorial: Optimize a Sample PowerPivot Model for Power View Reports
    Follow the steps in this tutorial to learn how to modify an Excel workbook in PowerPivot for Excel to make a small but functional model that you can use as a basis for sample Power View reports. Everything you do in this tutorial in PowerPivot, you can also do in tabular models that you create in SQL Server Data Tools (SSDT).

See Also

Other Resources

Adventure Works for SQL Server 2012

Reporting Services Samples on CodePlex (https://go.microsoft.com/fwlink/?LinkId=198283)

TechNet WIKI: SQL Server 2012 Samples (https://go.microsoft.com/fwlink/?linkID=220734)

Picnic Dataset (Sample Data) (https://go.microsoft.com/fwlink/?linkID=219108)