we are using the report control to visualize the data in a DB table. We have a feature that enables the user to lock certain number of columns when scrolling horizontally. However, using FreezeColumnsCount is not behaving as we want it to: 

According to its description, the property will only freeze columns starting at the left-most side of the report and only in consecutive order. I guess that to achieve this the report control determines the order of the column based on its index, which does not change when the column getts hidden. The problem is that if the user wants to lock 3 columns but columns with index 1,2,3 are hidden, then no columns will be locked. 

Is there a way to ensure that we will always have the visible columns locked? Thank you in advance.