Floating FB popout byF5debug

SQL Server Reporting Services (SSRS) – Part 1- Basics on how to create a report

 

This is part 1 of series of article on SSRS and we shall know basics on how to create a report in SSRS.

Introduction

SQL Server Reporting services are very good feature provided in SQL to build a report of user choice and deploy it to make use of it anywhere as per the requirement. In this article we are going to see on how to create a simple report then build and execute the report. Reports can be exported to multiple formats including delimited text, XML format, pdf format and Microsoft Excel as well.

[more]

Let s jump into the process and see the step by step process on how to create and execute an SSRS report.

Steps:

Go to SQL Server Business Intelligence Development Studio and create a new project as shown below

clip_image001

Now a wizard will / may open based on the existing option selected just skip that window if it opens by giving Next. It will open a new window which shows the basic configuration as shown in the below screen

clip_image002

Next window will show an option to build a query based on which the result set will be displayed as a report. We can write our own query to fetch the output as shown in the below screen.

clip_image003

Clicking on Next will open a window which have the option to select on how the result should display as shown in the below screen

clip_image004

Clicking on Next will open the below window, if you can see the option here to group the data and show as per our requirement

clip_image005

Clicking on the Next button will open a window which gives option to design the report based on the templates available as shown in the below screen

clip_image006

Now clicking on the button the interesting thing comes over, which is nothing but where to deploy the report. We can give as per our requirement

clip_image007

Clicking on Next will open a window as shown in the below screen. Here we can give our customized report name

clip_image008

Clicking on Finish will open a window as shown in the below screen, which shows the structure of the report as shown below

clip_image009

Now press F5 to build and execute the process. It will show the result as shown in the below figure

clip_image010

Conclusion

So in this article we have seen on how to create, build and execute a basic report using SQL reporting services.

About Author: Karthikeyan Anbarasan, Microsoft MVP (Most Valuable Professional) in ASP.NET/IIS Architecture. He is the Founder and Chief Editor of the www.f5debug.net website and has authored books on Windows Phone and Business Intelligence(SSIS). He is also a Passionate Speaker and a Blogger on Microsoft Technologies.

You can Join Me On: Facebook, Twitter, Google Plus, LinkedIn

Comments (1) -

chandan
chandan
7/1/2013 5:04:17 AM #

Started reading your blog, hope i wil be able to learn.
Thanks for posting

Add comment

  Country flag

biuquote
  • Comment
  • Preview
Loading

Recent Posts

Random Posts

Most Viewed

URL Shortner

Create your own short urls!!!

Site Counter

free counters

Disclaimer

This is a personal weblog. The opinions expressed here represent my own and not those of my employer. For accuracy and official reference refer to MSDN/ TechNet. I have documented my personal experience on this blog.

Protected by Copyscape Web Plagiarism Finder

Site Meter