Showing posts with label share. Show all posts
Showing posts with label share. Show all posts

Friday, March 30, 2012

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

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

sql

Monday, March 26, 2012

Report Delivery Option Missing

I have a SQL 2005 Reporting Server, and notice the only report delivery option
I see is 'export to a file share'. How to I enable the email option? Did
I perhaps miss something during installation?
Regards,
Pete Zerger, MCSE(Messaging), MVP - MOM
Co-founder and Webmaster, MOMResources.org
URL:http://www.momresources.org
BLOG: http://www.it-jedi.net/
mailto:pete.zerger@.gmail.com
...or find me in the forums at http://momcommunity.coAre your e-mail setting configured for ReportServer? You can check by going
to Report Services Configuration from Configuration Tools Under SqlServer2005.
"Pete Zerger" wrote:
> I have a SQL 2005 Reporting Server, and notice the only report delivery option
> I see is 'export to a file share'. How to I enable the email option? Did
> I perhaps miss something during installation?
> Regards,
> Pete Zerger, MCSE(Messaging), MVP - MOM
> Co-founder and Webmaster, MOMResources.org
> URL:http://www.momresources.org
> BLOG: http://www.it-jedi.net/
> mailto:pete.zerger@.gmail.com
> ...or find me in the forums at http://momcommunity.com
>
>

Report consuing a SSIS package

Has anyone had success in getting a report to generate by using an SSIS
package as it's data source? If so - can you share how you got it to work -
a couple of us who are pretty able bodied can't seem to get it to work as
Microsoft reports it should.Just visit this site for a very good hands on
http://blogs.msdn.com/bimusings/archive/2006/07/19/671743.aspx and ofcourse
MSDN for configuration as well.
I have tried it, its working fine.
Amarnath
"Joe" wrote:
> Has anyone had success in getting a report to generate by using an SSIS
> package as it's data source? If so - can you share how you got it to work -
> a couple of us who are pretty able bodied can't seem to get it to work as
> Microsoft reports it should.
>