>Can I use two different cursors with all different fields in the same report. I need to list first all records of cursor 1 , then all records of cursor 2 and then the summary band with a total field. Thanks.
Yes it's doable in a few ways. Easiest one IMHO :
- Create a dummy cursor joining both and use that on report.
select * from customer ;
full join orders ;
on customer.cust_id = orders.order_id
Cetin