Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Group report by 2
Message
 
To
25/06/2004 03:54:54
General information
Forum:
Visual FoxPro
Category:
Reports & Report designer
Miscellaneous
Thread ID:
00917115
Message ID:
00917118
Views:
11
You can add an additional field & group the records by it.
CREATE CURSOR Test (f1 C(10), f2 N(3), GrpFld I)
_grp_ = 0
FOR i = 1 TO 50
    INSERT INTO Test (f1, f2, GrpFld) VALUES (STR(i), i, _grp_)
    IF ROUND(i%2,5) == ROUND(0,5) && To avoid the 0.000000000000000000000011 error :o))
       _grp_ = _grp_ + 1
    ENDIF
ENDFOR
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.
Previous
Reply
Map
View

Click here to load this message in the networking platform