I have a radgrid that I am building and I'm using autogeneratedcolumns= true because the datasource resultset has pivoted/dynamic columns. The datatype in the pivoted columns is BIT(so I want checkboxes to show for those columns).
When I set AllowFilteringByColumn=true, I get checkbox filtering menus at the top of each column, when I check it, it filters out all rows that aren't checked in the resultset... When I uncheck it, all of the results come back, but none of the checkboxes that were checked are checked. It seems that unclearing a "checkbox filter" only unchecks all checkboxes after all rows are shown again, but there is no recheck of the boxes that were checked. (I've attached my code).... is this the way this is supposed to behave?
Also, filtering seems to only work sometimes.... When I look for "checked only" sometimes, the results are incorrect.
I've attached screenshots and code within same docx file.