I am using CR 11.5 (R2), with a Lotus Notes 7 view as the datasource for my report, I am using an ODBC connection with the Notes SQL Driver 3.02 to connect to this view. For some reason certain records are being dropped from the report. When I go directly into Notes and look at the view I can see all of the records, but not all of them show on the report even though I have removed all of the record selection criteria.
I was perplexed by this so I created a brand new report linking to the same source with the same ODBC connection, the result was the same. Initially there was just one record missing, then my user created another record in the source database that was immediately visible in the view but did not show up on the report after refreshing the data.
I tried logging off and logging back onto the server, resetting the datasource location back to the same datatsource, getting out and then back into Notes and Crystal, rebooting, all with no change in the result. I had a Notes admin examine the properties of the view and of each specific record that doesn't appear on the report, he couldn't see any reason why they wouldn't appear.
I have been working with Crystal for over 10 years and I've never seen anything like this before, any help would be appreciated. Thanks.
I was perplexed by this so I created a brand new report linking to the same source with the same ODBC connection, the result was the same. Initially there was just one record missing, then my user created another record in the source database that was immediately visible in the view but did not show up on the report after refreshing the data.
I tried logging off and logging back onto the server, resetting the datasource location back to the same datatsource, getting out and then back into Notes and Crystal, rebooting, all with no change in the result. I had a Notes admin examine the properties of the view and of each specific record that doesn't appear on the report, he couldn't see any reason why they wouldn't appear.
I have been working with Crystal for over 10 years and I've never seen anything like this before, any help would be appreciated. Thanks.