Hide columns based on parameter selection

  • Hello,

    Would anyone know how to hide a column if the "select all" item is not checked in a parameter? Thanks

  • From what I can tell, there isn't a particularly elegant way to do this so here's what seems to be the most frequently used method:

    Build an iif() visibility statement that compares the count of values in your dataset for the parameter with the number of values select by the array using the .Count property and returns true or false based on whatever the visibility conditions you are looking to set are.

    Hopefully I've provided you with enough info to be getting on with but if you're stuck on a specific part of the calculation let me know and I'll provide more detail

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply