Thanks Nick. I'm working trying your idea now.
Thanks a million
Elgin
>>I am trying to layout a report that is based on a one-to-many relationship. However the child records will be made up of two tables and I want to print the last 10 records from the child tables in each their own group. In other words:
>>
>> PARENT RECORD (1)
>>
>> Child Records Table 1 (Last 10 Records)
>>
>> Child Records Table 2 (Last 10 Records)
>>
>>I'm not planning on defining a dataenvironment for this report, rather using a SELECT statement in my button code.
>>
>>How do you define multiple Detail bands? Or can you? After this report I have another one to design that will involve 5 child tables.
>>
>>Any suggestions?
>>
>>Thanks
>>Elgin
>
>Elgin, there is no native way to define multiple Detail Band, but you can easily achieve it by creating a report cursor which contains the necessary records and an extra field (say, containing 1 for Child Records Table 1, and 2 for Child Records Table 2). Report cursor should be ordered by this field (easy to do with SQL SELECT and ORDER BY). Then in the Report Designer you use Grouping and Print When accordingly.