Crystal Reports 8.0
Accessing a Peachtree Accounting Database
I have a primary report that selects cash receipts records and shows the Invoice Number in that record only if that invoice has been paid. It is grouped by invoice number.
I have a subreport that accesses the invoice line item records for all invoices, paid or unpaid. I am using this subreport to calculate royalties on paid invoices.
The link parameter is the invoice number. In other words, if the records match, I have found a paid invoice and can calculate the royalty.
When I run the report it picks up the records haphazardly. That is, it returns the invoice line item records for a while, then stops, then picks up again. Thus, the main report picks up some of the records and displays them with the calculated royalty. Other times, the subreport portion in the main report is blank for certain invoice numbers, even though I know they have been paid. A blank subreport section in the main reports means there is no match.
But the PAID invoice line item records are there. Interestingly enough, if I run the report selecting an INDIVIDUAL invoice number NOT RETURNED, it is picked up correctly and the royalty is calculated. Therefore, somehow or other, something else is going wrong.
Accessing a Peachtree Accounting Database
I have a primary report that selects cash receipts records and shows the Invoice Number in that record only if that invoice has been paid. It is grouped by invoice number.
I have a subreport that accesses the invoice line item records for all invoices, paid or unpaid. I am using this subreport to calculate royalties on paid invoices.
The link parameter is the invoice number. In other words, if the records match, I have found a paid invoice and can calculate the royalty.
When I run the report it picks up the records haphazardly. That is, it returns the invoice line item records for a while, then stops, then picks up again. Thus, the main report picks up some of the records and displays them with the calculated royalty. Other times, the subreport portion in the main report is blank for certain invoice numbers, even though I know they have been paid. A blank subreport section in the main reports means there is no match.
But the PAID invoice line item records are there. Interestingly enough, if I run the report selecting an INDIVIDUAL invoice number NOT RETURNED, it is picked up correctly and the royalty is calculated. Therefore, somehow or other, something else is going wrong.