Solved

SSRS Report in Body of the Email

Posted on 2010-11-15
5
1,204 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
Comment Utility
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
Comment Utility
Use as HTML  render typa and it will be body of the email
0
 
LVL 2

Author Comment

by:davidi1
Comment Utility
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
Comment Utility
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
Comment Utility
Thanks
0

Featured Post

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

Written by Valentino Vranken. Introduction: In a previous article (http://www.experts-exchange.com/articles/Microsoft/Development/MS-SQL-Server/MS-SQL_Reporting/Reporting-On-Data-From-Stored-Procedures-part-1.html) I announced that I would writ…
A recent questions about how to add SSRS named instances, couldn't find any that talks about SQL server 2008, anyway I decided to help by creating some screen shots. The installation is straightforward, you just pop the SQL server 2008 installati…
This video discusses moving either the default database or any database to a new volume.
This tutorial demonstrates a quick way of adding group price to multiple Magento products.

762 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

10 Experts available now in Live!

Get 1:1 Help Now