General information
Category:
Reports & Report designer
Title:
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
------------------------------------------------------------
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only