C# – Using SUM in an RDLC report on decimal gives weird result

crdlc

I'm trying to generate an RDLC report where one column, Amount, is going to have a "Total" row at the bottom. This isn't weird stuff, it's a very basic RDLC report, but instead of getting the normal "Total" value at the bottom I get something else, allow me to demonstrate:

enter image description here

It shouldn't say 97,140.00, it should say 971,40 so I'm a bit confused. The column is summarized like this:

=Sum(CDec(Fields!Amount.Value))

I have to convert it first for some reason otherwise I get an #Error instead of the wrong number. This is weird as well as the model property is a decimal and the DataTable property I'm using is a decimal.

My only guess is that it has something to do with me being swedish and using comma as decimal separator instead of a period.

Best Answer

The problem is obviously in CDec function. If you are sure that there is no other way for not using CDec try this: CDec(Sum(Fields!Oil_Gas.Value)) or this: FormatNumber(CDec(Sum(Fields!Oil_Gas.Value)),2) or this: FormatNumber(Sum(Fields!Oil_Gas.Value),2)

I couldn't really reproduce your problem but all mentioned solutions works for me.

Related Solutions

Multi Column RDLC report, with the data flowing from Left to Right instead of Top to Bottom

Chris Hays (on the Reporting Services team) has a blog entry about this very thing. It may be of help:

http://blogs.msdn.com/chrishays/archive/2004/07/23/HorizontalTables.aspx

Scala: list.flatten: no implicit argument matching parameter type (Any) = > Iterable[Any] was found

If you are expecting to be able to "flatten" List(1, 2, List(3,4), 5) into List(1, 2, 3, 4, 5), then you need something like:

implicit def any2iterable[A](a: A) : Iterable[A] = Some(a)

Along with:

val list: List[Iterable[Int]] = List(1, 2, List(3,4), 5) // providing type of list 
                                                         // causes implicit 
                                                         // conversion to be invoked

println(list.flatten( itr => itr )) // List(1, 2, 3, 4, 5)

EDIT: the following was in my original answer until the OP clarified his question in a comment on Mitch's answer

What are you expecting to happen when you flatten a List[Int]? Are you expecting the function to sum the Ints in the List? If so, you should be looking at the new aggegation functions in 2.8.x:

val list = List(1, 2, 3)
println( list.sum ) //6

Best Answer

Related Solutions

Multi Column RDLC report, with the data flowing from Left to Right instead of Top to Bottom

Scala: list.flatten: no implicit argument matching parameter type (Any) = > Iterable[Any] was found

Related Topic