Book Image

Reporting with Microsoft SQL Server 2012

Book Image

Reporting with Microsoft SQL Server 2012

Overview of this book

Table of Contents (12 chapters)

Chapter 3. Development Activity with SSRS

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