What is difference between Shared Data Source and Shared Data Set?

Posted by Sudheep.Grandhe under Sql Server on 11/5/2014 | Points: 10 | Views : 9935 | Status : [Member] | Replies : 3

Write New Post |

Search Forums | Answered

Resolved Posts |

Un Answered Posts |

Forums Home

Hi Team,

I would like to know the answers for the below questions. These questions are faced in interviews for SSRS.

1.What is difference between Shared Data Source and Shared Data Set?

2.What is Subscription in SSRS?

3.What are types of Subscription available in SSRS?

4.What is difference between Standard and Data Driven Subscription?

5.What is clickthrough report?

Regards,
Sudheep.G

Best,
Sudheep.

Reply | Reply with Attachment

Alert Moderator

Responses

Posted by: Bandi on: 11/6/2014 [Member] [MVP] Platinum | Points: 25

0	Data Source: The connection you need to make to get your reports data is called a data source. it can be a source database for the reports Data Set: If you connected to a data source (like the test database) there may be hundreds of tables. You probably only want data from just a few tables. This means you want to write a specific query against this data source. A query on a data source to get just the records you need for an SSRS report is called a Data Set. Simply, Data source is Database Connection whereas Data set is the query which pulls/fetch required data for the report There are two different types of data sources/sets i.e. Embedded data source and Shared Data Source; Embedded Data Set and Shared Data Set Shared Data Source means the data source which is accessible to all reports within project. Embedded Data Source means it is report-specific connection... refer http://blog.sqlauthority.com/2013/07/26/sql-server-data-sources-and-data-sets-in-reporting-services-ssrs/ to understand the differences better Mark This Response as Answer -- Chandu http://www.dotnetfunda.com/images/dnfmvp.gif Sudheep.Grandhe, if this helps please login to Mark As Answer. \| Alert Moderator

Data Source: The connection you need to make to get your reports data is called a data source. it can be a source database for the reports
Data Set: If you connected to a data source (like the test database) there may be hundreds of tables. You probably only want data from just a few tables. This means you want to write a specific query against this data source. A query on a data source to get just the records you need for an SSRS report is called a Data Set.

Simply, Data source is Database Connection whereas Data set is the query which pulls/fetch required data for the report

There are two different types of data sources/sets i.e. Embedded data source and Shared Data Source; Embedded Data Set and Shared Data Set

Shared Data Source means the data source which is accessible to all reports within project.
Embedded Data Source means it is report-specific connection...

refer http://blog.sqlauthority.com/2013/07/26/sql-server-data-sources-and-data-sets-in-reporting-services-ssrs/ to understand the differences better

Mark This Response as Answer
--
Chandu
http://www.dotnetfunda.com/images/dnfmvp.gif

Sudheep.Grandhe, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Bandi on: 11/6/2014 [Member] [MVP] Platinum | Points: 25

0	SSRS subscriptions are an easy way to automatically run and deliver SSRS reports. You can schedule reports to run at a regular interval and deliver to file share, e-mail, or a SharePoint document library Mark This Response as Answer -- Chandu http://www.dotnetfunda.com/images/dnfmvp.gif Sudheep.Grandhe, if this helps please login to Mark As Answer. \| Alert Moderator

Posted by: Bandi on: 11/6/2014 [Member] [MVP] Platinum | Points: 25

0	There are two types of subscriptions in SSRS; Those are Standard and Data-Driven subscriptions. Standard Subscription: A standard subscription consists of static values that cannot be varied during subscription processing. For each standard subscription, there is exactly one set of report presentation options, delivery options, and report parameters. i.e. There is no chance of changing report params, delivery options and so on in standard subscription process to automate execution & delivery of reports Data-Driven Subscription: Data-driven subscriptions get subscription information at run time by querying an external data source that provides values used to specify a recipient, report parameters, or application format. i.e. its a dynamic subscription Mark This Response as Answer -- Chandu http://www.dotnetfunda.com/images/dnfmvp.gif Sudheep.Grandhe, if this helps please login to Mark As Answer. \| Alert Moderator

There are two types of subscriptions in SSRS; Those are Standard and Data-Driven subscriptions.

Standard Subscription: A standard subscription consists of static values that cannot be varied during subscription processing. For each standard subscription, there is exactly one set of report presentation options, delivery options, and report parameters.

i.e.
There is no chance of changing report params, delivery options and so on in standard subscription
process to automate execution & delivery of reports

Data-Driven Subscription: Data-driven subscriptions get subscription information at run time by querying an external data source that provides values used to specify a recipient, report parameters, or application format. i.e. its a dynamic subscription

Mark This Response as Answer
--
Chandu
http://www.dotnetfunda.com/images/dnfmvp.gif

Sudheep.Grandhe, if this helps please login to Mark As Answer. | Alert Moderator

Latest Posts