Learn more about SQL Server tools

mssqltips logo

Tutorials          DBA          Dev          BI          Career          Categories          Webcasts          Scripts          Today's Tip          Join

Tutorials      DBA      Dev      BI      Categories      Webcasts

DBA    Dev    BI    Categories


SQL Server Reporting Services (SSRS) Tutorial


SQL Server Reporting Services 2008 (SSRS) is a feature included in the SQL Server 2008 product.  We use SSRS to design, develop, test, and deploy reports.  SSRS was originally slated to be released with SQL Server 2005 but it wound up being released a little bit ahead of SQL Server 2005.  SSRS leverages the Business Intelligence Development Studio (BIDS) developer tool for all aspects of authoring and deploying reports.  BIDS is included with SQL Server 2008.

In this tutorial we will step through a number of topics that you need to understand to successfully build a report.  Our high level outline is as follows:

  • Reporting Services Components
  • Install Reporting Services
  • Business Intelligence Development Studio (BIDS) 
  • Install Sample Database
  • Create a Simple Report with the Wizard
  • Create a Simple Report with the Report Designer
  • Deploy Reports
  • Configure Report Manager Security

To step through the tutorial topics, use the outline to the left, the arrow buttons next to the outline topic heading, or the arrow buttons at the bottom of each page.

Additional Information

Last Update: 1/5/2010

More SQL Server Solutions

Post a comment or let the author know this tip helped.

All comments are reviewed, so stay on subject or we may delete your comment. Note: your email address is not published. Required fields are marked with an asterisk (*).

*Name    *Email    Email me updates 

Signup for our newsletter
 I agree by submitting my data to receive communications, account updates and/or special offers about SQL Server from MSSQLTips and/or its Sponsors. I have read the privacy statement and understand I may unsubscribe at any time.


Tuesday, April 10, 2018 - 12:05:21 PM - Chris Wineinger Back To Top

 I’m trying to setup anonymous access to ssrs reports, but I get 401.3 errors for anyone not an administrator on the server. There is a domain here and everyone is authenticated there. Can I use that authentication for permissions or a way to accept non admin people to see the ssrs reports?


Tuesday, December 19, 2017 - 12:16:10 PM - Joey Back To Top

 I have created a report that I need to add a parameter to.  I know how to add a basic parameter but I want to add a parameter that is based on a "calculated" field in the report.  I am not sure how to do this.


In my script I have an enbeded select and I want a parameter so I can limit the results of the report to be 'ABC' or '123' or 'Both'.  

(select case when count(*) > 0 then 'ABC' else '123' end

from table A AS ct1

Where  ct1.id =  ca.id

and ct1.tag_id = 752  --(this tag id is ABC)

) AS 'Tag'




Friday, September 09, 2016 - 1:12:57 AM - Ashish Rohit Back To Top

Respected Sir,

I want to lern SQL Srver Reporting, So that Please provide me readeing guidence and material.

I will be greate full to you.

THank You Sir.

Learn more about SQL Server tools