Report Distribution

Through report manager I am trying to see if it is possible
to set up a data-driven subscription, that will save the
file on a file share AND notifiy user via email based on values
stored in sql table.

I can get each to work as independent jobs but I want this to
be run as one.

Can this be done? How?

Thanks.

Not out of the box. Each subscription has only one delivery extension it uses. It is not possible to chain delivery extensions.

You can write a custom delivery extension that would do both of these operations. There's a printer delivery sample in the Samples that come with SQL Server 2000 Reporting Services and SQL Server 2005.

-Lukasz

This posting is provided "AS IS" with no warranties, and confers no rights.

|||

Hi,
Me too wants to have some simillar to your requirement. Have you created some custom delivery extension for this purpose.

Regards;
Rakesh