I am using Crystal Reports 9 and VB6. I created the original report in Crystal then added it to VB6.
The VB6 code opens the report, counts the pages, and exports a CR to a PDF. If there are over 2500 pages to the report, I split the PDF into 2500 page increments. (Example: a report containing 5000 pages would be 2 PDF files). On the first page of each PDF, I want to show the distinct batch number included in that set of 2500 pages of barcodes. I have a Report Header containing a subreport of the distinct batch number in columns. However, when the reports are created I only get the Report Header page in the first PDF and it contains all batch numbers in all three PDF's.
How can I get the report header to show up for each PDF file with only the batch numbers in that particular PDF?
Example of what I would like:
1st PDF File -- pages 1-2500:
Report Header Page:
Packing List - this report contains 12 batch numbers
12345 TT1234
WW333 UT5678
98766 IT4567
09876 PO0987
87654 VF7564
EE345 NH7645
Subsequent pages are the detail pages - 2500 single barcode pages:
Barcode
Batch Number
Voucher Number
Corp Code
2nd Page -- pages 2501-5000:
Report Header Page:
Packing List - this report contains 10 batch numbers
87744 99999
11111 88888
22222 55555
66666 33333
11122 12121
Subsequent pages are the detail pages - 2500 single barcode pages:
Barcode
Batch Number
Voucher Number
Corp Code
Any suggestions or help would be appreciated!
Leslie
The VB6 code opens the report, counts the pages, and exports a CR to a PDF. If there are over 2500 pages to the report, I split the PDF into 2500 page increments. (Example: a report containing 5000 pages would be 2 PDF files). On the first page of each PDF, I want to show the distinct batch number included in that set of 2500 pages of barcodes. I have a Report Header containing a subreport of the distinct batch number in columns. However, when the reports are created I only get the Report Header page in the first PDF and it contains all batch numbers in all three PDF's.
How can I get the report header to show up for each PDF file with only the batch numbers in that particular PDF?
Example of what I would like:
1st PDF File -- pages 1-2500:
Report Header Page:
Packing List - this report contains 12 batch numbers
12345 TT1234
WW333 UT5678
98766 IT4567
09876 PO0987
87654 VF7564
EE345 NH7645
Subsequent pages are the detail pages - 2500 single barcode pages:
Barcode
Batch Number
Voucher Number
Corp Code
2nd Page -- pages 2501-5000:
Report Header Page:
Packing List - this report contains 10 batch numbers
87744 99999
11111 88888
22222 55555
66666 33333
11122 12121
Subsequent pages are the detail pages - 2500 single barcode pages:
Barcode
Batch Number
Voucher Number
Corp Code
Any suggestions or help would be appreciated!
Leslie