Friday, February 24, 2012

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

No comments:

Post a Comment