>Hello Everybody !
>
>report generator for beginners ????
>
>I have two cursors as resultsets from two different sql-select commands !
>(two different databases on different servers)
>simpified example
>
>cursor a:
>custno, custname, ..., contactno, contactname
>
>cursor b:
>custno, custname,... , orderno, ordername
>
>i want to produce a report witch looks like this:
>
>top of page:
>custno custname .........
>
>detail:
>all contacts:
>contactno, contactname
>contactno, contactname
>contactno, contactname
>contactno, contactname
>contactno, contactname
>contactno, contactname
>
>all orders:
>orderno, ordername
>orderno, ordername
>orderno, ordername
>orderno, ordername
>orderno, ordername
>
>end of report:
>6 contacts
>5 orders
>
>
>i don't know how to programm this detail part ??
>
>first all records from cursor a
>then all records from cursor b
>
>Any help welcomed
>Best regards
>Albert
create cursor reportCursor (rcno i,tableNo i)
select recno() as rcno,1 from cursorA into cursor crsTemp nofilter
append from dbf('crsTemp')
select recno() as rcno,2 from cursorB into cursor crsTemp nofilter
append from dbf('crsTemp')
set relation to rcno into cursorA, rcno into cursorB
report form ... && use print when in report
Cetin