Hi,
I've been trying to create a helpdesk report to display ticket information which includes multiple custom fields. Unfortunately it seems like this is either not possible or extremely difficult as all of the data is contained within one table; htblticketcustomfield.
The custom fields in this case are being used to define the category of the ticket, i.e. application/service issue, hardware issue, data issue etc. and under each of those there is another custom field nested. For example under application/service issue there is another custom field with a list of applications.
Could this be improved by either changing the table structure or creating some standard custom fields with some standard reports linked? This would enable us to begin reporting on the types of calls logged, by user, by department, by source, by type of incident/request etc.
Thanks,
Josh
