Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 Analysis Server and Reporting Services (2008)
 Changing/Removing reports best practices?

Author  Topic 

andrewhopkinson
Yak Posting Veteran

63 Posts

Posted - 2010-06-29 : 14:11:28
Hi, anyone have a good way to automate changing report names or removing reports from folders on the report server?

buraktuf
Starting Member

13 Posts

Posted - 2010-07-20 : 01:56:11
hi andrewhopkinson,
if you want to change or remove, say exactly make any updates on your reports on reportserver the best and also risky way is go to reportserver database and actually the database name is the same 'ReportServer' and in the tables section you will see some meaning tables. But the critical one is 'dbo.Catalog'. it will list the reports, report projects and the data sources. you can make any changes on these table so affecting the report server. for example there is a name column there and you can write an update command to get a quick way.
thanks.
Go to Top of Page
   

- Advertisement -