Deploying to subfolders from VS

I've got a report project with a few reports in I want in the root target directory. I also want to create several folders and put reports in those. The problem is I don't see any way to create a report folder in VS. I also don't see any way to pick the deployment path of a single reprot in VS. This makes me think I'll have to create a different Report Project in VS for each folder!! (this sucks). Does anyone have an idea or suggestion here?

Sorry, creating subfolder hierarchies directly from within a VS report project is currently not supported.

The closest you can get is to write a little application using the RS SOAP API to deploy your reports - you will then have full control over the folder hierarchy.

-- Robert

|||

This is highly unfortunate.

It makes deploying reports a real pain
because of the manual nature of having
to organize and overwrite older reports
(after deployment) that are existing in
sub-folders.

Can anyone provide some sources on
where to get started if one were to try
to write a custom deployment app?

|||

This link is to a tool that will give you some insight on how to deploy reports programmatically. It is not an automated process itself, but will give you an idea how it could be done.

http://www.sqldbatips.com/showarticle.asp?ID=62

I am creating a C# application that will use a small database for deployment data. With 3K+ remote servers, we have the same issue.

I originally thought I would use a method described elsewhere in the forum where you always deploy to one hidden folder and link all of your reports to their visible spots. I am not yet sure of the ramifications of that yet. If anyone has done deployments in this method, please let me know.

R

|||

Well, if you have any linked reports with landscape orientation, they will, more than likely, insist on printing portrait. Just something to consider. Another thread covers this:

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=137986&SiteID=1

Even with the small glitches, SRS is a pleasure to work with.

|||So far the easiest way I've found to deal with this problem is to simply deploy all the reports in a project to the report server in a single place. Then, using the sql server management studio I can create folders and move reports into the proper location. It is not the best solution, but it works. It is a real hassle when updating reports. I just don't understand why microsoft did not make it possible to have report folders inside of visual studio. It would have taken an extra 10 minutes to program!
|||I agreed! Logical grouping is the most fundamental user function that you can find in all other MS or non MS products, but why not this one? We have 100+ reports, this has forced me to use some sort of special naming convention (Initiative - Category - subcategory - report name) for report name so that it's easier for me to find the reports in a flat list! Painful is to say the least...

Deploying to subfolders from VS

I've got a report project with a few reports in I want in the root target directory. I also want to create several folders and put reports in those. The problem is I don't see any way to create a report folder in VS. I also don't see any way to pick the deployment path of a single reprot in VS. This makes me think I'll have to create a different Report Project in VS for each folder!! (this sucks). Does anyone have an idea or suggestion here?

Sorry, creating subfolder hierarchies directly from within a VS report project is currently not supported.

The closest you can get is to write a little application using the RS SOAP API to deploy your reports - you will then have full control over the folder hierarchy.

-- Robert

|||

This is highly unfortunate.

It makes deploying reports a real pain
because of the manual nature of having
to organize and overwrite older reports
(after deployment) that are existing in
sub-folders.

Can anyone provide some sources on
where to get started if one were to try
to write a custom deployment app?

|||

This link is to a tool that will give you some insight on how to deploy reports programmatically. It is not an automated process itself, but will give you an idea how it could be done.

http://www.sqldbatips.com/showarticle.asp?ID=62

I am creating a C# application that will use a small database for deployment data. With 3K+ remote servers, we have the same issue.

I originally thought I would use a method described elsewhere in the forum where you always deploy to one hidden folder and link all of your reports to their visible spots. I am not yet sure of the ramifications of that yet. If anyone has done deployments in this method, please let me know.

R

|||

Well, if you have any linked reports with landscape orientation, they will, more than likely, insist on printing portrait. Just something to consider. Another thread covers this:

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=137986&SiteID=1

Even with the small glitches, SRS is a pleasure to work with.

