I am using Data-Driven Subcriptions to send a report to different
recipients using different parameters.
I would like to know if Reporting Services can:
-- update a database on successful distribution of report.
Simplest example: I have bit in table of recipients that determines
whether their report should be run and sent. After report is sent
(successfully), I want sql to set bit to 0.
Is this possible?
DanielThere is nothing built into Report Service that would allow you to do this.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
<dangordo@.gmail.com> wrote in message
news:1105368020.135674.280110@.c13g2000cwb.googlegroups.com...
>I am using Data-Driven Subcriptions to send a report to different
> recipients using different parameters.
> I would like to know if Reporting Services can:
> -- update a database on successful distribution of report.
> Simplest example: I have bit in table of recipients that determines
> whether their report should be run and sent. After report is sent
> (successfully), I want sql to set bit to 0.
> Is this possible?
> Daniel
>|||Similar question from different angle: Sometimes distribution ecounters
errors. Is reportserverservice_*.log the only place success and errors
are recorded? Any advice/code on parsing that file?
I am prepared to create mini application to accomplish what i need.
Should I be investigating the rs utility? an application in C#?
Thanks.
Daniel Reib [MSFT] wrote:
> There is nothing built into Report Service that would allow you to do
this.
> --
> -Daniel
> This posting is provided "AS IS" with no warranties, and confers no
rights.
>
> <dangordo@.gmail.com> wrote in message
> news:1105368020.135674.280110@.c13g2000cwb.googlegroups.com...
> >I am using Data-Driven Subcriptions to send a report to different
> > recipients using different parameters.
> >
> > I would like to know if Reporting Services can:
> >
> > -- update a database on successful distribution of report.
> >
> > Simplest example: I have bit in table of recipients that determines
> > whether their report should be run and sent. After report is sent
> > (successfully), I want sql to set bit to 0.
> >
> > Is this possible?
> >
> > Daniel
> >|||Yes, the log file is the only place that we record specific information
about a Data driven subscription failure. You could parse for the
information, but we do not guarantee that the format will be the same from
release to release (a QFE or SP could change it as well).
I'm not sure of how useful it would be anyway. Are you seeing some of the
subscriptions fail, while others succeed? Generally they will either all
succeed or all fail.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
<dangordo@.gmail.com> wrote in message
news:1105456778.305024.60080@.f14g2000cwb.googlegroups.com...
> Similar question from different angle: Sometimes distribution ecounters
> errors. Is reportserverservice_*.log the only place success and errors
> are recorded? Any advice/code on parsing that file?
> I am prepared to create mini application to accomplish what i need.
> Should I be investigating the rs utility? an application in C#?
> Thanks.
> Daniel Reib [MSFT] wrote:
>> There is nothing built into Report Service that would allow you to do
> this.
>> --
>> -Daniel
>> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>>
>> <dangordo@.gmail.com> wrote in message
>> news:1105368020.135674.280110@.c13g2000cwb.googlegroups.com...
>> >I am using Data-Driven Subcriptions to send a report to different
>> > recipients using different parameters.
>> >
>> > I would like to know if Reporting Services can:
>> >
>> > -- update a database on successful distribution of report.
>> >
>> > Simplest example: I have bit in table of recipients that determines
>> > whether their report should be run and sent. After report is sent
>> > (successfully), I want sql to set bit to 0.
>> >
>> > Is this possible?
>> >
>> > Daniel
>> >
>
