i use the Class and Age functions to create age bands in a table for employee date of births i.e.
=Class(Age('$(vMyDate)',date_of_birth),5,'Age Band' ) -- where vMyDate is a variable storing todays date
Now this displays perfectly as you'd imagine, as a list of staff by age bands. The problem that i have is that when an age band is selected and therefore the results restricted you cant deselect it to go back to the full list.
i guess this is because the user isn't actually selecting an age band, but what is essentially a function.
does anyone know of any workarounds to make it de-selectable?
As you have seen, selecting a row is effectively selecting a range of date_of_birth fields. You could create a button with the action of clearing the selections in the date_of_birth field. You could even give this button (or text box) the little eraser icon and position it on the caption over the current eraser icon. Make sure that the button/text box is on a higher layer than the table.
Logic will get you from a to b. Imagination will take you everywhere. - A Einstein