What are DataSource and DataSets in SSRS? Benefits Of Shared DataSource And Shared Datasets?
What are DataSource and DataSets in SSRS? Benefits Of Shared DataSource and Shared Datasets? If you need to show information from the da...
If you need to show information from the database to your one of reports you need to create both dataset and datasource.
A DataSource is a pointer to location of all your information from where you are retrieving or extracting data for your reports.
A Dataset is specific collection of your columns and records displayed in reports.
A Shared DataSource is Shared through out reports, you need not to create a datasource again and again while developing new SSRS Reports. Benefits in if you have different environments Like UAT ,Prod etc. with different DataBase Name, then you only need to change database name at one place that will reflect in all Reports.
A Shared DataSet is reused and you need not to create a dataset if same columns and structure is required in another report.Benefits in, if you are populating the dropdown parameter values with the DataSets and same parameter is to used in some another reports, than its handy to create a shared DatSets and use them which saves time and work to recreate a Query.