I have used an SQL function for a column in the Report definition and used that column in the Grid. Able to see the values in the Grid and able to sort the column as well but filtering is not working. When i click on the filter it is not giving me the available value instead it is giving me the None option only and when i provide a value in the text box and click on apply still am not getting any records. now if i click on the filter again then it is giving me the an exception.
can we use filter on the column in the Grid where that column has a SQL function?