Lotus Notes Reporting and Exports

While I think reports are a thing of the past and should be banned, the question " how to run reports on Notes" is quite popular. Today you rather would create a Dashboard than a classical report, but since it is popular, here you go (in no specific order):

• Any report generator that can access data using ODBC/JDBC can be used to access Notes Data using NotesSQL. You won't get access to RichText or encrypted data, but for anything that can be shown in a view it is a good start
• SAP Business Intelligence (the artist formerly known as Crystal Reports can read Notes data
• Same applies to IBM Cognos
• A nice open source solution is Eclipse BIRT. It can be deeply integrated into the Notes client. We have a free sample in the Sandbox
• One can use Office to run reports with Notes
• Using Lotus Enterprise Integrator data can be kept in sync with an RDBMS for reporting
• There are a number of dedicated Notes reporting products on the market
  • Synaptrics Reporting and Dashboard
  • IVE Technologies Print Merge Reporter
  • Swing Software Lotus Notes Reporting which is part of the Swing Integrator using Excel for easy reporting
  • 6w Systems ddCharts
  • NotesReports
• There are a number of projects on OpenNTF around reporting and Export, here's a selection
  • SimplePDF allows PDF reporting
  • Data Moving Animal is the one stop for all, well, data moving needs
  • ASDN is an alternative to it
• Using the Extension library Notes data is available via REST in XML or JSON formats. Quite popular these days
• And there is even more out there
• Update: There now is a native JDBC driver

As usual YMMV.