People in the Notes world are very familiar with the eternal quest for a good reporting solution. Opinions on the topic range from "Notes doesn't do reporting" to "Notes reporting sucks" to "would you like to buy my add-on reporting product?" (I admit it, I created two such products myself in my 14 year Notes career.)
Over the last year, I have seen a few people adopt a clever solution to this problem: put the data in SharePoint! It is fairly easy to use Notes Migrator for SharePoint to transfer Notes data to SharePoint lists and libraries, of course, but few people realize how well that works as an interim reporting solution. Once you get your Notes data into a SharePoint list, you then have a variety of reporting options available:
- Build views directly on the SharePoint lists themselves (using built in SharePoint features or SharePoint Designer depending on how fancy you wanted to get).
- Build even fancier views, including roll-up views across dozens of lists on dozens of SharePoint sites, using Quest Web Parts for SharePoint.
- Use SharePoint "dashboard" / "KPM" features. (I do not have much experience with this, but it looks cool.)
- Use SQL Server Reporting Services to report against those SharePoint lists. (Microsoft could have made this easier, but it is quite doable if you search the web for some guidance.)
Notes Migrator for SharePoint can be scripted to re-migrate the same list on a nightly bases (or whatever schedule you want) and has great support for incremental migration (moving just the new/modified documents). Of course this tool will also help when it comes time to do the real migration.