Where I am now, we tend to roll our own...
Which I'm not a big fan of.
Prior to that I was well versed with the Business Objects (now a division of SAP) line of products. We had a Full blown BO XI R2 deployment complete with Web Intelligence, The OLAP presentation layer tool, crystal reports, and some other add-ons I don't remember off the top of my head.
The above or perhaps Cognos tend to be the top leaders in the field. Personally, I think that the SAP offering is the better of the two. Cognos has some amazing OLAP stuff, but their stuff for canned reports (which will never go away) wasn't as rewarding as crystal. And Web Intelligence is some pretty awesome stuff from SAP now.