Crystal Reports and Simply Accounting - Sub report issue

Hello,

I am having a problem with Crystal reports 8.5 for Simply Accounting version 2006-D.

We have a custom report that is used for printing cheques. The report is made up from the databases VENCHQ1_CSV (header) and VENCHQ2_CSV (detail). In the stub portion of the cheque, there are two sub reports that run. The first sub report shows the first 12 detail lines from VENCHQ2_CSV and the second sub report shows the next 12. We have cheques with up to 36 detail lines and we need to change the report to have 3 columns side by side that show the first, second and third set of 12 line items.

So far, I have taken the second sub report and saved it as an individual sub report then inserted it as the third column. The result is that the cheque prints out with three columns, but instead of the third column showing the last set of line items, it shows the same line items as in the second column.

Each sub report is grouped on the VENCHQ2_CSV.LINE_COUNT field in ascending mode. I can't figure out how to make the third group continue where the second group finishes.

Does anyone know how I can fix this?

Thanks,

Salar Madadi
- Latest Developments Inc.See answer in other forum - probably a record selection issue.