At 11:55 PM 8/11/2005, Warren Glass wrote:
... I want to use a sub-report to list in the main report header the rows of data that make up the total donated to him. The data comes from the same table. I just have not been able to get the sub-report to do the needed selection using the DonorID which is a column value used for lookups in the main report header.
Warren, You can certainly achieve that goal by placing a "DB Calc" Control with the "LookAhead" option set to true. Take a look at the sample "CustContInvoices" report included with the Running R:BASE Your Way! (Part 10). Database: RRBYW10 Report/Sub-Report: CustContInvoices Associated Tables/Views : . NewCustomer . NewInvoiceHeader . NewInvoiceDetails . NewContact Hope that helps! Very Best R:egards, Razzak.
