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

Learn more about us

Who are we?

Where do we come from?

We want our visitors to know our story but we want our visitors to help us create it!

If you are interested in knowing a bit more about us than let us know and we will record a video with an answer (Webcam not just screen ;) and publish it on our website.

Submit your question

Visitor Voting

Do you find our website helpful?
Visitor Voting: Yes +74  |  No -1
Add comment (no email required).



Add Comment
Name: YUVRAJ
Date Posted: 4/16/2012 1:20:06 AM
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




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

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




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

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
Comment:

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?

Thanks

Nag




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

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.

Regards

Emil

 




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

Hi Katie,

Yes i was talking about border.

I got it with a rectange control.

Thanks

 




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

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
Comment:

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
Comment:

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
Comment:

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 asp.net 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
Comment:

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
Comment:

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
Comment:

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

Emil

 




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

Hi guys,

New to SSRS world, just i need all asp.net 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
Comment:

Hello, 

Big thanks for this interesting tutoriels .

Best Regards

Moulaye

 




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

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
Comment:

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
Comment:

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

Emil




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

Hi,

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
Comment:

Hi

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

Take care

Emil