This is a migrated thread and some comments may be shown as answers.

[Solved] Footer aggregate causes "Specified Cast is not valid." exception

4 Answers 328 Views

Grid

This is a migrated thread and some comments may be shown as answers.

mlandauer asked on 19 Sep 2008, 12:38 AM

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:

    
            <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.

4 Answers, 1 is accepted

Accepted