I am trying to create a report, in Crystal or KACE, to capture the information listed in the "Add Work" area of the Help Desk. I need to obtain the following information for each ticket:
*Time Spent
*Work Date
*Work Start
*Work End
*Work Note

In Crystal, the 'HD.WORK.ADJUSTMENT_HOURS' produce an output of "1.00" and the 'HD.WORK.NOTE' displays "completed." Can someone please assist with this?

Thanks in advance for your help!
0 Comments   [ - ] Hide Comments


Please log in to comment

Rating comments in this legacy AppDeploy message board thread won't reorder them,
so that the conversation will remain readable.
Answer this question or Comment on this question for clarity


Resolved: I was able to obtain the report output I needed in Crystal Reports. The problem was resolved by clearing all of the table links in Crystal and manually linking the appropriate tables (HD_WORK, HD_TICKET, HD_USER, etc.). After performing this step, the data was displayed properly (YAY!!)

Answered 06/16/2011 by: LamBam
Senior Yellow Belt

Please log in to comment