David,

If you're using reporting services and users have web access to run reports then reports can easily be integrated into Excel (not sure about Excel 2000) using a web query.

This removes the need for stored procedures and gives the advantage of formatting coming over with the data.

As far as integrating SSAS with SSRS then this can be done, although my experience with this runs as far as building a proof of concept for a client.

The disadvantage of SSAS though is that for smaller systems the Analysis services adds an extra layer of complexity and a requirement of technical knowledge that not all companies (especially the smaller ones) need or want.