How do I turn the ticket number from a K1000 report into a URL that would take you back to the ticket?
Essentially, this is more an executive level report of departmental tickets submitted. Instead of having the exec have to go back to KACE and search for ticket, I figured there might be a way to link the report output to ticket by the using of something like this
CONCAT('https://gatekace1.gatepetro.com/userui/ticket.php?ID=',HD_TICKET.ID) AS "Ticket URL"
but it only shows the link. I'm wanting it to be clickable.
Are you using Classic Reports or the new reporting engine? If you're using Classic Reports then you might be able to use the Jasper Layout tool to customize the report output to get this result. There's a knowledge base article available here that gives more information: http://www.kace.com/support/resources/kb/article/Customizing-a-Report-Layout-With-Jasper-iReport P.S. It would be helpful if you tagged your questions to make them easier to find for others that might have similar questions in the future.