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.

Del,

I don't think you can do exactly what you want.

Why not tell us a little more about your overall purpose and goal, i.e. Want email notification, without increasing WAN bandwidth utilization, and without filling up inboxes.

As you are aware the report can be included in the email in whichever format you want to render it.

Work around: Run the report to deliver to a file share, then using the same subscriber table run another report that just contains a hyperlink to the file share.

To Save bandwidth the fileshare could be set up with Distributed File System (so the report gets generated at off peak hours and copied to the local file server -- through dfs -- and then when users go to retrieve based on the email that was sent they are only accessing the local network).

So you can see how knowing more about your goals can help us work out a better solution for you.

David Lundell
Principal Consultant and Trainer
www.mutuallybeneficial.com