I haven't tried it myself, but there was a product mentioned in another thread which is supposed to make multiple detail bands possible, among other enhancements. It's called GenRepoX, and can be downloaded from
http://www.eps-software.com/isapi/eps.dll?Products .
hth!
>Since the report designer only allows one detail band you need to format your cursor in this way. You might need to even create a dummy field so that tableA records come before the combined tableb+tablec records.
>
>>I am trying to create a report using 3 non-related tables.
>>
>>I'd like to have the following format but I can't find the way of doing it.
>>
>>RECORDS FROM TABLE A
>>RECORDS FROM TABLE A
>>RECORDS FROM TABLE A
>>RECORDS FROM TABLE A
>>RECORDS FROM TABLE A
>>
>>RECORDS FROM TABLE B RECORDS FROM TABLE C
>>RECORDS FROM TABLE B RECORDS FROM TABLE C
>>RECORDS FROM TABLE B RECORDS FROM TABLE C
>>RECORDS FROM TABLE B RECORDS FROM TABLE C
>>RECORDS FROM TABLE B RECORDS FROM TABLE C
>>
>>Is there a way of doing this using the Report Designer?
>>Any comments or suggestions are welcome. Thank you in advance.
Bridget K. Dawes