Topic Status: Some information in this topic is preview and subject to change in future releases. Preview information describes new features or changes to existing features in Microsoft SQL Server 2016 Community Technology Preview 2 (CTP2).
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.
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.