We have a table that contains a URL which is stored in our database. Rather than show the full URL, there is a hyperlink (imaginitively named 'Link'). The formula looks like this:
='Link'&<url>'&PageTable.PageURL
This works like a treat in the application but when users export the table to Excel, they just see the text 'Link' and no URL.
Is there a way to export this and keep the hyperlink, so it says 'Link' in Excel and the link still works? Naturally we could just use the PageTable.PageURL field, but it looks messy in the report.
Thank you for your suggestions.
