General Properties Page, Shared Datasets (Report Manager)
Applies To: SQL Server 2016
Use the Shared Dataset page to view and manage properties for a shared dataset item.
From Report Manager, you cannot view or change the shared dataset definition, including the query. To change the definition, you must use an authoring tool to open and modify the definition and then save it to the report server.
With a shared dataset, you can manage the settings for a dataset separately from reports, components, and other catalog items that use it.
Use the following procedure to navigate to this location in the user interface (UI).
Open Report Manager, and locate shared dataset for which you want to configure properties.
Hover over the shared dataset, and click the drop-down arrow.
In the drop-down list, click Manage. The General properties page opens.
Type a name for the shared dataset that is used to identify the item within the report server folder hierarchy.
Provide information about the shared dataset. This description appears on the Contents page.
- Hide in list view
Hide the shared dataset from users who are using list view mode in Report Manager. List view mode is the default view format when browsing the report server folder hierarchy. In list view, item names and descriptions flow across the page. The alternative format is details view. Details view omits descriptions, but includes other information about the item. Although you can hide an item in list view, you cannot hide an item in details view. If you want to restrict access to an item, you must create a role assignment.
- Query execution timeout
Type the number of seconds until the query times out. If it is 0, the query does not time out.
Save your changes.
Remove the shared dataset from the report server database. Deleting a shared dataset deactivates any reports or cached versions. To reactivate a report, you must open each one in a report authoring tool, and specify a dataset with the same name and the same field collection. Alternatively, you can update each data region reference to use a different dataset with the same field collection.
Relocate a shared dataset within the report server folder hierarchy. Clicking this button opens the Move Items page, on which you can browse through folders for a new folder location. For more information, see Move Items Page (Report Manager).
Extract a copy of the shared dataset definition. Depending on the file associations defined on your computer, the file will open in Visual Studio or a different application. In most cases, the shared dataset opens as an XML file.
Replace the shared dataset definition with a different one from an .rsd file located on the file system.