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.
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.
- Create a Dropdown Document Property tied to the Columns you want to expose for Filtering.
- Create Calculated Column, Tied to the Column Name selection in the Document Property
- Add the Document Property selection and Calculated Column in the Text Area for Dynamic Filtering.
Comments
Post a Comment