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