Of the tools I haven't tried, QlikView sounds very nice and looks like it would do what you need:

http://www.qlik.com/

I've tried several other reporting alternatives, and so far, I've been disappointed with most.

We're currently using Microsoft SQL Reporting Services and Crystal Reports, and are happy with neither (and they don't do what you need).

Edit: Tableau (what undertheradar2 mentions) sounds nice too:

http://www.tableausoftware.com/

The other one mentioned in the conversation is Spotfire

http://spotfire.tibco.com/

Edit2: they all sound pretty expensive though.