Miscellaneous

I've created a ticket queue for a team to identify colleague improvements needed.  I added a custom user type field they can search for the colleague identified instead of using and having to update a label.  Trying to create a weekly report of the tickets and the Colleague Name field shows as a number on the report.  What can I do to get the name to display on the report instead of the number?  I used the reporting wizard and this is the SQL

SELECT HD_TICKET.ID, HD_TICKET.TITLE, HD_TICKET.SUMMARY, S.USER_NAME AS SUBMITTER_USER_NAME, S.FULL_NAME AS SUBMITTER_NAME, O.FULL_NAME AS OWNER_NAME, HD_TICKET.CUSTOM_FIELD_VALUE0, HD_TICKET.CUSTOM_FIELD_VALUE2, HD_CATEGORY.NAME AS CATEGORY, GROUP_CONCAT(DISTINCT HD_TICKET_CHANGE.COMMENT SEPARATOR '\n') AS HD_TICKET_CHANGE_COMMENT_GROUPED, IF(HD_TICKET.HD_USE_PROCESS_STATUS and HD_TICKET.IS_PARENT, HD_SERVICE_STATUS.NAME, HD_STATUS.NAME) AS STATUS_NAME, HD_TICKET.CUSTOM_FIELD_VALUE5, HD_TICKET.CUSTOM_FIELD_VALUE1, HD_TICKET.CUSTOM_FIELD_VALUE8, HD_TICKET.CUSTOM_FIELD_VALUE4, HD_TICKET.CUSTOM_FIELD_VALUE3, HD_TICKET.CUSTOM_FIELD_VALUE6, HD_TICKET.CUSTOM_FIELD_VALUE12, HD_TICKET.CUSTOM_FIELD_VALUE13, HD_TICKET.CUSTOM_FIELD_VALUE7, HD_TICKET.CUSTOM_FIELD_VALUE11  FROM HD_TICKET  LEFT JOIN USER S ON (S.ID = HD_TICKET.SUBMITTER_ID) LEFT JOIN USER O ON (O.ID = HD_TICKET.OWNER_ID) JOIN HD_CATEGORY ON (HD_CATEGORY.ID = HD_TICKET.HD_CATEGORY_ID) LEFT JOIN HD_TICKET_CHANGE ON (HD_TICKET_CHANGE.HD_TICKET_ID = HD_TICKET.ID) LEFT JOIN HD_SERVICE_STATUS ON HD_TICKET.HD_USE_PROCESS_STATUS and HD_TICKET.HD_SERVICE_STATUS_ID and HD_SERVICE_STATUS.ID = HD_TICKET.HD_SERVICE_STATUS_ID JOIN HD_STATUS ON (HD_STATUS.ID = HD_TICKET.HD_STATUS_ID) WHERE (HD_TICKET.HD_QUEUE_ID = 44)  GROUP BY HD_TICKET.ID ORDER BY ID