Click here to Skip to main content
15,936,119 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
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

1 solution

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.
 
Share this answer
 

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



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900