Development Activity with SSRS | Reporting with Microsoft SQL Server 2012

Tutorial scenario

In this exercise, you will step into the shoes of an IT developer working at a fictitious bike retailer called Adventure Works. You have been tasked with creating a report for the Internet sales department that will provide information on year-over-year sales trends. After developing the report, you will need to deploy it to the company's existing standalone report server, where it can be accessed by users in the sales department.

Creating a Reporting Services project

Since we are using SQL Server Data Tools (instead of Report Builder) for this exercise, the first step is to create a Reporting Services project:

Open SQL Server Data Tools (SSDT).
From the menu bar across the top, navigate to File | New | Project.
In the New Project window, navigate to Business Intelligence | Reporting Services | Report Server Project.
Enter a name and location for the project, and click on OK to create and open the project.
New Project dialog box for creating a new Report Server Project

Creating...

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

Tutorial scenario

Creating a Reporting Services project

Creating...

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