SSRS Tutorial

Hi,

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

Thanks

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.

thanks your article are very helpful MSBI beginners .

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

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

SSRS

HI Reddy,

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

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

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

Hi Katie,

Yes i was talking about border.

I got it with a rectange control.

Thanks

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.

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? 

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.

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).

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

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

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

Hi, 

I can not download the PDF file into my pc . Can you please make one pdf file so we can download it.

thanks

Viral

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

Good job

Hello, 

Big thanks for this interesting tutoriels .

Best Regards

Moulaye

Hi you both,

I became a big fan of you...

Thank you very much.

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

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.

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

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 ,

Hi

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

Take care

Emil