Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Two reports in one.
Message
De
11/07/2003 09:35:12
Cetin Basoz
Engineerica Inc.
Izmir, Turquie
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Gestionnaire de rapports & Rapports
Divers
Thread ID:
00809174
Message ID:
00809184
Vues:
22
>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
Çetin Basöz

The way to Go
Flutter - For mobile, web and desktop.
World's most advanced open source relational database.
.Net for foxheads - Blog (main)
FoxSharp - Blog (mirror)
Welcome to FoxyClasses

LinqPad - C#,VB,F#,SQL,eSQL ... scratchpad
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform