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, '' 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 ''

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


Add your comment

E-Mail me when someone replies to this comment