Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
How to create this kind report?
Message
 
 
À
21/04/2002 05:07:24
Michale Chen
Shijiazhuang ZhiYuan Crop.
Shijiazhuang, Chine
Information générale
Forum:
Visual FoxPro
Catégorie:
Gestionnaire de rapports & Rapports
Divers
Thread ID:
00647311
Message ID:
00647421
Vues:
12
This message has been marked as the solution to the initial question of the thread.
>Hello everyone:
>I want to creat a report which only have two field named 'name' and 'number',and the report must have three column,And the summary band have many lables which is used for sign.
< snip >

You can preprocess report cursor and put three groups of the 'Name' and 'Number' fileds into one record. This way you can use one column report and setup Summary band the way you want.
* Existing report cursor - CrsReport
* Name C(20), Number N(10,2)
* New report cursor 
CREATE CURSOR CrsReportNew ( ;
	Name1 C(20), Number1 N(10,2), ;
	Name2 C(20), Number2 N(10,2), ;
	Name3 C(20), Number3 N(10,2))
Select CrsReport
SCAN
	lnPos = ( (Recno()-1) % 3 ) + 1
	lcPos = Transform(lnPos)
	Select CrsReportNew 
	IF lnPos = 1
		APPEND BLANK 
	ENDIF	
	REPLACE ("Name" + lcPos) WITH CrsReport.Name, ;
			("Number" + lcPos) WITH CrsReport.Number
ENDSCAN
--sb--
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform