Notes with crystal report

[911]

hi
Q1: i am trying to simulate a relationnal database in notes using 2 views, so when i link these views by a common key it takes forever to load the report.
nb: i have about 1200 document in my view.

Q2: why response documents taken from a view do not appear in a report?

thank u.

 

[Mammoth]

Q1.How long of a wait are we talking? Crystal is slow! Also, are you using Crystal's native notes driver or are you using the NotesSQL driver? I have found that the native notes driver causes my system to crash when I try to pull data from a form.

Q2. When you say "response documents" don't show up in report, are you reffering to the fact that they don't show up as a available table or that they don't appear in the printed report?

 

[911]

Q1. last time i run my report it just freezes, i have try it for many times. i am using notesSQL 3.0. besides my views are sorted by first column(key) and have the for "ODBC Access " option Checked.

Q2. they do not appear in the printed report.

NB: the number of documents is 5000 for each view => total of 10 000 documents.
thanks

 

[Mammoth]

Q1. When you say it freezes, does the whole computer quit responding or is it just Crystal?

Q2.Are you linking multiple tables? If so, try reversing the link, and also make sure you are linking identical fields that are related.

Also, 10,000 documents are alot to sort through especially if you are using selection formula's