|||So far the easiest way I've found to deal with this problem is to simply deploy all the reports in a project to the report server in a single place. Then, using the sql server management studio I can create folders and move reports into the proper location. It is not the best solution, but it works. It is a real hassle when updating reports. I just don't understand why microsoft did not make it possible to have report folders inside of visual studio. It would have taken an extra 10 minutes to program!
|||I agreed! Logical grouping is the most fundamental user function that you can find in all other MS or non MS products, but why not this one? We have 100+ reports, this has forced me to use some sort of special naming convention (Initiative - Category - subcategory - report name) for report name so that it's easier for me to find the reports in a flat list! Painful is to say the least...

Deploying to subfolders from VS

I've got a report project with a few reports in I want in the root target directory. I also want to create several folders and put reports in those. The problem is I don't see any way to create a report folder in VS. I also don't see any way to pick the deployment path of a single reprot in VS. This makes me think I'll have to create a different Report Project in VS for each folder!! (this sucks). Does anyone have an idea or suggestion here?

Sorry, creating subfolder hierarchies directly from within a VS report project is currently not supported.

The closest you can get is to write a little application using the RS SOAP API to deploy your reports - you will then have full control over the folder hierarchy.

-- Robert

|||

This is highly unfortunate.

It makes deploying reports a real pain
because of the manual nature of having
to organize and overwrite older reports
(after deployment) that are existing in
sub-folders.

Can anyone provide some sources on
where to get started if one were to try
to write a custom deployment app?

|||

This link is to a tool that will give you some insight on how to deploy reports programmatically. It is not an automated process itself, but will give you an idea how it could be done.

http://www.sqldbatips.com/showarticle.asp?ID=62

I am creating a C# application that will use a small database for deployment data. With 3K+ remote servers, we have the same issue.

I originally thought I would use a method described elsewhere in the forum where you always deploy to one hidden folder and link all of your reports to their visible spots. I am not yet sure of the ramifications of that yet. If anyone has done deployments in this method, please let me know.

R

|||

Well, if you have any linked reports with landscape orientation, they will, more than likely, insist on printing portrait. Just something to consider. Another thread covers this:

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=137986&SiteID=1

Even with the small glitches, SRS is a pleasure to work with.

|||So far the easiest way I've found to deal with this problem is to simply deploy all the reports in a project to the report server in a single place. Then, using the sql server management studio I can create folders and move reports into the proper location. It is not the best solution, but it works. It is a real hassle when updating reports. I just don't understand why microsoft did not make it possible to have report folders inside of visual studio. It would have taken an extra 10 minutes to program!
|||I agreed! Logical grouping is the most fundamental user function that you can find in all other MS or non MS products, but why not this one? We have 100+ reports, this has forced me to use some sort of special naming convention (Initiative - Category - subcategory - report name) for report name so that it's easier for me to find the reports in a flat list! Painful is to say the least...

Deploying folders to the reportmanager from VS

How to create folders in VS to be deployed to the reportmanager.
--
Regards
Henrik JuelRight now the best thing to do is to have a project and the project is
deployed to the appropriate folder in RS. Note that you can not today deploy
from VS to different folders from the same project. It is a one to one
relationship of project to folder.
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Henrik Juel" <HenrikJuel@.discussions.microsoft.com> wrote in message
news:A8E733CE-6762-4B4E-9F85-A54D5D6EDC7A@.microsoft.com...
> How to create folders in VS to be deployed to the reportmanager.
> --
> Regards
> Henrik Juel

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!

deploy reports to several subfolders

