Click here to Skip to main content
15,868,016 members
Articles / Programming Languages / C#
Article

Getting started with SQL Server Reporting Services

Rate me:
Please Sign up or sign in to vote.
4.60/5 (37 votes)
7 Apr 20064 min read 299.3K   85   22
This tutorial provides a starter to the SQL Server reporting services

Introduction

Microsoft has come up with its own reporting service, in conjuction with SQL server database to introduce the Microsoft SQL Server Reporting services[SSRS]. It provides projects of type Business Intelligence Project thus enabling not only large companies but also medium-sized and small companies also to earn from its benefits. This aids in better business decisions too.

SSRS provides several extensions towards the data rendering, delivery and security of reports thereby allowing it to have a higher programmable ability. This innovative approach enables reports to be created with lesser development effort[compared to other reporting services], along with customized security options.

SSRS is a comprehensive reporting platform whereby reports are stored on a centralized web server (or set of servers). Because reports are centralized, users run reports from one place. Having centralized reports also means that report deployment is quite simplified.

Architecture

After using SSRS, the architecture is just like a small operating system. The Report Manager is the central person who acts as a manager to decide when the reports will be scheduled to run along with maintaining the user profiles on the report server. Also, you can ask the report manager to view or search certain reports. He also helps in site property configuration and folder management in the report server. 

There is something known as a Report Server, at which all the reports reside. All other activities pertaining to SSRS is done at report server. I believe it acts like a workstation for the reporting tool.

Report Designer is basically a graphical tool that are hosted within the Microsoft Visual Studio IDE. Report Designer provides a tabbed windows for Data, Layout, and Preview that allow you to design a report interactively. You can add datasets to accommodate a new report design idea, or adjust report layout based on preview results. Also, he provides query builders, an Expression editor, and wizards to step you through the process of creating a simple report.

There is also a Scheduling and Delivery processor who pushes the reports to email inboxes or ftp locations. Like an operating system the adds processes to the queue, the Scheduling and Delivery processor adds processed[executed by the report processor] reports to the queue. 

The Report Processor, as the name suggests, executes the reports present in the server. Now that we know the basics of SSRS, lets get starting with our first report. 

Getting Started

After installing SQL server reporting services on your system, start the Visual studio IDE.

Go to File -> New Project, and you will be shown a prompt with 'New project'.

Select Business Intelligence Projects from the Project Types. As this is our first project, use Report Project Wizard in the templates pane.

New Project

Specify the name of the project as well as the location where the project will be placed.

On click of OK, you will be prompted with a report wizard screen. Click on Next to follow up to the next screen.

Report wizard

On the next screen, you will need to create a datasource for the report. This screen is similar to the Connection string creation wizard on creation of a udl file. However, here you just need to click on Edit to specify the server name and the database the will be used from that server. The connection string is automatically created.

This datasource can be made as a shared datasource for multiple reports to access. This can be done by checking in the checkbox present below.

Select Datasource

On click of Next, you will be prompted with the Query Builder screen. Here you can add tables, select columns as well as execute the SQL statements therby created.

Query Builder

Adding Tables

Running query

Based on what query suits your report, create the SQL statement and proceed forward. On next click, you will be prompted with the report type screen. You can choose as Tabular or matrix. To make things simpler, use the Tabular format.

Select report type

On next click, you will come to the table designing screen, wherein you will be prompted to display the fields as Page, Group or Details. The relevant locations where the fields will be placed is shown at the side.

Table design

On next click, you will be prompted with the Table Style prompt, which contains a list to choose. Select any from them .

Table style

On next, you will be prompted with the deployment details screen. Specify the report server name ; normally it is http://localhost/ReportServer. if you are using another server then you can specify the location as http://servername/ReportServer . Also provide in the deployment folder.

Deployment

Finally, the Report name needs to be entered and voila, you got your first report in place.

Report name

You can preview the report to change the data specs using the 3 tabs from the report designer - as mentioned previously.

report designer

report designer

report designer

Finally, click on Ctr+F5 and the deployment of the report will occur.

Final report

