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!
Showing posts with label print. Show all posts
Showing posts with label print. Show all posts
Monday, March 26, 2012
Thursday, March 22, 2012
Duplex printing SRS 2000
Is it possible to set a printer to duplex within SQL Reporting Service 2000?
I have several reports to print and need to switch back and forth between
duplex (Front and Back) and one sided printing.
TIABump
"bhughes" wrote:
> Is it possible to set a printer to duplex within SQL Reporting Service 2000?
> I have several reports to print and need to switch back and forth between
> duplex (Front and Back) and one sided printing.
> TIA
>
>|||I guess no one else has been able to do this either. Time to start looking
for a new report writer.
"bhughes" wrote:
> Is it possible to set a printer to duplex within SQL Reporting Service 2000?
> I have several reports to print and need to switch back and forth between
> duplex (Front and Back) and one sided printing.
> TIA
>
>sql
I have several reports to print and need to switch back and forth between
duplex (Front and Back) and one sided printing.
TIABump
"bhughes" wrote:
> Is it possible to set a printer to duplex within SQL Reporting Service 2000?
> I have several reports to print and need to switch back and forth between
> duplex (Front and Back) and one sided printing.
> TIA
>
>|||I guess no one else has been able to do this either. Time to start looking
for a new report writer.
"bhughes" wrote:
> Is it possible to set a printer to duplex within SQL Reporting Service 2000?
> I have several reports to print and need to switch back and forth between
> duplex (Front and Back) and one sided printing.
> TIA
>
>sql
Subscribe to:
Posts (Atom)