+1 for Jaspersoft (we're using it at my workplace and are quite satisfied). From my experience, the one thing that can make reporting easier (or a lot harder) is the structure of the DB/stored data, so I believe putting an extra effort in DB design with reporting in mind is a smart move ..