I am trying to convert from a varchar to numeric format using the "Expression" in Visual Studio.
This seems to change the format of the numbers shown, however, when I try to "Sum" the column, I get this error message:
Warning [[rsAggregateOfNonNumericData] The Value expression for the textrun ‘wo_udf81.Paragraphs.TextRuns’ uses a numeric aggregate function on data that is not numeric. Numeric aggregate functions (Sum, Avg, StDev, Var, StDevP, and VarP) can only aggregate numeric data. C:UserstonyhDocumentsRS ReportsMyReportsMyReportsORD1.rdl 0 0
I am very new to SSRS and have tried using the various functions with no luck. Can anyone please help. Very important report for me to create at this point.
SQLServer 2008 R2, Reporting Services Addon
May 14, 2013 3:25 PM
May 14, 2013 3:27 PM