Click here to Skip to main content
13,768,110 members
Rate this:
 
Please Sign up or sign in to vote.
See more:
hi
i have some problem while getting the sum of the field. i want to get the sum of one filed for example sum of the values which in Debit Field. but i want to get this sum according to another field called period. means for that respective period value i want the sum of the Debit field in crystal report. and im using a dataset.in this dataset there s both the fields

here, i know how to get the sum of the debit field by adding the Formula field. but i don't know how to take it according to value in my period field.

can someone help me with this.

thanks
Posted 10-Dec-09 23:44pm

1 solution

Rate this: bad
 
good
Please Sign up or sign in to vote.

Solution 1

There are two ways you can do this.

  1. The easiest way is to group your report by the period and then put the sum field in the group footer.
  2. The other way would be to have a running total field which sums the debit field when the period is a specific value. Only problem with this is you would need to do a running total for each period you want a value for.
  Permalink  

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
Top Experts
Last 24hrsThis month


Advertise | Privacy | Cookies | Terms of Service
Web01-2016 | 2.8.181116.1 | Last Updated 14 Jan 2010
Copyright © CodeProject, 1999-2018
All Rights Reserved.
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100