Heat. With Crystal Reporting being the search engine.
Heat sucks incredibly hard. It is almost impossible to search within the application. Hence, we had a crystal reports person who did reports from the database. Except that he quit, and the company isn't going to replace him. So we currently have a crap helpdesk system that you cannot search old tickets on with accuracy. It is close to useless. I hate this application with an undying passion, it is horrible.
I have in the past used Vantive, Lotus Notes custom DB, and Remedy. Remedy is the most robust of those options, Vantive is the easiest to use in my opinion. Either would work for you, but I haven't used them in about 7 years so your mileage may vary on my opinion.