Solved

SSRS Report in Body of the Email

Posted on 2010-11-15
5
1,207 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
  • 2
  • 2
5 Comments
 
LVL 9

Expert Comment

by: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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

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…
It is helpful to note: This is a cosmetic update and is not required, but should help your reports look better for your boss.  This issue has manifested itself in SSRS version 3.0 is where I have seen this behavior in.  And this behavior is only see…
Delivering innovative fully-managed cloud services for mission-critical applications requires expertise in multiple areas plus vision and commitment. Meet a few of the people behind the quality services of Concerto.
A company’s greatest vulnerability is their email. CEO fraud, ransomware and spear phishing attacks are the no1 threat to a company’s security. Cybercrime is responsible for the largest loss of money to companies today with losses projected to r…

914 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

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now