Summing

[kss444]

I am trying to do a simple sum of an amount column, but I can't seem to get it.

In my query the fully qualified field name is mc.INVTAX.TaxAmount_amt and I alias this with "as 'Tax Amount'
In ssrs I have a textbox that I want to create an expresion for the SUM.
And I have =Sum(Fields!Tax_Amount.Value, "RefundClaim_DataSet")
But I get a red line under Fields!Tax_Amount.Value, and when I run the report it just shows #ERROR.

Can someone help me out,
Thanks.
KSS

Ordinary Programmer

 

[kss444]

My detail results are in a table, but i've also noticed that the cells are not keeping my format. My amounts fields are resetting to text. Not sure why.

Ordinary Programmer

 

[kss444]

I figured it out.

Ordinary Programmer