Home >SQL Server >SSRS

SSRS Tutorial

Welcome to our SSRS Tutorial. On this page we will show you how to create reports in SSRS we will post both simple examples but also more complex ones that you can find useful. For the purpose of this SSRS Tutorial we will use SQL Server Reporting Services 2008 R2 but most of this tutorial should work with 2008 (apart from new features) and 2012.

We covered SSRS basics and several more advanted topis; we will try to add new SSRS tutorials frequently but if you have anything specific in mind let us know and we will try to add it as well.

Below is a list of SSRS tutorial and short description.

SSRS Tutorials:

SSRS Create a simple report	This SSRS Tutorial shows you how to create a very simple report with loads of screenshots and it is relatively short focusing only on key parts to help you create your first report.
SSRS Create a simple parameter	We will show you how to create a very simple parameter and filter your dataset using the parameter. It covers only basic text filter but should allow you to quickly pick you new knowledge on a very simple example.
SSRS Drop Down Box Parameter	In here we show how to create a drop down box parameter that can be used to filter chart on a report.
SSRS Create a subreport with parameter	We will show you how to create a subreport and pass parameter from main report to subreport. This is a very simple example that should help you understand the basics of creating a subreport and parameters.
SSRS Create Sparkline chart	Sparklines are very popular in data visualization. We will show you how to create a sparkline which is a also known as trend line. This tutorial applies only to SSRS 2008 R2, and SSRS 2012 which contains new data visualization items in toolbar.
SSRS Concatenate two string fields	Concatenation is very common in reporting and in this SSRS Tutorial you will find out example how to do it.
SSRS table initial sorting	In this post we will show how to apply table initial sorting (default sorting)

SSRS IIF Expression

SSRS median function 2008 R2

SSRS Percentile function 2008 R2

SSRS Alternate Row Color

SSRS Export to Excel - formatting

SSRS Decimal Format

SSRS Thousands Seperator

SSRS XML

SSRS XSLT

The feature: "Shared dataset" is not supported in this edition of Reporting Services

SSRS Interview questions and answers with PDF Download

SSRS Report Builder 3.0 permissions

NEWS:

I invite everyone to SQL Server Conference SQL Bits X in London (UK) 31st of March (Saturday) 2012 (1h session) for our session about SSRS and decision making SSRS vs Google Analytics. Decision making

Session and entire day is for FREE but there is limited availability so book early.

UPDATE (15 Feb 2011): Session is fully booked. Those who cannot attend can still view the session at SQL Bits website after video is publish which usually takes 1-2 months.

I hope you will like our SSRS tutorial. We will try to add new ones soon.

Take care

Katie & Emil

News & Updates: Follow @katieglownia Follow @emilglownia

You like it? Share it!

Comments Add Comment

Name: Rajendarreddy
Comment:

Hi,

You added some topics only.you can add more important and commonly used topics.It is very useful for us

Thanks

Date Posted: 09/02/2012 6:34:37 AM

Name: Emil
Comment:

Hi Rajendarreddy

My wife is working on new articles and we hope to publish about 10 new ssrs tutorial posts in the next 2-3 weeks.

Date Posted: 10/02/2012 6:53:30 PM

Name: vikas
Comment:

thanks your article are very helpful MSBI beginners .

Date Posted: 12/03/2012 12:17:56 PM

Name: YUVRAJ
Comment:

Thanks guys you are doing a great job.....keep it up

Very Nice tutorial easy to understand even for High School kids also....really i appreciated the work....thanks a lot