i have a reporting project which i want to deploy several reports into
several sub folders.
it appears not possible from the ui, and i found a few articles on the
web from 2004 suggesting it wasnt possible.
can anyone confirm if its still not possible?
thanks in advance
dbCan you deploy directly from Visual Studio to the server hosting Reporting
Services?
In that case, you organize your report solution in VS with more than one
project, and then give each sub-project a link to a subfolder of RS on the
server.
In your report solution, right click on the Solution, and click Add -> New
Project. Give the new project a descriptive name, and store it in a
subfolder of your solution. I usually have a sub project called "Dev", where
I put the development edition of each report, and a main project with the
finished reports.
When you have a sub project, right click this project and click Properties.
If your solution is called MyReports, and your server is called MyServer,
then
TargetServerURL : http://myserver/reportserver/
TargetReportFolder MyReports/Dev
When you deploy reports in the Dev (sub)project, they will be deployed to
http://myserver/reportserver/MyReports/Dev instead of
http://myserver/reportserver/MyReports/ .
You have to create Shared Data sources in your new project. You can copy the
existing ones, but I find that they sometimes loose the credentials, so you
just have to double check on them after having copied them.
Kaisa M. Lindahl Lervik
"bb" <barnseenio@.gmail.com> wrote in message
news:1158847587.230893.243740@.m73g2000cwd.googlegroups.com...
>i have a reporting project which i want to deploy several reports into
> several sub folders.
> it appears not possible from the ui, and i found a few articles on the
> web from 2004 suggesting it wasnt possible.
> can anyone confirm if its still not possible?
> thanks in advance
> db
>|||Thanks for the tip, but yes i was aware that i could create a different
project for each 'subfolder'. My problem is im using the report folders
to group the reports, as i want to leave all this metadata in SSRS
rather than creating database tables to describe reporting groups.
I have around 10 folders and within each one i have some subfolders, so
the project idea is a bit painful.
I think im going to write an app which can programmatically deploy
different rdls to different subfolders, which can be used by the
develoeprs to deploy their reports.
db
Kaisa M. Lindahl Lervik wrote:
> Can you deploy directly from Visual Studio to the server hosting Reporting
> Services?
> In that case, you organize your report solution in VS with more than one
> project, and then give each sub-project a link to a subfolder of RS on the
> server.
> In your report solution, right click on the Solution, and click Add -> New
> Project. Give the new project a descriptive name, and store it in a
> subfolder of your solution. I usually have a sub project called "Dev", where
> I put the development edition of each report, and a main project with the
> finished reports.
> When you have a sub project, right click this project and click Properties.
> If your solution is called MyReports, and your server is called MyServer,
> then
> TargetServerURL : http://myserver/reportserver/
> TargetReportFolder MyReports/Dev
> When you deploy reports in the Dev (sub)project, they will be deployed to
> http://myserver/reportserver/MyReports/Dev instead of
> http://myserver/reportserver/MyReports/ .
> You have to create Shared Data sources in your new project. You can copy the
> existing ones, but I find that they sometimes loose the credentials, so you
> just have to double check on them after having copied them.
> Kaisa M. Lindahl Lervik
>
> "bb" <barnseenio@.gmail.com> wrote in message
> news:1158847587.230893.243740@.m73g2000cwd.googlegroups.com...
> >i have a reporting project which i want to deploy several reports into
> > several sub folders.
> >
> > it appears not possible from the ui, and i found a few articles on the
> > web from 2004 suggesting it wasnt possible.
> >
> > can anyone confirm if its still not possible?
> >
> > thanks in advance
> >
> > db
> >|||OK, you might want to check out a post I wrote "Re: Use rs.exe to publish
ALL .rdl files in a folder"
Sent to this newsgroup on sept 18. I wrote a script that extends the sample
script to publish reports.
Also, you might want to check out Reporting Services Scripter 2.0.0.2, might
give you some tips on how to do things with scripts as well.
Kaisa M. Lindahl Lervik
"bb" <barnseenio@.gmail.com> wrote in message
news:1158913333.694125.327440@.k70g2000cwa.googlegroups.com...
> Thanks for the tip, but yes i was aware that i could create a different
> project for each 'subfolder'. My problem is im using the report folders
> to group the reports, as i want to leave all this metadata in SSRS
> rather than creating database tables to describe reporting groups.
> I have around 10 folders and within each one i have some subfolders, so
> the project idea is a bit painful.
> I think im going to write an app which can programmatically deploy
> different rdls to different subfolders, which can be used by the
> develoeprs to deploy their reports.
> db
>
> Kaisa M. Lindahl Lervik wrote:
>> Can you deploy directly from Visual Studio to the server hosting
>> Reporting
>> Services?
>> In that case, you organize your report solution in VS with more than one
>> project, and then give each sub-project a link to a subfolder of RS on
>> the
>> server.
>> In your report solution, right click on the Solution, and click Add ->
>> New
>> Project. Give the new project a descriptive name, and store it in a
>> subfolder of your solution. I usually have a sub project called "Dev",
>> where
>> I put the development edition of each report, and a main project with the
>> finished reports.
>> When you have a sub project, right click this project and click
>> Properties.
>> If your solution is called MyReports, and your server is called MyServer,
>> then
>> TargetServerURL : http://myserver/reportserver/
>> TargetReportFolder MyReports/Dev
>> When you deploy reports in the Dev (sub)project, they will be deployed to
>> http://myserver/reportserver/MyReports/Dev instead of
>> http://myserver/reportserver/MyReports/ .
>> You have to create Shared Data sources in your new project. You can copy
>> the
>> existing ones, but I find that they sometimes loose the credentials, so
>> you
>> just have to double check on them after having copied them.
>> Kaisa M. Lindahl Lervik
>>
>> "bb" <barnseenio@.gmail.com> wrote in message
>> news:1158847587.230893.243740@.m73g2000cwd.googlegroups.com...
>> >i have a reporting project which i want to deploy several reports into
>> > several sub folders.
>> >
>> > it appears not possible from the ui, and i found a few articles on the
>> > web from 2004 suggesting it wasnt possible.
>> >
>> > can anyone confirm if its still not possible?
>> >
>> > thanks in advance
>> >
>> > db
>> >
>

