Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
patshaw
Posting Yak Master
177 Posts |
 Posted - 2010-07-01 : 07:40:58
|
| Hi,I have a report in our Reporting Services environment that I want to send out and display via email to out DBA team. I set up a subscription sending the report in MHTML which works fine but for one thing which is quite important to us......The team have iPhones and the iPhone has an issue rendering MHTML reports, half of the report cannot be viewed.So, I changed the output to Excel in the subscription but this doesn't show the report in the email, instead it attaches it which isn't what I want as I want the report to be visible on opening the email.I then thought about ditching the subscription and sending out an automated database mail send and trying to include the report in the email body by referencing the link to the report on our report server. Unfortunately, this displays the link and not the report.Can anyone think of a solution to this or a way to get the body to report and not the link text??Thanks. |
|
|
yosiasz
Master Smack Fu Yak Hacker
1635 Posts |
Posted - 2010-07-01 : 16:44:08
|
| 1. two subscriptions one for hand held devices the other for others. What kind of markup do hand held devices take? wml or what? 2. dump the report as xml somewhere and have another process wrap it for hand held devices or othersimho<><><><><><><><><><><><><><><><><><><><><><><><><>If you don't have the passion to help people, you have no passion |
 |
|
|
|
|
|
Send SSRS Report body in Database Mail