Solved

SSRS Report in Body of the Email

Posted on 2010-11-15
5
1,220 Views
Last Modified: 2012-05-10
Team,

I have used SSRS 2005 & 2008 & know how to develop reports & subscribe for auto email. What I would like to know is, instead of an attachment / link, Is there a way to put the report in the body of the email?

Thanks,
David
0
Comment
Question by:davidi1
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
5 Comments
 
LVL 9

Expert Comment

by:Philippe Damerval
ID: 34139706
Not using the built-in email functions of SSRS. However, nothing stops you from writing a function in .Net that exports the report to HTML and then sets the body of the email to whatever you need plus the report. Remember, however, that HTML email is a slippery slope. Different email clients display things entirely differently. You're better off (and will have substantially less programming to do) if you go with the built-in SSRS functionality.

Thanks,

Philippe
0
 
LVL 8

Expert Comment

by:Hadush
ID: 34140471
Use as HTML  render typa and it will be body of the email
0
 
LVL 2

Author Comment

by:davidi1
ID: 34140541
Hadush - i dont have HTML render type in SSRS 2008 R2. I only have MHTML
0
 
LVL 8

Accepted Solution

by:
Hadush earned 500 total points
ID: 34140565
Sorry that is what I meant. I have 2008 too and if want to display on the body of the email I use MHTML  However, it works best for flat reports.
0
 
LVL 2

Author Comment

by:davidi1
ID: 34140797
Thanks
0

Featured Post

On Demand Webinar: Networking for the Cloud Era

Did you know SD-WANs can improve network connectivity? Check out this webinar to learn how an SD-WAN simplified, one-click tool can help you migrate and manage data in the cloud.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Steps to solve SSRS SQL 2008 R2 User Access Control (UAC) Permission Error With the introduction of SQL Server 2008 R2 and Vista (Windows 7 as well) came new enhanced security features. One of the features included was User Access Control (UAC) t…
Introduction Earlier I wrote an article about the new lookup functions (http://www.experts-exchange.com/A_3433.html) that ship with SQL Server 2008 R2.  In this article I’m going to show you another new feature of SSRS 2008 R2, this time in the vis…
In this video we outline the Physical Segments view of NetCrunch network monitor. By following this brief how-to video, you will be able to learn how NetCrunch visualizes your network, how granular is the information collected, as well as where to f…
Monitoring a network: why having a policy is the best policy? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the enormous benefits of having a policy-based approach when monitoring medium and large networks. Software utilized in this v…

726 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question