Problem with report creation using Lotus Notes DB

[mjstanton]

Hello - I am using CR 8.5 and a Lotus Domino Notes database. I am using the Native Lotus Notes Driver. Lotus Notes is not a relational database, rather, it is a huge repository of documents. I am trying to create a report using three views (what you would refer to as tables). We are in the recruiting/executive search business. The 3 views/tables I am using are:
1) Job Opening Document
2) Candidate Data Document
3) Interview Schedule Document

The purpose of the report is to list all open jobs, the candidates that have been submitted, and their interview dates and times.

In the database, when a candidate is set up for an interview, the Interview Schedule Document is created. If a second interview is scheduled, a NEW/second Interview Document is created, with another document created for every subsequent interview. So there can be multiple Interview Schedule Documents for any one candidate. I am linking all 3 documents with the Job Opening number. Yet I am only getting ONE Interview Schedule Doc (the most recent one) for each candidate. Why am I not getting all the interview dates/times for candidates who have had multiple interviews??

Thanks in advance for any and all replies!
Marcia

 

[disaacson]

Make sure you are linking from the Interview Schedule Document to the Job and Canidate tables.

 

[mjstanton]

Thanks, I should have clarified that better. I am linking the Job Opening Number to the Candidate Data Doc AND the Interview Schedule Doc. I have another link from the Candidate Data Doc to the Interview Schedule Doc on the Candidate's Name field.

Marcia

 

[disaacson]

We have an internal Lotus database and I know when I have done reports off of views if I don't link from the most detail table (the one with the most entries per the field I am linking off of) then you can get strange results in Crystal.

I would recommend that you either make a view in Lotus that combines all the information together into a single view and then report off of that or in Crystal in the Visual Linking Expert make sure all lines point from the Interview schedule to the Job and Candidate table


a provider of support for MAS90/200 and Crystal Reports