/build/static/layout/Breadcrumb_cap_w.png

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.


0 Comments   [ + ] Show comments

Answers (1)

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.
Posted by: chucksteel 12 years ago
Red Belt
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.

 


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

Don't be a Stranger!

Sign up today to participate, stay informed, earn points and establish a reputation for yourself!

Sign up! or login

Share

 
This website uses cookies. By continuing to use this site and/or clicking the "Accept" button you are providing consent Quest Software and its affiliates do NOT sell the Personal Data you provide to us either when you register on our websites or when you do business with us. For more information about our Privacy Policy and our data protection efforts, please visit GDPR-HQ