Email Export?

Hello,

In the Crystal Report Viewer control, there is a way to export a report to the file format of choice (i.e. pdf or xls) and have it emailed.

This is probably a stupid question, but I have to ask it...

Is there a way to have an exported report in SSRS 2005 emailed without saving the report and then attaching it to an email?

I know about the scheduling services, but that will not work for me as my reports are created dynamically and displayed throught the ASP.NET 2.0 Report Viewer Control.

Thanks!!!

-Brian

Hi,

Have you tried Report Subscription using "Report Server E-mail" option? In BOL this is discussed under "E-Mail Delivery in Reporting Services". While configuring reports to be sent as an email you can include the report as a link or/and as an attachment.

HTH

Uday

|||

There is no supported email export. If you use the Viewer controls then your app could export the report and then send the email. Your app would have to take care of all smtp settings however.

-Daniel

|||

Thanks for the response Uday, but as noted in my original post, the report is created dynamically and not a published report. I cannot use the Scheduling/Subscription functionality...

-Brian

|||

Not built-into the ReportViewer control. Since you are sitting in code already, it is possible to wire this up really quickly using the classes in the System.Web.Mail namespace.

-Lukasz

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

|||

I am guessing I would need to use the ReportViewer's RenderStream method, but I cannot find good documentation on the parameters that are needed to call this method (i.e. streamId, mimeType, etc...). Which ones are required? I know what each does from the MSDN documentation, but I am looking for an example of this in use.

I am calling the RenderStream method and passing in empty strings (String.Empty) for each of the parameters and I am getting the following error:

"The selected report is not ready for viewing. The report is still being rendered or a report snapshot is not available. (rsReportNotReady)"

Any Ideas?

Thanks!

-Brian