SSRS Report in Body of the Email

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
LVL 2
davidi1Asked:
Who is Participating?
 
HadushConnect With a Mentor Commented:
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
 
Philippe DamervalSenior Analyst ProgrammerCommented:
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
 
HadushCommented:
Use as HTML  render typa and it will be body of the email
0
 
davidi1Author Commented:
Hadush - i dont have HTML render type in SSRS 2008 R2. I only have MHTML
0
 
davidi1Author Commented:
Thanks
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.