Aug 01, 2009, 3:17 PM
Calculate Totals in GridPanel
I would like to calculate the totals of this column using the ext:GridPanel
<ext:RecordField Name="TotalAmountDue" Type="Float" />
i tried grouping but never seemed to work
Thanks
<ext:RecordField Name="TotalAmountDue" Type="Float" />
<ext:Store ID="StoreVendor" OnSubmitData="StoreVendor_Submit" AutoDataBind="false"
runat="server">
<AjaxEventConfig IsUpload="true" />
<Reader>
<ext:JsonReader ReaderID="InvolvedPartyID">
<Fields>
<ext:RecordField Name="InvolvedPartyID" />
<ext:RecordField Name="CompanyName" />
<ext:RecordField Name="TotalLineCount" />
<ext:RecordField Name="TotalAmountDue" Type="Float" />
</Fields>
</ext:JsonReader>
</Reader>
<Listeners>
<LoadException Handler="Ext.MessageBox.alert('Load failed', response.statusText);" />
</Listeners>
<AjaxEventConfig Timeout="900000" />
</ext:Store>
i tried grouping but never seemed to work
<ColumnModel ID="ColumnModel2" runat="server">
<Columns>
<ext:Column Header="Company Name" ColumnID="CompanyName" Width="150" DataIndex="CompanyName" />
<ext:Column Header="Total Line Count (STAT)" Width="150" DataIndex="TotalLineCount" />
<ext:GroupingSummaryColumn Groupable=true Header="Total Amount Due" ColumnID="TotalAmountDue" DataIndex="TotalAmountDue"
Sortable="true" SummaryType="Sum" >
<Renderer Format="UsMoney" />
<SummaryRenderer Format="UsMoney" />
</ext:GroupingSummaryColumn>
<ext:Column ColumnID="Details" Header="Details" Width="50" Align="Center" Fixed="true"
MenuDisabled="true" Resizable="false">
<Renderer Fn="addImage" />
</ext:Column>
</Columns>
</ColumnModel>
<View>
<ext:GroupingView ID="GroupingView1" EnableRowBody=true Enabled=true runat="server" AutoFill="true" ShowGroupName="true"
EnableNoGroups="false" HideGroupedColumn="false" />
</View>
<Plugins>
<ext:GroupingSummary Enabled=true ID="GroupingSummary1" runat="server" />
<ext:GridFilters runat="server" ID="GridFilters1" Local="true">
<Filters>
<ext:StringFilter DataIndex="CompanyName" />
<ext:StringFilter DataIndex="TotalLineCount" />
<ext:StringFilter DataIndex="TotalAmountDue" />
</Filters>
</ext:GridFilters>
</Plugins>
Thanks