i use crytal report with vb 2008

i make a dataset with 3 field: id (number), name (strng), salary (double) and i have 2 record:

1: id: 1, name: abc, salary: 1,000,0000
2: id: 2, name: def, salary: 2,000,0000

next, i make report on dataset and when show is true but when i have sum salary fied it have error.

1: id: 1, name: abc, salary: 1,000,0000
2: id: 2, name: def, salary: 2,000,0000

sumary: 2 <<< but i want: 3,000,000

i use Running Total Field to sum (salary) but it not sum and it COUND, pls help me to solve. TKS

Recommended Answers

All 2 Replies

>i use Running Total Field to sum (salary) but it not sum and it COUND, pls help me to solve. TKS

You need to change "Type of Summary" value. Choose sum (where this field must be numeric).

i changed Type of Summary is SUM and when i show report it still 2 (mean report still use COUNT for total salary)

i sure about
- salary field is number.
- type of Summary is SUM


what can i do?

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.