Hello,
I am using Radgrid for displaying data. I have two GridBoundColumns (datafield is of string type and currentfilterfunction is contains), one GridDateTimeColumn(datafield is of type DateTime) and two GridNumericColumns(datafield of type Decimal and currentfilterfunction is GreaterThanOrEqualTo).
Filtering with two GridBoundColumns is working fine. Filtering in GridNumericColumns seperately are working fine.
But have problem if filter by combining two GridNumericColumns.
There are some rows with Numeric Values as shown below . Ex
Col1 Col2
1000 1000
1200 1235
1250 1270
1400 1450
1500 1567
If I enter 1250 in Col 1 or Col 2 seperately , it is giving 3 rows.
When I enter 1250 in Col1 and 1250 in Col 2 filters, then actual output rows should be
1250 1270
1400 1450
1500 1567
Which is not working.
I entered 1250 in one col, and exact values (like 1270 or 1450 or 1567) in other col instead of 1250, then in the out that specifc row is displayed.
I don't know where the problem is.
Any suggestion pls,
AV
I am using Radgrid for displaying data. I have two GridBoundColumns (datafield is of string type and currentfilterfunction is contains), one GridDateTimeColumn(datafield is of type DateTime) and two GridNumericColumns(datafield of type Decimal and currentfilterfunction is GreaterThanOrEqualTo).
Filtering with two GridBoundColumns is working fine. Filtering in GridNumericColumns seperately are working fine.
But have problem if filter by combining two GridNumericColumns.
There are some rows with Numeric Values as shown below . Ex
Col1 Col2
1000 1000
1200 1235
1250 1270
1400 1450
1500 1567
If I enter 1250 in Col 1 or Col 2 seperately , it is giving 3 rows.
When I enter 1250 in Col1 and 1250 in Col 2 filters, then actual output rows should be
1250 1270
1400 1450
1500 1567
Which is not working.
I entered 1250 in one col, and exact values (like 1270 or 1450 or 1567) in other col instead of 1250, then in the out that specifc row is displayed.
I don't know where the problem is.
Any suggestion pls,
AV