Forums :: Dynamic Chart :: DwZone Forum

DwZone Forum
Welcome to the DwZone-it Forum

FAQ

Memberlist

Usergroups

Dynamic Chart

DwZone Forum Index -> Dynamic Chart

Moderators: Administrators, Moderators

Mark all topics read

Hint: For improved responsiveness, use Internet Explorer 4 (or above) with Javascript enabled, choose 'Dynamic' from the View dropdown and hit 'Set Options' to save your changes.

	Search for
View Per page Messages Since

Messages 61 to 70 of 74 (Total: 31)

First | Prev | Next | Last

Subject

Author

Date

Re:HTTP 500 Internal server error

gianluigi

19:49 13 Jun 2006

numeric error

[email protected]

16:16 28 Feb 2006

Trying to do a pie chart with "sum(value) as totalvalue" in sql statement with group by.

I get an error that all values must be numeric.

How do I format as numeric or is there a fix for this

Tried this also
convert(numeric(12,2),sum(fieldname)) AS Name

Warning!!
DwZone.it Dynamic Chart error:
The recordset contains a non numeric value
Field: Name
Value: 65
Verify the data in your recordset, all the value fields must be numeric