Notes View and Crystal Reports

HCL Domino Domino Forum
1

This is the situation:

I have written crystal reports using several views in the pass month experiencing NO problems. Recently when I want to Add/Delete fields from a view I encounter data type issue. The issues are that Crystal Reports or SQL driver302e converts fields that are defined in Notes as date and number to string. Also, it changes subtotals for fields to counts. And it(the conversion when a Set Location is done) destroys the report in general.

The bottom line is that I can not change an existing report or create a new report accessing any of the views now.

However, I can run existing reports that have existing views that haven’t been changed.

I have reinstalled Lotus Notes SQL 302e think the views weren’t being interpted properly and it was corrupted. Next, I created brand new ODBC connects so crystal can access the views. We have tried running crystal reports on my Local (PC) on a server Development and server Cortina all do NOT work properly accessing these views.

Normally when I would make a changes to Notes views I set the database table(Set Location) in crystal to pick up the last change related to the view and it worked fine. But now it doesn’t.

There have been NO Lotus Notes or server upgrades recently.

Below is an information error message is generated when I access a newly created view with crystal:

ODBC error:[lotus][ODBC Lotus Notes][Lostus Notes Server][Notes API dirver error” Entry not found in index

Which versions are running?:

Crystal Reports is 8.01,

Lotus Notes SQL driver is 3.02e

Lotus Note 6.5.1.

Thanks in advance for any help in this matter.

Rob

2

Subject: Notes View and Crystal Reports

I have had similar problems with reports and what I have done for the columns that have been changed, I have created formulas in crystal and used them istead notes columns.

3

Subject: Notes View and Crystal Reports

One of the advantages of using a higher end data driver is that it will handle things like dates correctly. For example, Proposion N2N, our managed ADO.NET data driver for Notes back ends, returns real .NET DateTime objects. We have developed a plug-and-play add-on for Microsoft Reporting Services which (of course) uses our data driver under the hood and makes a very nice reporting solution for Notes.

I have not dug into Crystal all that much, but I understand that it also has some capabilities for using ADO.NET data drivers. Maybe there is a possibility for using Proposion N2N there as well. We will investigate this and report back.

-Steve