Incase you have any problems in creating your SQL server report, please let me know.

 

 

 

 

License

This article has no explicit license attached to it but may contain usage terms in the article text or the download files themselves. If in doubt please contact the author via the discussion board below.

A list of licenses authors might use can be found here


Written By
India India
Soshan is a software engineer, currently working in variant projects. She does her programming in stuff like Assembler, C++, MFC and lots of web- and database stuff and now uses ASP.NET and C# extensively, too.

In her free time, she works in animation stuffs with extensive usage of Adobe Photoshop and CorelDraw. Driving racer cars is her current craze.

Whenever she gets bored, her interests goes on to networking and hacking-ethical. Has designed an ip-filter for firewall with a group of friends.

Comments and Discussions

 
GeneralGood Job Pin
Alireza_13621-Apr-16 5:49
Alireza_13621-Apr-16 5:49 
QuestionProblem with SSRS Authentica​tion - don't want to use Custom Authentica​tion - Please guide Pin
Member 1069685125-Mar-14 4:28
Member 1069685125-Mar-14 4:28 
QuestionHow to connect with .Net Pin
jaimin8526-Dec-13 20:36
jaimin8526-Dec-13 20:36 
Questionhow to connect with .net page Pin
jaimin859-Oct-13 0:55
jaimin859-Oct-13 0:55 
AnswerRe: how to connect with .net page Pin
Soshan Fernandes10-Oct-13 8:15
Soshan Fernandes10-Oct-13 8:15 
GeneralMy vote of 5 Pin
Mangal Deep Gupta1-Aug-13 2:48
Mangal Deep Gupta1-Aug-13 2:48 
GeneralMy vote of 1 Pin
Menon Santosh12-Jul-13 23:10
professionalMenon Santosh12-Jul-13 23:10 
QuestionAbout SSRS Pin
farooqueali24-Mar-13 21:24
farooqueali24-Mar-13 21:24 
Question5+ points... SSRS can be use locally for Winforms Pin
Aarti Meswania2-Jan-13 19:36
Aarti Meswania2-Jan-13 19:36 
I don't want to deploy report on web

can I use it locally as I use crystal reports because I need it for winforms Smile | :)
please clear my doubt Blush | :O
Thank you!
It's easy to learn with screen-shots.
nice article My 5+
GeneralMy vote of 5 Pin
mohan5k25-Sep-12 3:02
professionalmohan5k25-Sep-12 3:02 
GeneralMy vote of 1 Pin
Thunder Storm8-Aug-12 21:55
Thunder Storm8-Aug-12 21:55 
GeneralMy vote of 5 Pin
prabhakar.slm26-Jun-12 22:45
prabhakar.slm26-Jun-12 22:45 
QuestionI am getting reporting service login alert Pin
Bangla Gopal Surya Prakash28-Nov-11 17:42
Bangla Gopal Surya Prakash28-Nov-11 17:42 
GeneralMy vote of 5 Pin
tareq_moinul4-Oct-11 19:24
tareq_moinul4-Oct-11 19:24 
GeneralMy vote of 5 Pin
Member 426829130-Aug-11 2:51
Member 426829130-Aug-11 2:51 
GeneralMy vote of 5 Pin
adeelisb26-Apr-11 8:33
adeelisb26-Apr-11 8:33 
GeneralNice Example Pin
chitraPadmanaban4-Nov-09 0:57
chitraPadmanaban4-Nov-09 0:57 
GeneralGood simple example Pin
SarinP12-Jan-09 5:21
SarinP12-Jan-09 5:21 
GeneralDoubt in SSRS Pin
VSathish23-Dec-08 20:23
VSathish23-Dec-08 20:23 
GeneralRe: Doubt in SSRS Pin
Soshan Fernandes26-Dec-08 19:12
Soshan Fernandes26-Dec-08 19:12 
QuestionLine and Bar Graph Pin
singhswat23-Mar-08 18:27
singhswat23-Mar-08 18:27 
GeneralThanks a lot!! Pin
Domingo M. Asuncion11-Mar-07 16:03
Domingo M. Asuncion11-Mar-07 16:03 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.