>Hi.
>I'm developing a payroll system where the input is the number of hours (dayly, nightly, normal, extras) a person has worked each day.
>Is it possible to create a report with all the concepts generated and draw a table with the detail?, I mean, this would be like two report in one.
>
>Thank in advance for your replys..

select cust_id, Company, .t. as 't1' ;
	 from customer ;
	 where cust_id = 'B' ;
	 into cursor tablo1 nofilter
afields(arrT1) && Structure'i sakla

select order_id, emp_id, order_date, order_net, .t. as 't2' from orders ;
	where cust_id = 'C' and order_date < {^1994/07/01} ;
	order by cust_id, order_date ;
	into cursor tablo2 nofilter
afields(arrT2) && Structure'i sakla

select emp_id as 'employeeId', first_name, last_name, .t. as 't3' ;
	from employee ;
	into cursor tablo3 nofilter
afields(arrT3) && Structure'i sakla

dimension arrNewStruc[alen(arrT1,1)+alen(arrT2,1)+alen(arrT3,1), alen(arrT1,2)]
acopy(arrT1,arrNewStruc,1,-1,1)
acopy(arrT2,arrNewStruc,1,-1,alen(arrT1)+1)
acopy(arrT3,arrNewStruc,1,-1,alen(arrT1)+alen(arrT2)+1)

create cursor myCursor from array arrNewStruc
append from dbf('tablo1')
append from dbf('tablo2')
append from dbf('tablo3')
browse && Nasil gorundugunu kontrol et

*create report multidetail from (alias()) form
modi report multidetail

For fields coming from different tables set 'print when' to t1, t2 or t3 respectively.
Cetin