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.
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only