Dynamic Column Filter Selections

At times we have 10s or 100s of columns which can be potentially be used for filtering the data.
We don't want to use the Filter panel for restriction and it is too cumbersome to provide all the filters in the Text Area.

Well, we can use Document Property Selection along with Calculated Columns, to provide the user with ability to Filter on 100s of Columns based on their selection.


  1. Create a Dropdown Document Property tied to the Columns you want to expose for Filtering.
  2. Create Calculated Column, Tied to the Column Name selection in the Document Property
  3. Add the Document Property selection and Calculated Column in the Text Area for Dynamic Filtering.

Final Result








Comments

Popular posts from this blog

IronPython: Get Unique values from Data Column

IronPython: Mark Rows, which are currently Filtered

Dynamic Page Layout setup