Avatar of davidi1
davidi1
Flag for India asked on

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
SSRS

Avatar of undefined
Last Comment
davidi1

8/22/2022 - Mon
Philippe Damerval

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
Hadush

Use as HTML  render typa and it will be body of the email
davidi1

ASKER
Hadush - i dont have HTML render type in SSRS 2008 R2. I only have MHTML
This is the best money I have ever spent. I cannot not tell you how many times these folks have saved my bacon. I learn so much from the contributors.
rwheeler23
ASKER CERTIFIED SOLUTION
Hadush

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
davidi1

ASKER
Thanks