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 : 5462 | Status : [Member] | Replies : 3
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.



Responses

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

Up
0
Down
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

Up
0
Down
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

Up
0
Down
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

Login to post response