How do I add links in Report Tables?

You can add hyperlinks in a SQL Statement using the steps illustrated below

1. Enter link via SQL

  1. Open Report Editor, Data tab
  2. Enter SQL statement as follows:
 Select 'google' as Target, 'http://google.com' as URL

1.1. Validate Statement

  1. Click Show Data
  2. Confirm that information displayed in Sample Result Set is recognized as link

1.2. Update Report

  1. Confirm that the URL redirects to 'google.com'

2. Use links in SQL Queries

  1. Enter your query into SQL Statement text box and use concat function to format web address into link as above
  2. Click Show Data
  3. Review Sample Result Set

2.1. Update Report and check links

Update Report and check links

2 Comments

Siva Subramaniam

How to do this when the data source is Tableau instead of SQL?

Barbara Kennedy

Hi Siva,
The answer depends on the complexity:
-– If it’s just to add a repeating URL you can use a derived field (http://img.mtrc.in/1h3D2i2a0e17)
-- If it’s to link to a filter value, you should use a dataset and then map the report to the filter values
-- Alternatively, you can use the SQL method covered in this article

Please contact support@metricinsights.com if you require further assistance

Add your comment

E-Mail me when someone replies to this comment