Solved

SSRS Report in Body of the Email

Posted on 2010-11-15
5
1,211 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

DevOps Toolchain Recommendations

Read this Gartner Research Note and discover how your IT organization can automate and optimize DevOps processes using a toolchain architecture.

Question has a verified solution.

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

In this short article I will be talking about two functions in the SQL Server Reporting Services (SSRS) function stack.  Those functions are IIF() and Switch().  And I'll be showing you how easy it is to add an Else part to the Switch function. T…
Introduction As you'll probably know, a data region in a SQL Server Reporting Services report can be linked to only one dataset.  This makes it troublesome when you need to display data from more than one dataset in the same data region.  SQL Serve…
This video shows how to quickly and easily add an email signature for all users on Exchange 2016. The resulting signature is applied on a server level by Exchange Online. The email signature template has been downloaded from: www.mail-signatures…
Established in 1997, Technology Architects has become one of the most reputable technology solutions companies in the country. TA have been providing businesses with cost effective state-of-the-art solutions and unparalleled service that is designed…

831 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