Whenever I try to set Aggregate="Sum" for an integer column, I get the "Specified Cast is not valid." exception. I've tried all kinds of things, but always get the exception. It works fine with Decimal columns.
These cause an exception:
While this works fine:
I'm using Q2 2008 SP1, btw.
These cause an exception:
<rad:GridNumericColumn DataField="EstQty" HeaderText="Est. Qty." |
UniqueName="EstQtyColumn" Aggregate="Sum" NumericType="Number" |
DataType="System.Int32" DataFormatString="{0:N0}"> |
<HeaderStyle HorizontalAlign="Center" /> |
<ItemStyle Width="6em" /> |
</rad:GridNumericColumn> |
<rad:GridNumericColumn DataField="FinalQty" HeaderText="Final Qty." |
UniqueName="FinalQtyColumn" Aggregate="Sum" NumericType="Number" |
DataType="System.Int32" DataFormatString="{0:N0}"> |
<HeaderStyle HorizontalAlign="Center" /> |
<ItemStyle Width="6em" /> |
</rad:GridNumericColumn> |
While this works fine:
<rad:GridNumericColumn DataField="Postage" HeaderText="Postage" UniqueName="PostageColumn" |
NumericType="Currency" DataType="System.Decimal" Aggregate="Sum" |
FooterAggregateFormatString="{0:C}"> |
<HeaderStyle HorizontalAlign="Center" /> |
<ItemStyle HorizontalAlign="Right" /> |
</rad:GridNumericColumn> |
I'm using Q2 2008 SP1, btw.