Column sorting is not working in grid repeat when using custom control on the Column
We have a grid repeat where we have column (DAY).The value under this column should display the diffrence between date created and current date in bussiness calendar days.
The grid is sourced by report defnition.The report defnition is not having business calendar functions to calculate the difference.So we have written a control and calculating the diffrence in the control activity and kept the control on the column in reprat grid.The values are dispalying properly .But the values are not sorting.
I have attached the code snippets and UI Screen.Please look into it.
***Updated by Moderator: Lochan. Removed user added Ask the Expert and SR Created tags. Apologies for confusion, shouldn't have been an end-user option***
Basically when the Grid layout is bound to Report Defintion, the report definition does the sorting internally and the grid has to just display the results as is. Now the problem here is that, the control logic gets executed after RD does the sorting of results. This is probably not a supported configuration.