all groups > sql server reporting services > december 2005 >
You're in the

sql server reporting services

group:

Email from Report Viewer?



Email from Report Viewer? brianpmccullough
12/20/2005 6:56:02 PM
sql server reporting services: Hello all,

This is a really dumb question and I am sure that the answer is No, but I
have to ask it to see what other options/solutions might be available to me.

A client currently uses a Crystal Report Viewer control that allows users to
email an exported report from a desktop application. They want to move to
SSRS 2005, with a ASP.NET 2.0 front end. I would like to use the Report
Viewer control that comes with ASP.NET 2.0.

Is there any way to get a report, which is created dynamically (the rdl is
created dynamically based on user preferences and doesn't "live" on the
reporting services server) emailed to a list of email addresses?

Since the report is created dynamically and doesn't live on the Reporting
Services Server, it doesn't look like scheduling is an option...

Thanks!

Re: Email from Report Viewer? Daniel Reib [MSFT]
12/21/2005 9:43:50 AM
This is not directly supported, but you could support it in some fashion in
your app. Just place a button in you app to email the report. Then call
RenderReport on the viewer object and render to the desired format (not html
since there is no server for the images, but pdf or excell will work). Your
app can then just email the report. Of course your app needs to handle
setting up the connection to the smtp server to send the email, but you
could probably hook into outlook if you really needed to.

I hope that help.s

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


[quoted text, click to view]

Re: Email from Report Viewer? John
1/8/2006 6:09:31 PM
Hi,

Also have a look at creating your own export extensions. It may initially be
long-winded but you could get it to do exactly what you want it to.

Regards
John.

[quoted text, click to view]

AddThis Social Bookmark Button