Showing posts with label structure. Show all posts
Showing posts with label structure. Show all posts

Monday, March 12, 2012

RS Utility- preserve folder structure and deploy RDSs

I am trying to figure out the RS command line utility. How do I
create/preserve a folder structure for organizing my reports, and how do I
deploy RDSs with this utility. Also, the sample script just shows how to
create data sources, not deploy the ones I have already created.
--
JasonThe RS.exe simply packages the SOAP API. So if you have an .RDS file,
you'll need to write parsing logic in your script to read the contents of it
and supply them to the CreateDataSource method.
BTW - there is no way to push a .rds file to the server; it's a file that is
used by the report designer while you're designing reports.
-Lukasz
This posting is provided "AS IS" with no warranties, and confers no rights.
"JasonDWilson" <JasonDWilson@.discussions.microsoft.com> wrote in message
news:F75E6394-E1CC-4C03-8F7F-0BC2B8CBFDFC@.microsoft.com...
>I am trying to figure out the RS command line utility. How do I
> create/preserve a folder structure for organizing my reports, and how do I
> deploy RDSs with this utility. Also, the sample script just shows how to
> create data sources, not deploy the ones I have already created.
> --
> Jason

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

RS Structure, Standards and processes

Looking for good articles on RS best practice, standards and processes.On Oct 5, 11:47 am, "Joe" <hortoris...@.gmail.dot.com> wrote:
> Looking for good articles on RS best practice, standards and processes.
Check these out.
http://msdn2.microsoft.com/en-us/sql/aa336316.aspx
http://msdn2.microsoft.com/en-us/library/ms154047.aspx
Hope this helps.
Regards,
Enrique Martinez
Sr. Software Consultant|||There are lots of good practical rules at
http://www.ssw.com.au/ssw/Standards/Rules/RulesToBetterSQLReportingServices.aspx
"Joe" <hortoristic@.gmail.dot.com> wrote in message
news:E6489F99-AE36-407F-AD03-1E7531ED7AC7@.microsoft.com...
> Looking for good articles on RS best practice, standards and processes.