In this chapter, we'll walk through the process of creating a basic SQL Server Reporting Services (SSRS) report. As we learned in the previous chapter, there are two tools we can use to create SSRS reports: Report Builder and Report Designer. We will be using Report Designer in SQL Server Data Tools (SSDT), which comes with the SQL Server 2012 installation media. After the report is created, we will deploy it to a local report server installed in Native mode.
The development activity in this chapter is broken up into the following sections:
Creating a Reporting Services project
Creating a report object
Creating a shared data source
Adding reference to the shared data source
Creating a dataset
Adding a report item
Deploying a report project