>If I combine records in one cursor then how to design report to print one record in first half of paper and the other on second half of paper?
>
>You can look the pattern an attachment which i need.
In such cases, I added an additional field to the combined table, which I called "Origin" (i.e., "where do the data come from"). In the report, create a group on this field.
Adapting Naomi's commands:
select "1" as origin, * from Table1 ;
UNION ALL ;
select "2" as origin, * from Table2 ;
ORDER BY 1, 2 ;
into cursor csrReport NOFILTER
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)