I have a VB application with about 75 installations that uses the Crystal Control (Version 7.0) to print Crystal RPTs. On about 7 of these installations the clients are getting duplicate lines (usually on the last page or a single page report).
1) Using the same data (and reports) we cannot create this problem on any workstations execpt the 7 workstations that have the problem.
2) We do not think it a data problem, since we can clearly see in the [access] DB that there a 6 records, while the Crystal Report is clearly displaying 7 lines.
3) The report has 3 groups and the buplicates are with the detail records.
4) I have tried suppresion in the Section with
Whileprinting records;
previous(RecordId) = recordId
QUestions;
A) Are there any known resource requirements (Available Physical Memory/Available Virtual Memory/Page File SIze) limitaions anyone know of?
B) Any other ways in Crystal to attempt to resolve the problem?
C) ANY general suggestions, comments, or ideas?
ThanksDon't know why it's only on some clients, but what other tables is Crystal using? Try running Crystal's SQL on the DB to see if there's a join issue.
If a recordID really should be unique in the report then group on it and display in the group header/footer instead of the details section. This'll fix the symptom of any duplicate IDs, if not the cause of them.|||I have checking the links and am fairly confident this is not the cause, but it is worth another look. However, I will try the grouping suggetion; it sounds promising. THANKS!
No comments:
Post a Comment