Notes Some Frustrations

First Post, First Frustration!

How do people report from Domino applications?
we have a one or two large applications which require reporting functionality. They have a number of forms that are related to each other (i.e. Doc A can have many Doc B's - not responses). We need to report from these on a weekly/monthly basis and also on an ad-hoc basis.

Crystal Reports is OK but linking multiple form types is very slow...

JasperReports is OK but unfriendly from the client point of view and relies on NotesSQL... same linking slowness

Cognos - OK but has trouble running SQL queries on multiple tables through NotesSQL driver....

To me an ideal solution would be the DB2 backend as this should allow easy reporting from any app to DB2. I haven't had chance to install an 8 server yet but can an existing app be moved to DB2 backend easily? Are there performance issues?


Does anyone have any comments on how they cope with the Notes reporting issues and any guidance on the best way forward?