There several products available in the market to satisfy your data need.
Here are a few:
Proclarity
http://www.proclarity.com/
Reporting Services ( free with SQL 2000 License)
Excel can be very power when used with Analysis Services (SQL 2000 Enterprise Edition) for OLAP Reporting.
Microsoft Data Analyzer