Friday, May 11, 2012

How to add break line and a link in comments field in SSRS “Manage Subscription” page ?

Environment: Project Server 2007/ SSRS component integrated with SharePoint 2007/ iPad

Issue:


There is good news for SSRS developers/Admin using SSRS email subscription in Project Server/SharePoint environment. Sending emails (out of the box feature) using “Comments” field for email body (see Fig “A” below) is always excited but  a few restrictions like not using break line and link made developers very uncomfortable to sell this part. Keep in mind this comments field is a Text field. MS Outlook client was smart and considering any text as URL (if starts with Http://...”) but if you open the same email on Outlook Web App/Mobile/iPad, it shows URL simply like a text with no link (see Fig “B” below)


                                                                                                   Fig “A”


                                                                                               Fig “B”

These restrictions continue till SQL Server 2005 but luckily SQL server 2008 addressed this issue and allowed developers to use HTML tags in the Comment text field.


Solution:

As I mentioned that SQL Server 2008 allows us using HTML tags to put break line and links.  As an example, I will show the changes to achieve this result.

In Comments field on "Manage Subscription” window, enter the following

This week's Flash Reports are available. Please click the following URL to access the documents <a href="http://epmxxx.com/exec/default.aspx"> http://epmxxx.xom/exec/default.aspx</a> <br/> If you have any issue, please contact to Support group.

And you will see the following output on Outlook Web App/Mobile/iPad


 

 I am sure this is very good news to all Admin/Dev who want to use Out of the box features as much as possible and make their clients happy.

I hope it helps!

5 comments:

  1. Really appreciate this wonderful post that you have provided for us.Great site and a great topic as well i really get amazed to read this. Its really good. Coffee Shops

    ReplyDelete
  2. I feel very grateful that I read this. It is very helpful and very informative and I really learned a lot from it. https://smokeprofy.com/blog/how-to-rehydrate-pipe-tobacco/

    ReplyDelete


  3. hell0 !!
    I Simply wanted // to inform you that you have people like me who appreciate
    your work. checkout Dubai Half-Day City Tour Packagesthank for posting high standard blog post.



    ReplyDelete