Monday, March 12, 2012

Reports Depoyment Problem

I have a shared datasource already installed on the ReportServer.
Later I want to deploy reports that use that datasource.
The reports are created with a shared datasource which is not the same as
the one deployed.
How can I specify the datasource programatically when I am deploying the
reports?I think a better way is to have them use the same datasource name. When you
deploy the datasource it is not overwritten. So the datasource can point to
a development database or QA database or Production database (assuming you
have three different servers) and they can all be called the same thing. You
can modify the datasource after deployment to where you want it to go. From
then on it will not be overwritten during deployment unless you explicitly
tell it to be overwritten.
Bruce L-C
"CalinV" <CalinV@.discussions.microsoft.com> wrote in message
news:D912BB4E-C3D4-4A78-883C-06DAC33A8BD6@.microsoft.com...
> I have a shared datasource already installed on the ReportServer.
> Later I want to deploy reports that use that datasource.
> The reports are created with a shared datasource which is not the same as
> the one deployed.
> How can I specify the datasource programatically when I am deploying the
> reports?
>|||Take a look at the SetReportDataSources [1] SOAP API method.
[1]
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSPROG/htm/rsp_ref_soapapi_service_lz_3x88.asp
--
Thanks.
Donovan R. Smith
Software Test Lead
This posting is provided "AS IS" with no warranties, and confers no rights.
"CalinV" <CalinV@.discussions.microsoft.com> wrote in message
news:D912BB4E-C3D4-4A78-883C-06DAC33A8BD6@.microsoft.com...
> I have a shared datasource already installed on the ReportServer.
> Later I want to deploy reports that use that datasource.
> The reports are created with a shared datasource which is not the same as
> the one deployed.
> How can I specify the datasource programatically when I am deploying the
> reports?
>

No comments:

Post a Comment