deploy reports directly into right folders

hi,
is it possible to deploy an report directly to a folder from the
business intellegence studio?
or can I only move reports via the Report Manager?
Thanks!Hi,
Create a folder in the Report Manager and specify the folder name and
target url in the project properties.
This automatically move the reports to the desired folder when u deploy
that report.
Thanks.
florian wrote:
> hi,
> is it possible to deploy an report directly to a folder from the
> business intellegence studio?
> or can I only move reports via the Report Manager?
> Thanks!|||but what if I have a project with several reports belonging to
different folders?
Sara schrieb:
> Hi,
> Create a folder in the Report Manager and specify the folder name and
> target url in the project properties.
> This automatically move the reports to the desired folder when u deploy
> that report.
> Thanks.
> florian wrote:
> > hi,
> >
> > is it possible to deploy an report directly to a folder from the
> > business intellegence studio?
> >
> > or can I only move reports via the Report Manager?
> >
> > Thanks!|||Yeah, that's what I want to know. I have the same thing, one project with 10
reports in it. 3 of the reports go in their own folder.
I guess you could argue that because the reports have their own folder in
the UI that they should have their own project. But then that raises the
issue of having to duplicate your shared data sources. As of yet I have not
found a way to share data sources across projects withing the same solution
in VS.Net 2003.
"florian" wrote:
> but what if I have a project with several reports belonging to
> different folders?
> Sara schrieb:
> > Hi,
> > Create a folder in the Report Manager and specify the folder name and
> > target url in the project properties.
> >
> > This automatically move the reports to the desired folder when u deploy
> > that report.
> >
> > Thanks.
> > florian wrote:
> > > hi,
> > >
> > > is it possible to deploy an report directly to a folder from the
> > > business intellegence studio?
> > >
> > > or can I only move reports via the Report Manager?
> > >
> > > Thanks!
>

Deploy Folder

How can I change the deployment folder in a Visual Studio Solution?. I
understood it is not possible to deploy to a different folders, is that
correct?. ThanksDo you mean:
Project menu --> properties --> targetfolder and targetserverURL
Mike G.
"Daniel" <Daniel@.discussions.microsoft.com> wrote in message
news:30941407-8AFF-4764-AFA3-B50D8A74E1C5@.microsoft.com...
> How can I change the deployment folder in a Visual Studio Solution?. I
> understood it is not possible to deploy to a different folders, is that
> correct?. Thanks