3/21/2023 0 Comments Fastcut shared database![]() ![]() If the report server runs in SharePoint integrated mode, you can use the application pages on a SharePoint site. If the report server runs in native mode, you can create and configure the shared data source in the web portal. To create a shared data source or modify its properties, you must have Manage data sources permissions on the report server. Creating and Modifying Shared Data Sources The query is always kept within a report definition. For more information, see Specify Credential and Connection Information for Report Data Sources.Ī shared data source does not contain query information used to retrieve data. Specifies how credentials are obtained for the connection and whether they are to be used after the connection is made. For more information and to view examples of connection strings to frequently used data sources, see Create data connection strings - Report Builder & SSRS. For more information about data processing extensions included with Reporting Services, see Data Sources Supported by Reporting Services (SSRS). You can only use data processing extensions that are deployed on the report server. The data processing extension used with the data source. If you plan to use report models for ad hoc reporting, you must create and maintain a shared data source item to provide connection information to the model.Ī shared data source consists of the following parts: PartĪ name that identifies the item within the report server folder hierarchy.Ī description that appears with the item in the web portal when you view the contents of the folder. Shared data sources are optional for reports and data-driven subscriptions, but required for report models. If a user account or password changes, or if you move the database to a different server, you can update the connection information in one place. Shared data sources provide an easy way to manage data source properties that often change over time. A shared data source is a set of data source connection properties that can be referenced by multiple reports, models, and data-driven subscriptions that run on a Reporting Services report server. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |