Change your select to create separate records for each detail group

SELECT "1" AS RecType, com_no, con as disptext FROM conviction ;
UNION ALL ;	
SELECT "2" AS RecType, com_no, lid as disptext FROM lid ;
UNION ALL ;	
SELECT "3" AS RecType, com_no, sub as disptext FROM sub ;
ORDER BY 2, 1 ;
INTO CURSOR crsReport

After that follow instructions from Re: 2 reports as one Message #685781.

>hi
> I come across problem when I make the report, I have create a cursor by using this SQL
>
>select conviction.*, lid.*, subcase.* from conviction,lid,subcase where;
> conviction.com_no=subcase.com_no and subcase.com_no=lid.com_no into cursor temp
>
>the cursor look something like this
>

com_no_a   con    com_no_b   lid    com_no_c   sub
> 0051       a       0051      c       0051      e
> 0051       b       0051      c       0051      e
> 0051       a       0051      d       0051      e
> 0051       b       0051      d       0051      f
> 0051       a       0051      c       0051      f
> 0051       b       0051      c       0051      f

>the problem is when I pass the cursor to my report, I dont know how to group the data,
>I am trying to group them in three so that the user can read the report like this
>

>conviction
>   a
>   b
>LIB
>   c
>   d
>subcase
>   e
>   f

>I have tried to use the varible con, lid and sub but it only works for sub but not the other two..how can I solve the problem. which tool I should use in VFP...thanx