Creating a Report in Report Builder SQL Server


show more When creating a report with Report Builder, you will use a tool called the authoring tool. This video shows you where to find this tool and how it works. Because it is an online tool, there may be some security questions for you to answer the first time you access the site. Once signed in, you will see the Getting Started page, which provides several report building options to help you create a unique report to suit your needs. show less
please wait ...

Creating a report with Report Builder

To create a report in Reporting Services we need to use an authoring tool, and I'm going to use Report Builder first. The easiest way to get it is to open up a web browser to the Reporting Services Report Manager website. Now, for me, that's located at dbserver/Reports; it will be a different address for you. On the taskbar of this Report Manager website homepage, there is a button for Report Builder, and when you click this, it's going to download and install the Report Builder application on your machine. You may have to agree to a couple of security questions the first time you do this.

So what we're opening here is Report Builder 3.0, and that's whether you're using SQL Server 2008 R2 or SQL Server 2012; you just see a different splash page for SQL Server 2008 R2. And as soon as the application Report Builder opens, we get the Getting Started page, with several options for creating reports with table wizards and chart wizards and map wizards. For the first one I'...

Creating a report with Report Builder
Video duration: 12m 11s 3h 44m Advanced

Viewers:

When creating a report with Report Builder, you will use a tool called the authoring tool. This video shows you where to find this tool and how it works. Because it is an online tool, there may be some security questions for you to answer the first time you access the site. Once signed in, you will see the Getting Started page, which provides several report building options to help you create a unique report to suit your needs.

Subjects:
Developer IT
Software:
SQL Server
Author:
please wait ...