Hello,
I’m running a Crystal Report, which is connected via ODBC to a Notes Database. I want to have access to private views in the report but they are not visible (but they are while connecting natively, provided I set a flag in the registry)
Any ideas on how to make private views appear in the datasource and in Crystal?
Thanks
Subject: ODBC and private views
If you can use ADO.NET data drivers instead of ODBC, Proposion N2N can definitely handle the Private views and folders. Someone once told me that crystal could handle ADO.NET, but I do not know the details. See Products A-Z.
Also, have you considered Microsoft SQL Reporting Services? This is a new reporting tool that competes with Crystal, etc. It is an amazingly popular product, partly because if is now free (retroactively) with your SQL Server license. I was amazed at how many people I met at Lotusphere who were already using it.
Anyway, Proposion Report Adapter is an add-in that turns Microsoft Reporting Services into a great reporting/charting tool for Lotus Notes databases. Our extension knows all about the “weird” things in the Notes world like attachments, images, multi-valued items, and access control rules. In addition, we add the option of delivering reports (regardless of the data source) to subscribers via native Notes mail and/or depositing scheduled reports into Notes databases (which allows users to build cool report archiving/workflow/distribution applications). See Products A-Z.