Crystal Reports shows data that is not seen in Notes db 1

[danhauer]

This one has been a real stumper... I'm also posting it in the Crystal Reports forum. I created a report using CR against a Notes database. The selection is based on all documents created using "frm_pppinput". There are two (maybe more that I don't know about!) documents appearing in the report that cannot be seen anywhere in the Notes database. I even created a new blank view selecting all documents and I cannot find these two particular documents. I verified that CR is pointing to the same database, same server, there are no aliases for the form name, etc. I am totally out of ideas. Any thoughts on this would certainly be appreciated!

Thank you!

danhauer

 

[pmonett]

Are you sure you have access to all the documents in the database ?
I ask because I once discovered that normal users editing a document have the right to include Reader rights on the document (incredible, no ?). The manipulation itself requires a good knowledge of Notes, but it is in no way reserved for experts.
Since that time, I have taken the habit of actually including code in sensitive databases that controls the existence of read restrictions and their validity.
Now, this may have nothing to do with you, but you do not state what level of access you have to the database, or if there are roles that you do not have.
If some documents are hidden, under certain circumstances and without your knowledge, then you will not be able to completely control the accuracy of the reports.
One thing is for sure, I do not think Crystal Reports invents data. So that data has to be somewhere, and you probably do not have normal access to it.
Check the ACL and the design to see if there are hidden views. If yes, you need to find out what they display, and why.

Pascal.

 

[danhauer]

Thanks for the information! Yes, I checked the ACL and even made a local copy giving myself manager rights. I did not know users could include reader rights on a document! Very nice to know.

I totally agree that CR can't invent data - but convincing certain database owners of that has proved challenging.

I think I might have found the problem - orphaned documents. When I created a view unchecking the 'show response documents in a hierarchy' box - I saw replication/save conflicts that were unseen before. Lo and behold, the very documents I was looking for were among them.

Happy programming,

danhauer