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 reports to subfolders

How can I have different reports deploy to different subfolders? all of them
are currently going to same folder.
TIA
DeanThe easiest way is to put the reports in different projects. Each project
goes to a different folder. I have a solution with 8 projects (corresponding
to 8 folders).
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Dean" <deanl144@.hotmail.com.nospam> wrote in message
news:%23OFh7QMuHHA.1184@.TK2MSFTNGP04.phx.gbl...
> How can I have different reports deploy to different subfolders? all of
> them are currently going to same folder.
> TIA
> Dean
>

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
>> >
>