Getting Started with SSRS

Let us now take a look, how to generate a report using SSRS.

1) Open your Visual Studio

2) Click on File >> New >> Project

3) A Dialog Box will open from which select the Report Server option under the Business Intelligence Projects, as Shown below.

Add New Report Server Project

Add a New Report Server Project

4) Now, Go to the Solution Explorer >> right click on Shared Data Sources folder and Select “Add new DataSource” >> A dialog will open where you can provide the DataSource name and connection string details.

Add a new Data Source

Add a new Data Source

5) Now, right click on the reports folder >> Select  “add a new report” >> A Report wizard will appear

Report Wizard

Report Wizard

6) In the Report Wizard write your Query and View it from the Query Designer.

Design the Query

Design the Query

Query Designer

Query Designer

7) Select the View of the report and select the elements to be displayed and grouped and Click Finish. In the image below we are grouping the report based in PayFreequency column.


Grouping the reports

8) Give a Name to your Report.

Name the Report

Name the Report

9) Now, your report will be generated with the extension .rdl that can be found in under the reports folder. In the design view, we will be able to align and format the reports where as we pan preview it using the Preview Tab.

Design View

Design View





குருதி சிந்தி பெற்ற சுதந்திரம் கொண்டு பிறர்
குருதியை உறிஞ்சும் கொடுமை ஏனோ?

பெண்ணை பேணிகாக்கும் எண்ணம்கொண்ட சுதந்திர நாட்டில்
அவள் பாதுகாப்புக்கு பாதகம் தான் ஏனோ?

ஒற்றுமையாய் இணைந்துவென்ற ஒற்றைலட்சியமம் சுதந்திரத்தை
கூறிட்டு  கொலைசெய்யும் கொடூரம்தான் ஏனோ?

முப்புறமும் கடற்கரையும் மறுபுறத்தில் இமயமும் சூழ்ந்தவளே
ஆழ்பவரும் செழித்து வாழ்பவரும் கறைபடுத்தும்  இமாலயஊழல்கள் ஏனோ ?

அன்பிற்கும் பண்பிற்கும் பிழையல்ல பண்பாட்டிற்கும் பெயர்போனவளே
உன்பிள்ளைகள் பங்காளித்தகராற்றில் நிலதிகும்-நீருக்கும் அடித்துகொள்ளும் அவலம் ஏனோ?

தவமிருந்து பெற்றபிள்ளை சுதந்திரம் அதை குறைமாதத்தில் பிரசவித்தாயோ?
தாயே,  இல்லைக் குறைகளுடன் பிரசவிதாயோ?

SSRS – an Introduction

SSRS stands for SQL Server Reporting Services, a widely used Microsoft Technology for developing dynamic reports.

The executables for SSRS are known as rdls, Report Definition Language which is a mark up language which resembles like a XML when you view it in code view.

(SSRS files will have the extention as .rdl that has to deployed in the Report servers for using the application)

In order to develop SSRS reports we need to have the SQL Server R2 installed in our machine, with the Visual Studio Report Development IDE supporting the SQL server version.

In order to make use of the deployed rdl files in the report servers, we have to make use of the ReportViewer control, through which the Report can communicate with the website.

The main advantage of SSRS is, we can use various data sources like SQL Server, Azure, Oracle to generate the reports.

The effeciency of the Reports depend on the Queries we design.

It is always an advantage for a SSRS beginer to handle the most of the functionality in the Queries instead depending on the development interface.

Also, databases will always have a edge over the development server. So when you dont have huge logical dependencies in the Report side, your report will render very soon.