Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Report Data Grouping Problem
Message
From
05/08/2007 23:54:25
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Reports & Report designer
Title:
Report Data Grouping Problem
Environment versions
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Network:
Windows XP
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01246076
Message ID:
01246076
Views:
72
Dear Experts

Table1 has four fields as

group n(2)
sno n(4)
country c(20)
amount n(5)

Data in fields is as

group--sno---country--amount
--11---1101--India-------500
--11---1102--Iran--------400
--12---1203--England--200
--22---2207--Japan-----300
--25---2510--Egypt-----100
--26---2615--China-----700
--32---3202--Russia---800

I want to make Data groups based on every Unique First Digit of group field as

according to above data THREE data group are made as
First Group=1
Second Group=2
Third Group=3

How to make data groups?
What should I write in Group Expression and Print When columns

I need following output

group--sno---country--amount
--11---1101--India-------500
--11---1102--Iran--------400
--12---1203--England--200
amount sub total 1100
--22---2207--Japan-----300
--25---2510--Egypt-----200
--26---2615--China-----700
amount sub total 1200
--32---3202--Russia---800
amount sub total 800

Please help
Next
Reply
Map
View

Click here to load this message in the networking platform