SSRS Tutorial for Beginners

My Learning: Log in Learning Report [Log in]

Remove Ads or Log in
Remove Ads or Log in
+0  |  -0

Mini Learning Map

Welcome to our SSRS Tutorial for beginners. Most of our content is developed using SSRS 2012 and most of it should be the same in 2008 R2 and 2008 (without new features). SSRS 2005 and earlier may vary significantly.

Sample Data: You can follow the articles/videos using AdventureWorksDW2012. Click the following link to Download and Install and AdventureWorksDW2012

New Videos: You can vote for new SSRS Video Requests (or create your own request).

Remove Ads or Log in

We need you!

By becoming a proud member we can:
  • Switch off annoying ads
  • Create more articles and videos
  • Develop more useful features supporting your learning
  • Provide FREE webinars (for members)
  • Feel our hard work since 2011 is appreciated
Become a proud member and get exclusive features.

If 2% of our 64,943 visitors (Last 30 days) become a proud member than we can quit our jobs and work full time on this website. We started membership in May 2014 and so far 0.07% of our visitors are members and we would like to say THANK YOU to those who become a proud member and support our efforts.

Thanks to members:
  • Education is for FREE and we create more FREE articles and videos
  • We provide new features (members) that can speed up learning.
  • 53% of our page views (82,000 each month) do not have page ads.
  • We switched video ads from 14% of our videos (50 out of 345).
We have invested 4 years of our time in this website and we estimate it will take about 5 years before we can quit our jobs and dedicate all our time to develop considerably our website which should help to truly achieve our vision of free education for everyone; all thanks to support of our members only. Become a proud member

Visitor Voting

Do you enjoy your job?
Visitor Voting: Yes +15  |  No -5
Add comment (no email required).

Add Comment
Date Posted: 4/16/2012 1:20:06 AM

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

Name: Ratheesh Kumar R
Date Posted: 4/26/2012 10:09:37 AM

Nice Work !! Got a Hand on SSRS :) Thanks a Ton !!

Name: Veerendra
Date Posted: 5/15/2012 6:20:22 AM

HI Reddy,

Please let know how to create a Charts in SSRS reports with Examples.




Name: Nag
Date Posted: 7/4/2012 6:48:21 AM

Hi Katie and Emil,

Your tutorials with screesnhots are very helpful.

I have a quick question for you.

If i want to add a box around a group of text fields what is the best way of doing it?



Name: Emil
Date Posted: 7/5/2012 8:06:41 AM

Hi Nag,

I'm not entirely sure what you mean. If you are after some kind of border than you can add in SSRS extra rows/columns and set border style or add a rectangle from toolbox. It's difficult to say what will work in your case as I don't fully understand your requirement.




Name: Nag
Date Posted: 7/6/2012 4:19:38 AM

Hi Katie,

Yes i was talking about border.

I got it with a rectange control.



Name: saikat malakar
Date Posted: 10/11/2012 6:12:12 AM

Dear Sir/Madam,

I would like to inform you that i am a very new user to SSRS. I learn the basic things and able to make the reports. I am using VS 2008 and BIDS. But i can't move further. I want to use the dynamic data source.  Let me clear my issue one by one.

1. First of all user should input four credential a)Server name b) database name c) user id 4) password. It will help to make the connection with database and make the data source. The credential should be store in session or cookie.

2. Now the user will be able to see all the reports without giving the credential because he/she already given.

I made a dynamic data source but the credential is asked for every time when i open a report.

It will be highly obliged if you kindly solve my issue and give me the solution as soon as possible. It will be highly appreciated if you guide me through a demo project or an article.

Name: tejas
Date Posted: 10/16/2012 6:18:45 AM

Hi i am trying to select multiple values in paramtere i have tried by using query it is working but it is not working using stored procedure can you please tell me how to use comma seperator in stored procedure? 

