[SDF-28875] Add Link within SQL report

I am attempting to generate a report with links to overdue tasks, but seem to be unable to create a clickable link. Oddly enough the html link that I generate seems to be parsing enough to only show the text part of the link, but without the href action.

SELECT "taskdet"."TASKID" AS "Task ID",
CONCAT('<a href="https://servicedesk.ourServer:8080/TaskDetails.cc?PORTALID=301&TASKID=',taskdet.TASKID,'\">',taskdet.TASKID,'</a>') AS "Task Link",
"wotask"."WORKORDERID" AS "Request ID",
"wotask"."TITLE" AS "Request Title",
"taskdet"."TITLE" AS "Task Title",
CAST(DATEADD(SECOND, "taskdet"."CREATEDDATE"/1000,'1970/1/1') AS DATE) "Created Date",
"taskstatus"."STATUSNAME" AS "Task Status",
"cd"."CATEGORYNAME" AS "Request Category"
FROM "TaskDetails" "taskdet"
LEFT JOIN "StatusDefinition" "taskstatus" ON "taskdet"."STATUSID" = "taskstatus"."STATUSID"
LEFT JOIN "WorkOrderToTaskDetails" "wototaskdet" ON "taskdet"."TASKID" = "wototaskdet"."TASKID"
LEFT JOIN "WorkOrder" "wotask" ON "wototaskdet"."WORKORDERID" = "wotask"."WORKORDERID"
LEFT JOIN "WorkOrderStates" "wos" ON "wotask"."WORKORDERID" = "wos"."WORKORDERID"
LEFT JOIN "CategoryDefinition" "cd" ON "wos"."CATEGORYID" = "cd"."CATEGORYID"
WHERE
taskdet.MODULE = 'request'
AND wotask.ISPARENT = '1'
AND "taskstatus"."STATUSNAME" = 'Assigned'
AND DATEDIFF(DAY, CAST(DATEADD(SECOND, "taskdet"."CREATEDDATE"/1000,'1970/1/1') AS DATE), GetDate()) >= 3