Getting Started with Adobe After Effects - Part 6: Motion Blur


Upload Image Close it
Select File

Random thoughts about SQL Server
Browse by Tags · View All
BRH 10
tsql 8
sqlserver 8
#SQLServer 7
denali 6
BR 4
SQLServerPedia Syndication 4
SQL Server 4
#TSQL 3
2012 2

Archive · View All
March 2011 7
January 2012 2
August 2011 1
May 2011 1
April 2011 1
April 2010 1

Sankar Reddy's Blog

Using Email signatures in Reporting subscriptions

Mar 15 2011 6:20AM by Sankar   

SQL Server Reporting Services (SSRS) has rich set of functionalities that can be used effectively to automate sending of reports. In large institutions with many departments interacting with other departments internally or with external folks, its is very important to customize the delivery of the reports. “Who” is sending the reports changes depending on “who” are the recipients and even the schedules can be different.

In Reporting Services, the subscriptions can be used for this task and especially the comments section is a great way to use personalized Email signatures when sending the reports instead of sending a blank text with the report which looks NOT so good.

Here is an screenshot of a report where the email body and the email signature are customized to look slick and cool.

Code snippet used for the above is listed below. Its a HTML code plugged in the comments section of the reporting subscriptions. This can be customized and personalized as needed.

Dear Recipient,
<br>
<br>
Here is the @ReportName. Please let us know if you have any questions about the report.
<br>
<br>
Regards,
<br>
<font color="Gray"><b>FirstName LastName</b></font>
<br>
<font color="Gray"><b>Reporting Lead</b></font>
<br>
<font color="DarkOrange">Tel</font>: +001 (123) 456-7890
<br>
<font color="DarkOrange">Fax</font>: +001 (123) 456-7891
<br>
<font color="DarkOrange">Email</font>: FirstName.LastName@company.com
<br>

Here is the section of the reporting subscriptions where the above HTML code should reside.

There you have it. Once you know how it’s done you can customize this to look slick and elegant.


Republished from Sankar Reddy [39 clicks].  Read the original version here [32134 clicks].

Sankar
114 · 1% · 454
0
Liked
 
0
Lifesaver
 
0
Refreshed
 
0
Learned
 
0
Incorrect



Submit

Your Comment


Sign Up or Login to post a comment.

    Copyright © Rivera Informatic Private Ltd Contact us      Privacy Policy      Terms of use      Report Abuse      Advertising      [ZULU1097]