Name: Mudit Srivastav
Date Posted: 10/16/2012 7:11:08 AM

I have 6 years of exp in dotnet technology now i want to move in BI technology...I have seen these tutorials its very nice and helpful for new person.




Name: Emil
Date Posted: 10/18/2012 7:57:13 AM

Hi Saikat,

I presume you are using SQL Authentication for data source (not windows authentication). If that is the case than you have limited options as you might not be able to identify user and provide "default value" or used previously value (using standard report manager, unless you use reportviewer control). This subject is slightly more compherensive so if you want to discuss it send me an email (contact us tab).

Name: Emil
Date Posted: 10/18/2012 7:59:40 AM

Hi tejas,

We currently don't have in our SSRS Tutorial article that would show how to do it (I will add it to wish list) but short answer is you do that by using JOIN or SPLIT function in SSRS (I don't remember if you use both or one) and then in StoredProcedure you need to create a function that will perform SPLIT based on your delimited (I often use | )

Hope that helps

Name: Lokesh
Date Posted: 10/23/2012 9:52:26 AM

Hi Katie and Emil,

Actually I am using this SSRS tool to build report for Microsoft Dynamics CRM online. I want to display the counts of accounts(dataset name=business), sales(dataset name=sales) and contacts(dataset name=contacts) entity for each Relationship Manager. Each entity will have diffrent dataset likely so I can get the count of Accounts that each managers have.  But how to get the counts of sales and contacts those bound to diffrent dataset? Please help me out with this. Thanks

Name: Emil
Date Posted: 10/23/2012 5:03:46 PM

Hi Lokesh,

Your questions is slightly unclear to me but I will try to provide information that may point you in the right direction.

I understand that you want to develop 3 different datasets in one report. If they are for 3 different elements (tables) inside the report that might be fine if not it might be better to create one dataset.

If you have to stick with 3 than you have option to add addition SQL to calculate it in ddataset (or MDX if you use cubes) or you can refer to another data use using simply aggregate function like SUM or Count. The trick with aggregate function is to use condition and change scope to a different data set (if you use SSRS 2008 R2 in some cases you may be able to also use new Lookup function).

If you have any more question please feel free to use 'contact us' at the top and send us a email.

Take care



Name: Tanooj
Date Posted: 12/31/2012 6:02:04 AM

Hi guys,

New to SSRS world, just i need all tools in bids toolbox..please assist me how to get them..


Thank u in advance

Name: Moulaye
Date Posted: 2/4/2013 10:38:57 AM


Big thanks for this interesting tutoriels .

Best Regards



Name: Laxman,India
Date Posted: 3/1/2013 9:07:16 AM

Hi you both,

I became a big fan of you...

Thank you very much.

You are doing great job.......

Name: Chris
Date Posted: 4/19/2013 6:00:59 PM

Hello. Nice site, thanks for putting this together. I wanted to ask if you have any plans to do a tutorial on creating a drillthrough report. Or do you recommend always using subreports when the goal is to create a top-level report, and then allow the viewer to click on a report item and see the details of the data for that selected item? Thanks.

Name: Emil
Date Posted: 4/21/2013 2:07:39 PM

Hi Chris,

Drillthrough is very popular and can be really useful. Katie has been recently thinking about adding some new videos about SSRS and she will most likely cover drillthrough first.

Take Care


Name: ahmed oraiqat
Date Posted: 4/25/2013 10:27:06 AM


how can I deploy reports to any website?

I have some reports designed in ssrs and  I need to publish this report direct to my web site which is hosted in deffirent location . I dont want to use sharepoint ,


Name: Emil
Date Posted: 4/25/2013 4:08:56 PM


You can use rs.exe command tool or upload manually from report mananger.

Take care


Are you a member?

If yes than please log in

Learning Map is for members with Bronze, Silver and Gold Membership.
For more information visit membership options.

Close this window , log in or learn more about membership benefits
  Become a Proud Member