Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to create this kind report?
Message
 
 
To
21/04/2002 05:07:24
Michale Chen
Shijiazhuang ZhiYuan Crop.
Shijiazhuang, China
General information
Forum:
Visual FoxPro
Category:
Reports & Report designer
Miscellaneous
Thread ID:
00647311
Message ID:
00647421
Views:
11
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--
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform