If I add the following aggregate to my Grid...
... and then filter, I get the following error
Sys.WebForms.PageRequestManagerServerErrorException: Cannot find column [it.DivisionID].
This is using an Entity Data Source.
How do I fix?
Full column specification (Division column was the example Filter column):
Aggregate="Sum" DataFormatString="{0:C}" FooterAggregateFormatString="<
b
>{0:C}</
b
>"
... and then filter, I get the following error
Sys.WebForms.PageRequestManagerServerErrorException: Cannot find column [it.DivisionID].
This is using an Entity Data Source.
How do I fix?
Full column specification (Division column was the example Filter column):
<
telerik:GridDropDownColumn
UniqueName
=
"Division"
HeaderText
=
"Division"
DataField
=
"DivisionID"
DataSourceID
=
"edsDivision"
ListValueField
=
"DivisionID"
ListTextField
=
"Division1"
SortExpression
=
"Division.Division1"
AutoPostBackOnFilter
=
"true"
CurrentFilterFunction
=
"EqualTo"
ShowFilterIcon
=
"true"
ReadOnly
=
"true"
FilterControlWidth
=
"90px"
>
<
HeaderStyle
Width
=
"100px"
/>
<
ItemStyle
Width
=
"100px"
/>
<
FilterTemplate
>
<
telerik:RadComboBox
ID
=
"ddlDivision"
DataSourceID
=
"edsDivision"
DataValueField
=
"DivisionID"
DataTextField
=
"Division1"
Height
=
"200px"
AppendDataBoundItems
=
"true"
SelectedValue='<%# ((GridItem)Container).OwnerTableView.GetColumn("Division").CurrentFilterValue %>'
runat="server" OnClientSelectedIndexChanged="DivisionChanged" Width="80px">
<
Items
>
<
telerik:RadComboBoxItem
Text
=
"All"
/>
</
Items
>
</
telerik:RadComboBox
>
<
telerik:RadScriptBlock
ID
=
"RadScriptBlock1"
runat
=
"server"
>
<
script
type
=
"text/javascript"
>
function DivisionChanged(sender, args) {
var tableView = $find("<%# ((GridItem)Container).OwnerTableView.ClientID %>");
tableView.filter("Division", args.get_item().get_value(), "EqualTo");
}
</
script
>
</
telerik:RadScriptBlock
>
</
FilterTemplate
>
</
telerik:GridDropDownColumn
>
<
telerik:GridNumericColumn
UniqueName
=
"DebtAgeCurrent"
DataField
=
"DebtAgeCurrent"
SortExpression
=
"DebtAgeCurrent"
HeaderText
=
"Current Debt"
ShowFilterIcon
=
"true"
ReadOnly
=
"true"
CurrentFilterFunction
=
"GreaterThanOrEqualTo"
AutoPostBackOnFilter
=
"true"
NumericType
=
"Currency"
FilterControlWidth
=
"55px"
Aggregate
=
"Sum"
DataFormatString
=
"{0:C}"
FooterAggregateFormatString="<b>{0:C}</
b>">
<
HeaderStyle
Width
=
"100px"
/>
<
ItemStyle
Width
=
"100px"
/>
</
telerik:GridNumericColumn
>