RS utility - folder structure for storing reports

I am trying to use the RS utility for deploying reports I create to our
customers. I need to hand them an install CD that does everything. I can
deploy reports via RS, but I am wondering how to preserve a folder structure
for organizing the reports. Also, how do I script subscriptions, and deploy
RDSs. The sample MS provides creates a new data source, not use the ones I
have already created in report design.
Thanks,
--
JasonYou might want to have a look at Reporting Services Scripter
http://www.sqldbatips.com/showarticle.asp?ID=62
I haven't got around to subscriptions yet but it should handle most of you
requirements
--
HTH
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"JasonDWilson" <JasonDWilson@.discussions.microsoft.com> wrote in message
news:6F2C98BD-CA88-4D6C-9BB9-A33960052690@.microsoft.com...
>I am trying to use the RS utility for deploying reports I create to our
> customers. I need to hand them an install CD that does everything. I can
> deploy reports via RS, but I am wondering how to preserve a folder
> structure
> for organizing the reports. Also, how do I script subscriptions, and
> deploy
> RDSs. The sample MS provides creates a new data source, not use the ones
> I
> have already created in report design.
> Thanks,
> --
> Jason|||Thanks. Like like a great utility. Is it freeware?
"Jasper Smith" wrote:
> You might want to have a look at Reporting Services Scripter
> http://www.sqldbatips.com/showarticle.asp?ID=62
> I haven't got around to subscriptions yet but it should handle most of you
> requirements
> --
> HTH
> Jasper Smith (SQL Server MVP)
> http://www.sqldbatips.com
> I support PASS - the definitive, global
> community for SQL Server professionals -
> http://www.sqlpass.org
> "JasonDWilson" <JasonDWilson@.discussions.microsoft.com> wrote in message
> news:6F2C98BD-CA88-4D6C-9BB9-A33960052690@.microsoft.com...
> >I am trying to use the RS utility for deploying reports I create to our
> > customers. I need to hand them an install CD that does everything. I can
> > deploy reports via RS, but I am wondering how to preserve a folder
> > structure
> > for organizing the reports. Also, how do I script subscriptions, and
> > deploy
> > RDSs. The sample MS provides creates a new data source, not use the ones
> > I
> > have already created in report design.
> >
> > Thanks,
> > --
> > Jason
>
>