Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Report Data Grouping Problem
Message
De
05/08/2007 23:54:25
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Gestionnaire de rapports & Rapports
Titre:
Report Data Grouping Problem
Versions des environnements
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Network:
Windows XP
Database:
Visual FoxPro
Divers
Thread ID:
01246076
Message ID:
01246076
Vues:
73
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
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform