Information générale
Catégorie:
Gestionnaire de rapports & Rapports
Titre:
Funny result with data grouping
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
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement