You are designing a SQL Server Reporting Services (SSRS) solution.
A report project must access multiple SQL Azure databases. Each database is on a different host.
The databases have identical schema and security configurations.
You have the following requirements:
The report must support subscriptions.
Users must be able to select the host when running the report.
What should you do?
To answer, drag the appropriate phrase or phrases from the list to the correct location or locations in the answer area. (Answer choices may be used once, more than once, or not all.)
Select and Place:
Correct Answer:
Explanation/Reference:
Note:
* To include data in a report, you must first createdata connections, also known asdata sources, and then create datasets.
* A data connection includes the data source type, connection information, and the type of credentials to use. There are two types of data sources: embedded and shared. An embedded data source is defined in the report and used only by that report (fits this scenario). A shared data source is defined independently from a report and can be used by multiple reports.
* Built-in data extensions include the following data connection types:
Etc.
* Expression-based connection strings are evaluated at run time. For example, you can specify the data source as a parameter, include the parameter reference in the connection string, and allow the user to choose a data source for the report.
* Credentials You provide the credentials that are needed to access the data. The data source owner must have granted you the appropriate permissions to access both the data source and the specific data on the data source.
Reference: Data Connections, Data Sources, and Connection Strings (SSRS)