Good morning all!
I’ve got a Toad Data Report pulling data from a SQL server that contains both dynamic and static hyperlinks.
For the dynamic hyperlinks:
Within the report detail band I have a ticket number (unique value) along with additional ticket details (dates, notes, etc). I created a calculated field called DynURL that would concatenate a URL string like ‘www.domain.com/id=’ and the ticket number ( Concat(‘www.domain.com/id=’,[ticket number]) ) to produce a string like www.domain.com/id=1234. In the ticket number’s field properties, I navigated to Data > (DataBindings) > NavigateUrl > Binding and set that to my DynURL calculated field.
For the static hyperlink:
This is just a label with a static email address that resides in a group footer at the bottom of the report. In the label properties, I navigated to Navigation > NavigateUrl and set that to my email address ‘mailto:email@example.com’ and set the Target to _blank.
Previewing the report in TDP:
Both dynamic and static hyperlinks function as desired.
Exporting report to HTML format.
When opening report in browser, both dynamic and static hyperlinks function as desired.
Database Activities > Toad Report > Export report file as HTML
System Activities > Send Email > Activity Input > Use file for body: - Here is where I’ll select the HTML file from Toad Report export just performed.
Test run and automation successfully completes and I receive an email with the HTML report file embedded.
When I go to test the hyperlinks in the email:
The dynamic hyperlinks are dead, meaning click with no action, but the mouse icon still changes as if it recognizes them as hyperlinks.
The static email hyperlink works as desired.
The dynamic hyperlink functionality essentially fails when an HTML report is embedded in email. Am I missing something or is there a possible remedy for my issue?
Some add’l info:
- Using TDP v 188.8.131.5276
- Email distribution through Exchange platform & SMTP
Any help would be greatly appreciated!