Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Totals on top of group
Message
From
28/06/2007 19:21:26
Hilmar Zonneveld
Independent Consultant
Cochabamba, Bolivia
 
 
To
28/06/2007 19:13:22
Victor Chigne
Inteliventas
Peru
General information
Forum:
Visual FoxPro
Category:
Reports & Report designer
Environment versions
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Network:
Windows 2000 Server
Database:
MS SQL Server
Miscellaneous
Thread ID:
01236632
Message ID:
01236634
Views:
17
>Hello.
>
>How can I display the totals of a group above it instead of below?
>
>Regards
>
>VCT

One way would be to prepare the data beforehand; for example:
  • Get totals from your cursor, with a GROUP BY, into a second cursor.
  • Join this back with the original cursor. This will get you totals in each record; that will make it available in the group header.
    Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)
  • Previous
    Next
    Reply
    Map
    View

    Click here to load this message in the networking platform