Error on aggregate function in non numeric value

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2008 Forums

Analysis Server and Reporting Services (2008)

Error on aggregate function in non numeric value

Author

Topic

Ciupaz
Posting Yak Master

232 Posts

Posted - 2013-09-10 : 09:00:54

Hello all,
in a report that gets data from a Web Service,
when I switch to preview tab in my BIDS (VS 2008),
I got this error:

Warning 1 [rsAggregateOfNonNumericData] The Value expression for the textrun ‘textbox156.Paragraphs[0].TextRuns[0]’ 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. D:\NBReportSoln\NBReportSoln\DateRel.rdl 0 0

In the textbox156 I have this expression:

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

and some Fields.Valore could be -1
but never non numeric values.

How can I solve this strange problem?

Thanks in advance.

Luis

James K
Master Smack Fu Yak Hacker

3873 Posts

Posted - 2013-09-10 : 09:04:54

Change your expression to

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

Ciupaz
Posting Yak Master

232 Posts

Posted - 2013-09-10 : 09:32:29

Perfect, thank you James.

L

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources