Showing posts with label design. Show all posts
Showing posts with label design. Show all posts

Friday, March 9, 2012

Deploying RDLs & RDSs without VS .NET or ReportManager

I was asked to design and deliver SQL Reporting Services reports to a
customer; just the RDLs and RDSs. The customer will not have Visual Studio
.NET (or any other .NET IDE) loaded on their computer. So, I have a couple
of questions:
1. How can I programmatically deploy all the RDLs and RDSs to the
ReportServer without an IDE?
2. If, after the initial deployment, changes are made to the RDLs and/or
RDSs, how can I programmatically re-deploy these "fixed" items without
having VS .NET on the computer?
Thanks.There is a SOAP API you can use:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSPROG/htm/rsp_ref_soapapi_service_ak_1xfd.asp
--
Rajeev Karunakaran [MSFT]
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"PTurley" <pturley@.nospam.com> wrote in message
news:Od34GdwDFHA.392@.TK2MSFTNGP14.phx.gbl...
>I was asked to design and deliver SQL Reporting Services reports to a
> customer; just the RDLs and RDSs. The customer will not have Visual
> Studio
> .NET (or any other .NET IDE) loaded on their computer. So, I have a
> couple
> of questions:
> 1. How can I programmatically deploy all the RDLs and RDSs to the
> ReportServer without an IDE?
> 2. If, after the initial deployment, changes are made to the RDLs and/or
> RDSs, how can I programmatically re-deploy these "fixed" items without
> having VS .NET on the computer?
> Thanks.
>|||At my company, ICCO (www.icco.com), we have designed a tool in VB.NET that
does precisely that. We use it to deploy reports to our new customers, or
update batches of reports to existing customers. I will sell it to you for
$150 if you are interested. I can be reached at (954) 5471293.
"PTurley" wrote:
> I was asked to design and deliver SQL Reporting Services reports to a
> customer; just the RDLs and RDSs. The customer will not have Visual Studio
> ..NET (or any other .NET IDE) loaded on their computer. So, I have a couple
> of questions:
> 1. How can I programmatically deploy all the RDLs and RDSs to the
> ReportServer without an IDE?
> 2. If, after the initial deployment, changes are made to the RDLs and/or
> RDSs, how can I programmatically re-deploy these "fixed" items without
> having VS .NET on the computer?
> Thanks.
>
>

Deploying RDL and RDS to customer without Visual Studio

I was asked to design and deliver SQL Reporting Services reports to a
customer. The customer will not have Visual Studio on their network. I've
read that you can script the deployment of reports and shared datasources
using RS.EXE but have not been able to figure it out with the instructions in
the documentation.
Can anyone provide an example of how I would do this?I posted this message earlier today, but let me try one more time:
Why not use the upload file buttom of the Report Manager
(http://yourreportsite/reports) to do the deployment?
a) Upload the rdl;
b) Create the db connection manually again within the Report Manager.
Tao
"AdamB" wrote:
> I was asked to design and deliver SQL Reporting Services reports to a
> customer. The customer will not have Visual Studio on their network. I've
> read that you can script the deployment of reports and shared datasources
> using RS.EXE but have not been able to figure it out with the instructions in
> the documentation.
> Can anyone provide an example of how I would do this?|||I will do that for now, thanks. But I was hoping to create an ASP.Net
application where I could select an rdl or rds file and call the web service
to add the selected resource behind the scenes
"Tao Zuo" wrote:
> I posted this message earlier today, but let me try one more time:
> Why not use the upload file buttom of the Report Manager
> (http://yourreportsite/reports) to do the deployment?
> a) Upload the rdl;
> b) Create the db connection manually again within the Report Manager.
> Tao
>
> "AdamB" wrote:
> > I was asked to design and deliver SQL Reporting Services reports to a
> > customer. The customer will not have Visual Studio on their network. I've
> > read that you can script the deployment of reports and shared datasources
> > using RS.EXE but have not been able to figure it out with the instructions in
> > the documentation.
> >
> > Can anyone provide an example of how I would do this?|||Do you still require assistance regarding thiis topic. Have you tried
running the PublishSampleReports.rss script from the command window. Or have
you not reached that far as yet. If you have not then search for "sample
scripts" in Visual Studio.Net help. There is a link "Script for Publishing
Sample Reports". Click on the link and then read the instructions that
follow. If you are still unclear as to what to do, then i will try and help
u further.
Cheers
"AdamB" <AdamB@.discussions.microsoft.com> wrote in message
news:6E73D669-1411-4440-8DDB-EFD7AA0615AD@.microsoft.com...
>I will do that for now, thanks. But I was hoping to create an ASP.Net
> application where I could select an rdl or rds file and call the web
> service
> to add the selected resource behind the scenes
> "Tao Zuo" wrote:
>> I posted this message earlier today, but let me try one more time:
>> Why not use the upload file buttom of the Report Manager
>> (http://yourreportsite/reports) to do the deployment?
>> a) Upload the rdl;
>> b) Create the db connection manually again within the Report Manager.
>> Tao
>>
>> "AdamB" wrote:
>> > I was asked to design and deliver SQL Reporting Services reports to a
>> > customer. The customer will not have Visual Studio on their network.
>> > I've
>> > read that you can script the deployment of reports and shared
>> > datasources
>> > using RS.EXE but have not been able to figure it out with the
>> > instructions in
>> > the documentation.
>> >
>> > Can anyone provide an example of how I would do this?|||Thanks, I'll check it out. What about deploying data sources. I see that
the Web Service has a CreateDataSource class. Do you know if this is pretty
straightforward?
"Sanjeev" wrote:
> Do you still require assistance regarding thiis topic. Have you tried
> running the PublishSampleReports.rss script from the command window. Or have
> you not reached that far as yet. If you have not then search for "sample
> scripts" in Visual Studio.Net help. There is a link "Script for Publishing
> Sample Reports". Click on the link and then read the instructions that
> follow. If you are still unclear as to what to do, then i will try and help
> u further.
> Cheers
> "AdamB" <AdamB@.discussions.microsoft.com> wrote in message
> news:6E73D669-1411-4440-8DDB-EFD7AA0615AD@.microsoft.com...
> >I will do that for now, thanks. But I was hoping to create an ASP.Net
> > application where I could select an rdl or rds file and call the web
> > service
> > to add the selected resource behind the scenes
> >
> > "Tao Zuo" wrote:
> >
> >> I posted this message earlier today, but let me try one more time:
> >>
> >> Why not use the upload file buttom of the Report Manager
> >> (http://yourreportsite/reports) to do the deployment?
> >>
> >> a) Upload the rdl;
> >> b) Create the db connection manually again within the Report Manager.
> >>
> >> Tao
> >>
> >>
> >>
> >> "AdamB" wrote:
> >>
> >> > I was asked to design and deliver SQL Reporting Services reports to a
> >> > customer. The customer will not have Visual Studio on their network.
> >> > I've
> >> > read that you can script the deployment of reports and shared
> >> > datasources
> >> > using RS.EXE but have not been able to figure it out with the
> >> > instructions in
> >> > the documentation.
> >> >
> >> > Can anyone provide an example of how I would do this?
>
>