How to add links in Report Tables (versions prior to 5.3)

New in 5.3, adding links to Reports created from Datasets has been improved and simplified. Refer to Adding Links to Dataset Reports

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

  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 ''
  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
Update Report and check links