Member Avatar for c4ytr3

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

  • 2 Contributors
  • 2 Replies
  • 71 Views
  • 6 Hours Discussion Span
  • Latest Post Latest Post by c4ytr3
Member Avatar for kvprajapati

>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).

Member Avatar for c4ytr3

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?

Edited by c4ytr3 because: n/a
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.