Database Reference
In-Depth Information
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
Prerequisites
Before you start this exercise, you will require the following prerequisites:
• Access to a Microsoft SQL Server 2012 Reporting Services report server
installed in the Native mode with the appropriate permissions required to
deploy reports and shared data sources
