<

Web Links Don't Show in SSRS 3.0 Subscribed Reports?

Published on
9,367 Points
3,367 Views
Last Modified:
Approved
It is helpful to note: This is a cosmetic update and is not required, but should help your reports look better for your boss.  This issue has manifested itself in SSRS version 3.0 is where I have seen this behavior in.  And this behavior is only seen in e-mail that has been received in Outlook.

When subscribing to SSRS Reports, and when the e-mails are received, it is entirely possible that you don't or can't see the web links when provided in the results.  Note: The links do indeed work, but cosmetically, they don't appear like a web link in the report.

For example in Outlook (I am using Outlook 2010, but it should not matter the version for this issue), the links are there and they do work fine, but cosmetically they don't show unless you rest your mouse of the link - in this example, it is using the Ticket number:
No link showing on Ticket ID
Now, looking at the Text Properties box we see:
Text Box Properties we need to change
Making the following changes in code:
Style / Bold
=IIF(Fields!Ticket_ID.Value<>"",Bold,"")

Color / Blue
=IIF(Fields!Ticket_ID.Value<>"",Blue,"")

Effects / Underline
=IIF(Fields!Ticket_ID.Value,Underline,"")

Open in new window


Ahh now the results in Outlook:
Result Link in Outlook e-mail
Now this looks correct.

What is going on here?
Style / Bold
=IIF(Fields!Ticket_ID.Value<>"",Bold,"")
This adds in the Bold Style if there to test the existence of the Ticket_ID in SSRS.  If the Ticket_ID does not exist, it would be blank (or null).

Color / Blue
=IIF(Fields!Ticket_ID.Value<>"",Blue,"")
This adds in the Blue Color if there to test the existence of the Ticket_ID in SSRS.  If the Ticket_ID does not exist, it would be blank (or null).

Effects / Underline
=IIF(Fields!Ticket_ID.Value,Underline,"")
This adds in the Underline Effect if there to test  the existence of the Ticket_ID in SSRS.  If the Ticket_ID does not exist, it would be blank (or null).

For whatever reason, Microsoft does not render the Web Links in Outlook.  This does not change how the links look on the web site as they show correctly in MHTML format.
0
Comment
Author:Kent Dyer
0 Comments

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Join & Write a Comment

There may be issues when you are trying to access Outlook or send & receive emails or due to Outlook crash which leads to corrupt or damaged PST file. To eliminate the corruption from your PST file, you need to repair the corrupt Outlook PST file. U…
If you are looking for an automated solution for backup single or multiple Office 365 user mailboxes to Outlook data file, then you can use Kernel Office 365 Backup & Restore tool. Go through the video to check out the steps to backup single or mult…
Suggested Courses
Course of the Month6 days, 8 hours left to enroll

Keep in touch with Experts Exchange

Tech news and trends delivered to your inbox every month