>Hi Cetin
>
>If you have more than one table it will only show the fields of the one active
>
>use Table1 in 0 order tag Table1
>use Table2 in 0 order tag Table2
>set relation to account into table1
>
>Create report from alias() form
>
>It will only show the fields of table2, I need the fields of all the tables in the Data Session
>
>Eduardo
Eduardo,
That's not the way I use it. I do it like this (regarding above situation) :
select * from table2 ;
inner join table1 ;
on table1.account = table2.account ;
into cursor tcReport ;
where .t.
create report myReport from alias() form
modi report myReport
Cetin