Client has a large set of SQL Server Reports (.RDL files) in SharePoint. Reports are scheduled to be run automatically. Some Reports have over 40 Subscriptions. Reports are distributed over several different lists and hundreds of folders. If we need to change all of them, it would be alot of work to go in and change each one manually. Is there a tool for managing bulk Reports, Data Sources and Subscriptions in MOSS 2007? I have not found any PowerShell Scripts that are specific to Reports, Data Sources & Subscriptions. Simple operations like bulk updates, copy & paste, replace, etc.Jonathan M Beck

Hi Jonathan, There is a tool on Codeplex ReportServer Explorer http://rssexplorer.codeplex.com/ it even works in integrated mode. Download reports stored on the server, optionally including any (sub)folders by recreating the folder structure on the server by selecting a folder on the server. It will then download all reports and subfolders to the client.Upload multiple reports to the server, optionally you can upload a folder structure to the report server by selected a folder with reports and subfolders stored on the client.Get detailed information about the items on the server, like used datasources, parameters and permissions.Create and delete folders on the server.Move reports, datasources and folders. Rename reports, datasources and folders. Delete reports, datasources and folders.Set the datasource of multiple report on the server by first selecting folders and reports on the server and then the datasource to use. When targeting a folder all reports in that folder and any subfolder will be updated.Get an overview of item properties (used datasources, security settings, parameters and properties)Create or edit datasourceSupports models - upload new models, replace existing (with compatibility check, great when administrating big sites w many users) -IvanIvan Sanders My LinkedIn Profile, My Blog, @iasanders.