Development Activity with SSRS | Reporting with Microsoft SQL Server 2012

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

Tech Concepts

Programming languages

Tech Tools

Unlimited access to the largest independent learning library in tech of over 8,000 expert-authored tech books and videos.

Innovative learning tools, including AI book assistants, code context explainers, and text-to-speech.

50+ new titles added per month and exclusive early access to books as they are being written.

Reporting with Microsoft SQL Server 2012

Reporting with Microsoft SQL Server 2012

Overview of this book

Chapter 3. Development Activity with SSRS

Confirmation

Buy this book with your credits?

Submit Your Feedback

Create a Free Account To Continue Reading

Sign in to activate your 7-day free access