Please help me out!
I have recently purchased a licence for the Q2 2016 devcraft tools and I am working on a website update...
I have a database in which numeric values have been recorded historically in an nvarchar column. I can't readily change the column type as it is in production and has several years of data in it.
However I would now like to use the aggregate function to put sum totals in a footer. How can I achieve this from where we are now - i.e. with a non-numeric data column? Obviously I get an error just adding aggregate="Sum" ( 'Sum is not supported for type system.object').
I tried cheating by just changing the column from gridbound to gridnumeric but it is not so easily fooled!
Can you suggest what is the best way to get from the nvarchar database column I have now, to getting an aggregate sum in the footer?
Using Q2 2016 controls in VS 2015