Sometimes we’ll want to hide lots items from the tile view in Reporting Services. There’s no quick way to, for example, hide all your sub reports view the user interface. As long as you’ve got a standardised naming convention, such as prefixing all sub reports with ‘sub’ then we can connect to the Report Server database and use the following query to hide all out sub reports in directories, quickly and efficiently.
UPDATE [Your ReportServer Database Name Here].[dbo].[Catalog]
SET hidden = 1
WHERE PATH LIKE ‘%/sub%’ AND hidden = 0
With simple changes like this, you can increase the user experience of reporting services for users that may be browsing reports. Increasing positive reactions and feedback on the use of these tools.