Deploy Reports to specific folders

Hi, I am a new user for RS so this might be a very dump question for some of the advanced users here.

I am using SQL 2005 RS and was wondering how I can deploy reports to specific folders that I created on the Reports page. I do know that I can go to Properties to move the reports to different folders. But the problem I have is when I deploy the reports from VS 2005 ( I created the reports using VS 2005) they were deployed back to the old/root folder. How can I change the 'deploy-to' destination folder for the reports in VS 2005?

Many Thanks,

Casey

Hi caseycasper,

You could go to the “Project Properties Page” (right click the project)

Set the “TargetReportFolder” property, to the folder you would like to deploy the report to.

Note: if the folder is not available, .NET will create the folder for you J

|||

Thanks JDee.

But what if I want to deploy different reports to different folders? Let's say I have 20 reports, 5 reports each for Team A, Team B, Team C, and Team D, for which I have created report folder. How can I set that up so the reports will go to the specific team folder automatically when I deploy them in VS? I don't want to do the 'move' function everytime I deploy updated reports...

Thanks,

Casey

|||

If I am not wrong that feature is not supported yet.

You could either create different projects for reports which are going to be placed into different foldersL.

Or

Create your own deployment scripts to do it as per your requirement. Please see the link belowJ:

http://msdn2.microsoft.com/en-us/library/ms162839.aspx

|||

Thank you JDee! Appreciate your help!

|||Hi, I also search for that option a few month ago and didn't find this feature.

I think that a good solution is like JDee said - Create a project for every team under the same solution and then configure every project to his own folder.

Good luck.|||

Yup, I just created new projects under the same solution and was able to deploy reports to the "sub -folders".

Thank you all!