Sunday, March 11, 2012

Deploying report to multiple locations

We would like to be able to publish a report to more than 1 directory at the
same time. Is this or would this be possible? Currently, we deploy the base
report to a central location and create linked reports to all other locations.The benefit of using linked reports is that updating the report contents of
the original report will update the linked reports automatically. Note:
report parameters and data source settings won't get updated because they
are administrated separately for linked reports.
You may also want to check the following tool courtesy Jasper Smith (a SQL
Server MVP): http://www.sqldbatips.com/showarticle.asp?ID=62
-- Robert
This posting is provided "AS IS" with no warranties, and confers no rights.
"clutch" <clutch@.discussions.microsoft.com> wrote in message
news:C16C6284-800A-41C1-822F-6C5FD518B727@.microsoft.com...
> We would like to be able to publish a report to more than 1 directory at
> the
> same time. Is this or would this be possible? Currently, we deploy the
> base
> report to a central location and create linked reports to all other
> locations.|||Thanks for the feedback. I was hoping you could answer one more thing.
Will it be possible to create a linked report, but have the ability to
select multiple locations at the same time? Rather than having to do each one
individually.
Thank you!
"Robert Bruckner [MSFT]" wrote:
> The benefit of using linked reports is that updating the report contents of
> the original report will update the linked reports automatically. Note:
> report parameters and data source settings won't get updated because they
> are administrated separately for linked reports.
> You may also want to check the following tool courtesy Jasper Smith (a SQL
> Server MVP): http://www.sqldbatips.com/showarticle.asp?ID=62
>
> -- Robert
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "clutch" <clutch@.discussions.microsoft.com> wrote in message
> news:C16C6284-800A-41C1-822F-6C5FD518B727@.microsoft.com...
> > We would like to be able to publish a report to more than 1 directory at
> > the
> > same time. Is this or would this be possible? Currently, we deploy the
> > base
> > report to a central location and create linked reports to all other
> > locations.
>
>|||No, you can only create one linked report at a time in report manager. But
since creating a linked report is just a SOAP-call (look for
CreateLinkedReport in BOL), you could write a RSS script which creates
multiple linked reports in a sequence.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"clutch" <clutch@.discussions.microsoft.com> wrote in message
news:08A92FF1-5327-435D-9877-D6A0179F0866@.microsoft.com...
> Thanks for the feedback. I was hoping you could answer one more thing.
> Will it be possible to create a linked report, but have the ability to
> select multiple locations at the same time? Rather than having to do each
> one
> individually.
> Thank you!
> "Robert Bruckner [MSFT]" wrote:
>> The benefit of using linked reports is that updating the report contents
>> of
>> the original report will update the linked reports automatically. Note:
>> report parameters and data source settings won't get updated because they
>> are administrated separately for linked reports.
>> You may also want to check the following tool courtesy Jasper Smith (a
>> SQL
>> Server MVP): http://www.sqldbatips.com/showarticle.asp?ID=62
>>
>> -- Robert
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>>
>> "clutch" <clutch@.discussions.microsoft.com> wrote in message
>> news:C16C6284-800A-41C1-822F-6C5FD518B727@.microsoft.com...
>> > We would like to be able to publish a report to more than 1 directory
>> > at
>> > the
>> > same time. Is this or would this be possible? Currently, we deploy the
>> > base
>> > report to a central location and create linked reports to all other
>> > locations.
>>

No comments:

Post a Comment