Reporting Environment

Im am using a host of tools (Report Writer, Crystal, Access) to report data against Lawson HR and Financials. However, as I get more and more complex requests, I find myself massaging the data alot in the MS Access enviroment to meet some of my reporting requirements.

Id like to understand how other practitioners have their reporting environments setup. Do you use Lawson's data mart solutions? Or have you built a custom DW? What are the challenges you still face with your solution?

Thanks!