Click here to Skip to main content
14,333,124 members
Rate this:
Please Sign up or sign in to vote.
hello everybody !
i cracked with Crystal Report nowadays :)
i have such an interesting problem again which is i want to count the total content of a fild in database. bellow is a picture, have a look. you find out what i mean . i dont want the total of records. i just want the tota of content of that filed. for example consider field "ps_dollar" :

ps_dollar
12,13
14,21
15,22
32,02
34,45


what i want is to somehow find the total of these number which makes 108,03
.but when i use SUM(), i obtain the total of records which makes 5 record. can anybody please inform me how to solve this problem , thanks for help and thanks your support

http://i54.tinypic.com/66j910.png[^]
Posted
Updated 7-Mar-11 6:49am
v2
Rate this:
Please Sign up or sign in to vote.

Solution 1

Have a look at this very good article: Step by Step Creation of Crystal Report using its Features Group, Graph, Cross-Tab and Sub Report[^]

Either, it would be a running summary or a grouped one. Look which one fits in for you and implement it.

For grouping, it's already there in article. For running summary:
1. right click on report click Insert->Summary
2. select the field you want to sum

If it's too complex, use formula fields.
   
Rate this:
Please Sign up or sign in to vote.

Solution 2

   

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




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