Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Funny result with data grouping
Message
From
07/05/2009 18:26:26
Hee Lim Wang
Fantasy Software Enterprise
Malaysia
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Reports & Report designer
Title:
Funny result with data grouping
Miscellaneous
Thread ID:
01398470
Message ID:
01398470
Views:
130
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
Map
View

Click here to load this message in the networking platform