Running Total in Report Builder


(system) #1
Haven't done one in awhile but thought it was pretty much just reporting at any lower level than the reset level on the aggregate. So for instance aggregating sales Order total $ and re-setting at Customer but reporting the total along the way on each Sales Order line. For a subtract then use a calculated field with a base total and subtract the running total from it and report that at that level which is below the reset level.

-Todd C.

-----Original Message-----
From: Juliet Martin [mailto:jmartin@...]
Sent: Tuesday, April 05, 2005 3:38 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Running Total in Report Builder


I have never had to do this. I need to subtract down a list. Can give me a heads start?

Thanks

Juliet Martin
Information Manager
Rosenboom Machine & Tool, Inc.
Sheldon, IA 51201
712-324-4854 x1217



Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and Crystal Reports and other 'goodies', please goto: http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto: http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto: http://groups.yahoo.com/group/vantage/links



_____

Yahoo! Groups Links


* To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/


* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com <mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>


* Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service <http://docs.yahoo.com/info/terms/> .




[Non-text portions of this message have been removed]

(system) #2
Does anyone know who to create a formula in Report Builder that computer
the running total?
I am trying to create a time-phased report for a certain part class from
the PartDtl table.
TIA.


[Non-text portions of this message have been removed]

(system) #3
You should be able to set an aggregate to reset at a higher level (even no-reset) and print it along the way at a lower levels (even at the record level). Running Totals are described in the Report Builder User's Guide starting at 5-21 (version dated Feb 2000). You can download it from the Progress web site.
-Todd C.

-----Original Message-----
From: PLAMAN DICK [mailto:dick.plaman@...]
Sent: Thursday, June 10, 2004 8:43 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Running Total in Report Builder


Does anyone know who to create a formula in Report Builder that computer
the running total?
I am trying to create a time-phased report for a certain part class from
the PartDtl table.
TIA.


[Non-text portions of this message have been removed]



Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and Crystal Reports and other 'goodies', please goto: http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto: http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto: http://groups.yahoo.com/group/vantage/links



Yahoo! Groups Sponsor

ADVERTISEMENT
<http://rd.yahoo.com/SIG=129luv5c9/M=298184.5022502.6152625.3001176/D=groups/S=1705007183:HM/EXP=1086961369/A=2164331/R=0/SIG=11eaelai9/*http://www.netflix.com/Default?mqso=60183351> click here
<http://us.adserver.yahoo.com/l?M=298184.5022502.6152625.3001176/D=groups/S=:HM/A=2164331/rand=279031643>


_____

Yahoo! Groups Links


* To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/


* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com <mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>


* Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service <http://docs.yahoo.com/info/terms/> .




[Non-text portions of this message have been removed]

(system) #4
I have never had to do this. I need to subtract down a list. Can give me a heads start?

Thanks

Juliet Martin
Information Manager
Rosenboom Machine & Tool, Inc.
Sheldon, IA 51201
712-324-4854 x1217