Have you looked in to Crystal Reports at all? It has numerous advantages.

It will connect to all of the data sources you have including spreadsheets, and can integrate data from more than one source at a time. i.e. you may have most of your data in a spreadsheet, with some additional info in Access and a little more in ...

The Crystal Engine itself is available via API within certain SDK's. I know it's available in MS Visual Studio. It is also available in Java.

If you build your own solution using the API you can custom connect to each of your data sources and distribute the results however you need them - via email, ftp or file save - as pdf, excel, HTML, and so forth. You can even use the reporting tool as a Data Transformation Service by writing the results back to an ODBC database.

This platform is more than capable of reporting on data you've collected via your user interface such as clicks, time between clicks, undo, etc. Anything you want to track - as long as it's stored somehow.

I hope that helps. If you need further examples or details feel free to arrange a call, I'd be happy to help.