Generally the ones I run in to - regardless of what product, so long as the backend is SQL - would be Crystal Reports, SSRS, and Qlikview, with Crystal taking generally the top prize since BMC has/does use it quite a lot, since it's former mid-market offering, Service Desk Express (SDE, formerly known as 'Magic') leveraged it, Remedy uses is, and Track-It uses it.
Aside from that, I'll often see a combo of SQL queries and complex Excel spreadsheets used as well. Though these tend to be less structured and involve a lot of manual labour each time a report needs to be "run".
Thank you - I need to research a couple of these. We do use a lot of Excel and SQL queries. A lot. A lot. I've got quite a few where I've set up a standard report and then just replace the data - and it works well for one offs, but not so much for comparative reports since that often requires a lot of data and Excel starts balking.