Filter criteria issue in grids
In a database table there is a column with data type decimal, when using a repeating grid with a filter configuration and a data page as the data source for that particular column the value is rounded off.
For example, if the value in database table is 2500.67 then in the repeating grid it is displayed as 2501. In the filter it shows the rounded off values, but when using "from and to" in the filter and entering the range 2501 to 3500 then it does not pick 2500.67 (displayed as 2501 in the repeating grid) as it filters the values on the basis of the database contents.
Steps to Reproduce
- Create a grid and add a column of number/integer type.
- Add a filter to it.
- Run and enter any value present in the grid and apply the filter.
- The result set now will exclude the number which is entered.
The display values of a number control in the column of a repeating grid are not being honored whenever range filtering is used.
Round off the value when populating the grid source example: use a function to round off the value in the report definition or use a data transform to round off the value while populating a datapage.
0% found this useful