Topic Options
#971 - 03/16/01 06:09 AM QR Running Totals
Anonymous
Unregistered


How does one reset a running total after a subtotal?

I'm trying to write a statement-like report with a running balance for each account but haven't been able to reset the running total to zero after each customer.

Hope someone can help.


Top
#972 - 03/17/01 02:39 AM Re: QR Running Totals
Softrak Support Offline

Adagio Action Team

Registered: 03/09/99
Posts: 11532
Loc: Vancouver, BC Canada
Hello MPC,

If you are using Quik Reports for DOS, there is no way to reset the running total on change of Customer number (or any other field). The reporting structure cannot create results for a detail based on information in a previous or next record.

If you are using Quik Reports for Windows, this is fairly easy to do, using Variables. You can do this by creating 2 formulas, one to initialize/reset the variable in the Group Header (ie for each customer), and the other in the detail section to accumulate an output the value of the variable.

Regards,
Softrak Support


Top
#973 - 03/17/01 12:44 AM Re: QR Running Totals
Anonymous
Unregistered


quote:
Originally posted by Softrak Support:
Hello MPC,

If you are using Quik Reports for DOS, there is no way to reset the running total on change of Customer number (or any other field). The reporting structure cannot create results for a detail based on information in a previous or next record.

If you are using Quik Reports for Windows, this is fairly easy to do, using Variables. You can do this by creating 2 formulas, one to initialize/reset the variable in the Group Header (ie for each customer), and the other in the detail section to accumulate an output the value of the variable.

Regards,
Softrak Support


Alas I am using QR for DOS


Top


Moderator:  Christa_Meissner 
Who's Online
0 registered (), 82 Guests and 0 Spiders online.
Key: Admin, Global Mod, Mod
Forum Stats
1865 Members
5 Forums
14459 Topics
70635 Posts

Max Online: 432 @ 01/20/25 10:17 PM
April
Su M Tu W Th F Sa
1 2 3 4 5
6 7 8 9 10 11 12
13 14 15 16 17 18 19
20 21 22 23 24 25 26
27 28 29 30