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.
Answers (1)
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.
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.
Comments:
-
Since my version is 5.3, I appear to be on the new reporting engine. Can I assume that the Jasper tool will not work - jholmes 12 years ago
-
I don't think they have released a way to edit the report layouts for the new tool. If you submit a support request they might have different information, though. - chucksteel 12 years ago
