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.
>
>
Showing posts with label customer. Show all posts
Showing posts with label customer. Show all posts
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?
>
>
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?
>
>
Wednesday, March 7, 2012
Deploying cube changes to multiple sites
Hi,
How does one deploy cube changes (say adding a new field into a dimension) into multiple customer databases without overwriting their Kpis?
We have a SSAS application which will snap into our existing application and allow customers to define Environmental, Health & Safety Kpis. Each customer will have different Kpis, so how do we deploy incremental updates, without overwriting those Kpis?
I know we can download a customers SSAS database into a new VS project, and copy the Kpis into an XMLA deployment script, but that is a lot of work for each customer.
What I am hoping to find is something like a SQL Script that makes the schema changes, but does not touch the data (Kpis etc.). Of course, my SQL knowledge has only got me into trouble in SSAS, so who knows.
Thanks,
--Phil
Probably the best approach would be to write a script which uses DISCOVER_XML_METADATA to retrieve the cube's metadata, and then changes the XML my injecting your KPIs and then sending this XMLA script inside <Alter> command.Deploying a report to remote server
I would like to develop a report remotely for a customer, and then
deploy it on their intranet at their location. Basically all
development is
off-site, and I will travel onsite to install the completed SRS report.
They
do not have a licensed copy of Visual Studio .NET, so none of the
development/maintenance will be done on their server. When I go to
install
SRS on their server, I will only install the Server components, not the
client components. With that said, how do go about getting the actual
report
installed / deployed on their server? I can do it locally on my
development
box using "deploy" from within VS.NET, but how do I do it "manually" on
a box
without VS.NET? What report "files" do I need to copy from my machine,
and
what needs to be setup in IIS?
Thanks
VikramYou can use report manager to deploy a rdl file (if you don't have a lot
this would be the easiest to do.
Or you can script the deploy. You don't have to have a 3rd party tool for
this but here is a free one from Jasper Smith a SQL Server MVP.
Reporting Services Scripter
http://www.sqldbatips.com/showarticle.asp?ID=62
Bruce Loehle-Conger
MVP SQL Server Reporting Services
<vikram.sattenapalli@.gmail.com> wrote in message
news:1140556432.452749.103260@.o13g2000cwo.googlegroups.com...
> I would like to develop a report remotely for a customer, and then
> deploy it on their intranet at their location. Basically all
> development is
> off-site, and I will travel onsite to install the completed SRS report.
> They
> do not have a licensed copy of Visual Studio .NET, so none of the
> development/maintenance will be done on their server. When I go to
> install
> SRS on their server, I will only install the Server components, not the
> client components. With that said, how do go about getting the actual
> report
> installed / deployed on their server? I can do it locally on my
> development
> box using "deploy" from within VS.NET, but how do I do it "manually" on
> a box
> without VS.NET? What report "files" do I need to copy from my machine,
> and
> what needs to be setup in IIS?
> Thanks
> Vikram
>|||Thanks a lot for the quick response. I will try using the third party
tool and see if i can actually generate the script :)
Vikram
deploy it on their intranet at their location. Basically all
development is
off-site, and I will travel onsite to install the completed SRS report.
They
do not have a licensed copy of Visual Studio .NET, so none of the
development/maintenance will be done on their server. When I go to
install
SRS on their server, I will only install the Server components, not the
client components. With that said, how do go about getting the actual
report
installed / deployed on their server? I can do it locally on my
development
box using "deploy" from within VS.NET, but how do I do it "manually" on
a box
without VS.NET? What report "files" do I need to copy from my machine,
and
what needs to be setup in IIS?
Thanks
VikramYou can use report manager to deploy a rdl file (if you don't have a lot
this would be the easiest to do.
Or you can script the deploy. You don't have to have a 3rd party tool for
this but here is a free one from Jasper Smith a SQL Server MVP.
Reporting Services Scripter
http://www.sqldbatips.com/showarticle.asp?ID=62
Bruce Loehle-Conger
MVP SQL Server Reporting Services
<vikram.sattenapalli@.gmail.com> wrote in message
news:1140556432.452749.103260@.o13g2000cwo.googlegroups.com...
> I would like to develop a report remotely for a customer, and then
> deploy it on their intranet at their location. Basically all
> development is
> off-site, and I will travel onsite to install the completed SRS report.
> They
> do not have a licensed copy of Visual Studio .NET, so none of the
> development/maintenance will be done on their server. When I go to
> install
> SRS on their server, I will only install the Server components, not the
> client components. With that said, how do go about getting the actual
> report
> installed / deployed on their server? I can do it locally on my
> development
> box using "deploy" from within VS.NET, but how do I do it "manually" on
> a box
> without VS.NET? What report "files" do I need to copy from my machine,
> and
> what needs to be setup in IIS?
> Thanks
> Vikram
>|||Thanks a lot for the quick response. I will try using the third party
tool and see if i can actually generate the script :)
Vikram
Saturday, February 25, 2012
Deploy RS
Hi,
I have 2 questions:
* How can I deploy my reports , as part of setup, to customer sites? I use
VS.NET deployment and install Shield tools.
* Can I break my reports into multiple HTML pages? Like search results, I
would like to have multiple pages and use my own buttons to navigate between
different pages.
ThanksYou can script deployment instead of using VS to deploy. I would think
installshield could call the script. RS ships with an example of scripting.
Your choice for the reports is to use the portal that ships with RS (Report
Manager) or you can have your own front end (ASP.Net or Winform or
whatever). If you have your own then you use either URL integration or web
services. To do as you describe below you would need to use web services.
Doable but complicated.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Alex" <alim@.rogers.com> wrote in message
news:%23UKKtTUCFHA.1292@.TK2MSFTNGP10.phx.gbl...
> Hi,
> I have 2 questions:
> * How can I deploy my reports , as part of setup, to customer sites? I use
> VS.NET deployment and install Shield tools.
> * Can I break my reports into multiple HTML pages? Like search results, I
> would like to have multiple pages and use my own buttons to navigate
between
> different pages.
> Thanks
>|||At ICCO (www.icco.com) we have built a tool that deploys RDLs in a batch. If
you are interested I can give you more details. You can also call me at (954)
5471293.
"Alex" wrote:
> Hi,
> I have 2 questions:
> * How can I deploy my reports , as part of setup, to customer sites? I use
> VS.NET deployment and install Shield tools.
> * Can I break my reports into multiple HTML pages? Like search results, I
> would like to have multiple pages and use my own buttons to navigate between
> different pages.
> Thanks
>
>
I have 2 questions:
* How can I deploy my reports , as part of setup, to customer sites? I use
VS.NET deployment and install Shield tools.
* Can I break my reports into multiple HTML pages? Like search results, I
would like to have multiple pages and use my own buttons to navigate between
different pages.
ThanksYou can script deployment instead of using VS to deploy. I would think
installshield could call the script. RS ships with an example of scripting.
Your choice for the reports is to use the portal that ships with RS (Report
Manager) or you can have your own front end (ASP.Net or Winform or
whatever). If you have your own then you use either URL integration or web
services. To do as you describe below you would need to use web services.
Doable but complicated.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Alex" <alim@.rogers.com> wrote in message
news:%23UKKtTUCFHA.1292@.TK2MSFTNGP10.phx.gbl...
> Hi,
> I have 2 questions:
> * How can I deploy my reports , as part of setup, to customer sites? I use
> VS.NET deployment and install Shield tools.
> * Can I break my reports into multiple HTML pages? Like search results, I
> would like to have multiple pages and use my own buttons to navigate
between
> different pages.
> Thanks
>|||At ICCO (www.icco.com) we have built a tool that deploys RDLs in a batch. If
you are interested I can give you more details. You can also call me at (954)
5471293.
"Alex" wrote:
> Hi,
> I have 2 questions:
> * How can I deploy my reports , as part of setup, to customer sites? I use
> VS.NET deployment and install Shield tools.
> * Can I break my reports into multiple HTML pages? Like search results, I
> would like to have multiple pages and use my own buttons to navigate between
> different pages.
> Thanks
>
>
Friday, February 24, 2012
Deploy RS
Hi,
I have 2 questions:
* How can I deploy my reports , as part of setup, to customer sites? I use
VS.NET deployment and install Shield tools.
* Can I break my reports into multiple HTML pages? Like search results, I
would like to have multiple pages and use my own buttons to navigate between
different pages.
ThanksYou can script deployment instead of using VS to deploy. I would think
installshield could call the script. RS ships with an example of scripting.
Your choice for the reports is to use the portal that ships with RS (Report
Manager) or you can have your own front end (ASP.Net or Winform or
whatever). If you have your own then you use either URL integration or web
services. To do as you describe below you would need to use web services.
Doable but complicated.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Alex" <alim@.rogers.com> wrote in message
news:%23UKKtTUCFHA.1292@.TK2MSFTNGP10.phx.gbl...
> Hi,
> I have 2 questions:
> * How can I deploy my reports , as part of setup, to customer sites? I use
> VS.NET deployment and install Shield tools.
> * Can I break my reports into multiple HTML pages? Like search results, I
> would like to have multiple pages and use my own buttons to navigate
between
> different pages.
> Thanks
>|||At ICCO (www.icco.com) we have built a tool that deploys RDLs in a batch. If
you are interested I can give you more details. You can also call me at (954)
5471293.
"Alex" wrote:
> Hi,
> I have 2 questions:
> * How can I deploy my reports , as part of setup, to customer sites? I use
> VS.NET deployment and install Shield tools.
> * Can I break my reports into multiple HTML pages? Like search results, I
> would like to have multiple pages and use my own buttons to navigate between
> different pages.
> Thanks
>
>
I have 2 questions:
* How can I deploy my reports , as part of setup, to customer sites? I use
VS.NET deployment and install Shield tools.
* Can I break my reports into multiple HTML pages? Like search results, I
would like to have multiple pages and use my own buttons to navigate between
different pages.
ThanksYou can script deployment instead of using VS to deploy. I would think
installshield could call the script. RS ships with an example of scripting.
Your choice for the reports is to use the portal that ships with RS (Report
Manager) or you can have your own front end (ASP.Net or Winform or
whatever). If you have your own then you use either URL integration or web
services. To do as you describe below you would need to use web services.
Doable but complicated.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Alex" <alim@.rogers.com> wrote in message
news:%23UKKtTUCFHA.1292@.TK2MSFTNGP10.phx.gbl...
> Hi,
> I have 2 questions:
> * How can I deploy my reports , as part of setup, to customer sites? I use
> VS.NET deployment and install Shield tools.
> * Can I break my reports into multiple HTML pages? Like search results, I
> would like to have multiple pages and use my own buttons to navigate
between
> different pages.
> Thanks
>|||At ICCO (www.icco.com) we have built a tool that deploys RDLs in a batch. If
you are interested I can give you more details. You can also call me at (954)
5471293.
"Alex" wrote:
> Hi,
> I have 2 questions:
> * How can I deploy my reports , as part of setup, to customer sites? I use
> VS.NET deployment and install Shield tools.
> * Can I break my reports into multiple HTML pages? Like search results, I
> would like to have multiple pages and use my own buttons to navigate between
> different pages.
> Thanks
>
>
Deploy Report Model without VS
Is it possible to deploy report models without Visual Studio?
I ask this for when it comes to deploy an ASP.NET project to a
customer that includes reports and they would like to use the Report
Builder.
I've heard use of the RS Web Service but I have not seen any code.
This would normally be a one time event at time of deployment to
production but could involve future updates. These future update
deployments would not be possible with VS (except for the actual
editing of the update).I've used rs.exe to create folders, datasources, and reports, but what
I'm conerned about is the Models folder, the datasource view and
anything else that the "Report Builder" needs before it can be run for
the first time by the end users.
I ask this for when it comes to deploy an ASP.NET project to a
customer that includes reports and they would like to use the Report
Builder.
I've heard use of the RS Web Service but I have not seen any code.
This would normally be a one time event at time of deployment to
production but could involve future updates. These future update
deployments would not be possible with VS (except for the actual
editing of the update).I've used rs.exe to create folders, datasources, and reports, but what
I'm conerned about is the Models folder, the datasource view and
anything else that the "Report Builder" needs before it can be run for
the first time by the end users.
Subscribe to:
Posts (Atom)