I have a business requirement to export report data to an Excel spreadsheet with the caveat that a column in the report and excel must be presented as a hyperlink that refers to an external URL that is stored in separate property. I realized that there is no option to select a control in the report definition that allows displaying text as a hyperlink in the report browser. Besides showing hyperlinks in the report browser, given hyperlinks should be exported to excel spreadsheet preserving format.
I'm looking for any suggestions on how I can deal with requirements.
***Edited by Moderator Marissa to update Content Type from Question to Idea***