Data source,Dataset Create ,Design report List report in SSRS

 Data Source:

Data source means a connection string to a particular db system. In ssrs we have two types of data sources.

1. Ordinary Data source
2. Shared Data Source

Ordinary Data source:

Data source connection string maintain in particular report. It’s not reusable in the product.

Shared Data Source:

Data source connection string maintains in connection file (rds).
It can be reusable for multiple reports in the application.

In SSAS and SSIS2008 we have only shared Data source.


Dataset means in-memory result set structure prepared based on query or stored procedure.
Dataset populated with actual rows at the time of report execution.

A report requires at least one dataset.
A report can use multiple datasets.

 A list data region repeats with each group or row in the report dataset.
List region does not have any built -in – layout.
It’s free from layout.
List can display detailed data and aggregated data with the help of other report items.
List can support only one grouping that is on entire list.
A report item placed in the list can be repeated from each row in the dataset/each group in the dataset.

Click the below video to learn more about  Data source,Dataset Create ,Design report  List report  in SSRS

About Author: author 4 + years of Information Technology experience in understanding and analyzing the software and hardware engineering requirements, onsite and offshore management of product development. Expert work on design and development for windows,web,mobile Expert knowledge of C#,ADO.NET, ASP.Net MVC, ENTITY FRAMEWORK, LINQ,COLLECTIONS, JAVASCRIPT,AngularJs 1.0,Angular2, Jquery,Jquery-Ajax, SQL SERVER, XAML,Windows phone 8.1 Good knowledge of WCF-Restful services,WCF, WEB API-Services ,Web- Services,MIcrosoft-Azure,JUICE UI,HTML,CSS,AJAX Read More...

Join him on Google+ | Facebook | Linkedin

No comments