i use php with fpdf or the excel engine to create insane reports using ado or sql or whatever. then just setup a routine to run them on schedule or demand. not as easy as crystal reports but i need super flexibility in scheduling and ranges plus multi-sources (i might pull from 3 databases of different type to gather all the information). this isn't that hard. the excel writer pear plugin is VERY nice and execs love xls for some reason. alot of businesses take the xls files then run macro's on them to export them to their own erp systems if they do not have a a dedicated xml or edi middleware to handle it. good thing about xls is everything opens it (openoffice, OLE, etc). you can even use ODBC to open xls files as source and sql statements to fetch data from the worksheets.
plus of course its free to do it your own way and not having to pay for commercial software is a huge++