or
I have a screen that contains a RadGrid where I set the GroupSetting CaseSensitive = false, and I allow filter b column. This woks for all my columns except for a column I have set with a filter template that contains a RadComboBox. When I select from the combo nothing gets returned. When I run SQL Server Profiler I can see the OnNeedDataSouce query works and returns data. If I change the grid to populate with the column being set to upper case it works. If I Remove the CaseSensitive it works. Why is it having an issue with the filter with a radcombo box?
<
GroupingSettings
CaseSensitive
=
"false"
/>
<
ExportSettings
>
<
Excel
Format
=
"Html"
/>
</
ExportSettings
>
<
AlternatingItemStyle
BackColor
=
"#EEEEEE"
></
AlternatingItemStyle
>
<
MasterTableView
DataKeyNames
=
"AdvisorBlotterID"
PagerStyle-Mode
=
"NextPrevNumericAndAdvanced"
>
<
Columns
>
<
telerik:GridBoundColumn
SortExpression
=
"ClientName"
DataField
=
"ClientName"
HeaderText
=
"Client Name"
>
<
FilterTemplate
>
<
telerik:RadComboBox
ID
=
"RadComboBoxClientName"
DataTextField
=
"ClientName"
DataValueField
=
"ClientName"
AppendDataBoundItems
=
"true"
Width
=
"150px"
SelectedValue='<%# ((GridItem)Container).OwnerTableView.GetColumn("ClientName").CurrentFilterValue %>' runat="server" OnClientSelectedIndexChanged="ClientNameIndexChanged" Skin="Office2007">
</
telerik:RadComboBox
>
<
telerik:RadScriptBlock
ID
=
"RadScriptBlock1"
runat
=
"server"
>
<
script
type
=
"text/javascript"
>
function ClientNameIndexChanged(sender, args) {
var tableView = $find("<%# ((GridItem)Container).OwnerTableView.ClientID %>");
if (args.get_item().get_value() == "0") {
tableView.filter("ClientName", args.get_item().get_value(), "NoFilter");
}
else {
tableView.filter("ClientName", args.get_item().get_value(), "EqualTo");
}
}
</
script
>
</
telerik:RadScriptBlock
>
</
FilterTemplate
>
<
ItemStyle
VerticalAlign
=
"Top"
/>
</
telerik:GridBoundColumn
>
<
telerik:RadChart
ID
=
"draw_graph"
runat
=
"server"
Style
=
"margin-top: -21px; margin-left: 3px;"
Height
=
"500px"
Width
=
"1180px"
Skin
=
"LightGreen"
AutoLayout
=
"true"
>
<
PlotArea
>
<
XAxis
MaxValue
=
"5"
MinValue
=
"1"
Step
=
"1"
LayoutMode
=
"normal"
DataLabelsColumn
=
"Name"
>
<
Appearance
Color
=
"182, 182, 182"
MajorTick-Color
=
"216, 216, 216"
>
<
MajorGridLines
Color
=
"216, 216, 216"
PenStyle
=
"Solid"
/>
<
TextAppearance
TextProperties-Color
=
"51, 51, 51"
>
</
TextAppearance
>
</
Appearance
>
<
AxisLabel
>
<
TextBlock
>
<
Appearance
TextProperties-Color
=
"51, 51, 51"
>
</
Appearance
>
</
TextBlock
>
</
AxisLabel
>
</
XAxis
>
<
YAxis
>
<
Appearance
Color
=
"182, 182, 182"
MajorTick-Color
=
"216, 216, 216"
MinorTick-Color
=
"223, 223, 223"
>
<
MajorGridLines
Color
=
"216, 216, 216"
/>
<
MinorGridLines
Color
=
"223, 223, 223"
/>
<
TextAppearance
TextProperties-Color
=
"51, 51, 51"
>
</
TextAppearance
>
</
Appearance
>
<
AxisLabel
Visible
=
"true"
>
<
TextBlock
Text
=
"% ( In Percent )"
Appearance-TextProperties-Color
=
"Orange"
Appearance-TextProperties-Font
=
"Bold"
>
<
Appearance
TextProperties-Color
=
"Orange"
TextProperties-Font
=
"Bold"
>
</
Appearance
>
</
TextBlock
>
</
AxisLabel
>
</
YAxis
>
<
Appearance
>
<
FillStyle
FillType
=
"Solid"
MainColor
=
"White"
>
</
FillStyle
>
<
Border
Color
=
"182, 182, 182"
/>
</
Appearance
>
</
PlotArea
>
<
ChartTitle
>
<
Appearance
Position-AlignedPosition
=
"Top"
>
<
FillStyle
MainColor
=
""
>
</
FillStyle
>
</
Appearance
>
<
TextBlock
Text
=
"Company Analysis"
Appearance-Position-AlignedPosition
=
"Top"
>
<
Appearance
TextProperties-Color
=
"Black"
TextProperties-Font
=
"Arial, 12pt"
>
</
Appearance
>
</
TextBlock
>
</
ChartTitle
>
<
Appearance
Corners
=
"Round, Round, Round, Round, 7"
>
<
FillStyle
FillType
=
"ComplexGradient"
>
<
FillSettings
GradientMode
=
"Horizontal"
>
<
ComplexGradient
>
<
telerik:GradientElement
Color
=
"236, 236, 236"
/>
<
telerik:GradientElement
Color
=
"248, 248, 248"
Position
=
"0.5"
/>
<
telerik:GradientElement
Color
=
"236, 236, 236"
Position
=
"1"
/>
</
ComplexGradient
>
</
FillSettings
>
</
FillStyle
>
<
Border
Color
=
"130, 130, 130"
/>
</
Appearance
>
<
Legend
>
<
Appearance
Overflow
=
"Row"
Position-AlignedPosition
=
"Bottom"
Dimensions-Margins
=
"17.6%, 3%, 3px, 6px"
Dimensions-Paddings
=
"2px, 8px, 6px, 3px"
>
<
ItemMarkerAppearance
Figure
=
"Square"
FillStyle-MainColor
=
"Green"
>
<
Border
Width
=
"0"
/>
</
ItemMarkerAppearance
>
<
FillStyle
>
</
FillStyle
>
<
Border
Width
=
"1"
/>
</
Appearance
>
</
Legend
>
</
telerik:RadChart
>