Friday, March 9, 2012

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

No comments:

Post a Comment