Wrox Programmer Forums
Go Back   Wrox Programmer Forums > .NET > Other .NET > Crystal Reports
| Search | Today's Posts | Mark Forums Read
Crystal Reports General discussion about Crystal Reports. For discussions specific to the book Professional Crystal Reports for VS.NET, please see the book discussion forum for that book.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Crystal Reports section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old May 6th, 2004, 08:19 PM
Registered User
 
Join Date: May 2004
Location: , , Philippines.
Posts: 8
Thanks: 0
Thanked 0 Times in 0 Posts
Default Running Total Fields per Group

I'm having a problem for getting the result in Running Total Fields if

I include it in a group.

Example Data:

Code:=====Amount:=====Year:
=A========100========1998
=A========200========1999
=B========400========1998
=A========300========2000
=B========400========1999
=B========400========2001

Result in crystal report should be:

[u]Group [per Year]:</u>
[u]in 1998</u>
Code:=====Amount:=====Running Total Fields of Amount:
=A=========100========100
=B=========400========400 - (Note: should reset to zero on change of new code then get the Amount of that code)

[u]in 1999</u>
Code:=====Amount:=====Running Total Fields of Amount:
=A=========200========300 - (Note: The result is added from 1998 of Code A + the Amount of this Code)
=B=========400========800 - (Note: The result is added from 1998 of Code B + the Amount of this Code)


[u]in 2000</u>
Code:=====Amount:=====Running Total Fields of Amount:
=A=========300========600 - (Note: The result is added from Total Fields in 1999 of Code A + the Amount of this Code)


[u]in 2001</u>
Code:=====Amount:=====Running Total Fields of Amount:
=B=========400========1200 - (Note: The result is added from the Total Fields in 1999 of Code B + the Amount of this Code)

Is it right to have a running total fields or make a formula?

I'm not having a headache if i didn't include it in a yearly group. Coz the running total fields added all the Amounts in each group and reset everytime new codes read from the data. But I need to have a yearly report?

Please I'd like to have a solution for this, tnx.





Similar Threads
Thread Thread Starter Forum Replies Last Post
Crystal Reports Group Total evman Crystal Reports 0 July 19th, 2005 03:00 PM
Group total in a report tsimsha Classic ASP Databases 1 February 28th, 2005 05:40 PM
Supress record when running total in group meets c ldejesuspr Crystal Reports 1 July 28th, 2004 11:10 PM
Running Total Fields edramail Crystal Reports 0 May 17th, 2004 09:22 PM
Running Total on group header scamp Crystal Reports 0 May 3rd, 2004 06:18 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.