Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Funny result with data grouping
Message
De
07/05/2009 18:26:26
Hee Lim Wang
Fantasy Software Enterprise
Malaisie
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Gestionnaire de rapports & Rapports
Titre:
Funny result with data grouping
Divers
Thread ID:
01398470
Message ID:
01398470
Vues:
131
i wrote some set relation coding shown in below
results are fine in my browse windows
but when i output to report designer with data grouping : code
it gives funny result.....
the first group has all the detail data, why? and how to solve that problem ?

USE code ORDER code
USE detail ORDER code IN 0
SET rela to code into detail
SET SKIP TO detail
BROWSE FIELDS code,desc nowait
SELECT detail
BROWSE FIELDS date,code,ref_no,qty,amount nowait && these ok

*****output with data grouping result

code : FNT/N
desc : FINE WOOD LOCK WITHOUT HANDLE

DATE CODE REF QTY AMOUNT
03/19/09 FNT/N 12345 10 20.50
03/10/09 FNT/N1 12042 5 15.70
02/06/09 FNT/N2 12040 1 19.00
------------------------------------------------------------
code : FNT/N1
desc : FINE WOOD LOCK WITH HANDLE

DATE CODE REF QTY AMOUNT
03/10/09 FNT/N1 12042 5 15.70
------------------------------------------------------------
code : FNT/N2
desc : FINE WOOD LOCK WITH DOUBLE HANDLE

DATE CODE REF QTY AMOUNT
02/06/09 FNT/N2 12040 1 19.00
------------------------------------------------------------
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform