CODEWITHSUNDEEP
asp.netms-accessreportingrdlc
user996502
user996502

Reputation: 307

RDLC Report Service giving error when sum column

I'm using a Access Database to pull Data and displaying using Report

In my table theirs a Column holding Commission data however every time I add

=Sum(Fields!Commission.Value) in a empty Cell to display the Sum value I get a Error.

Upvotes: 2

Views: 3038

Answers (3)

I A Khan
I A Khan

Reputation: 8869

try this:

=Sum(int(Fields!Commission.Value))

may be you are using string so first convert it into int

Upvotes: 4

confusedMind
confusedMind

Reputation: 2653

Maker sure the field is Int and not String if so convert it to integer to sum.

Upvotes: 1

Mayank Pathak
Mayank Pathak

Reputation: 3681

Sum() in SSRS requires two fields to sum up and there must be an = sign before your function..like this

=Sum(Fields!Commission.Value)

Upvotes: 1

Related Questions