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.

Answer Summary:
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.
Cancel
0 Comments   [ + ] Show Comments

Comments

Please log in to comment

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.

 

Answered 04/25/2012 by: chucksteel
Red Belt

  • This content is currently hidden from public view.
    Reason: Removed by user request
    For more information, visit our FAQ's.
  • 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
  • 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.
Please log in to comment
Answer this question or Comment on this question for clarity