I am looking for an interactive sort property and value to use in an expression controlling the show/hide property for the detail rows in a table.
By default the table is set to display collapsed. Once expanded by the user, s/he can click individual columns for sorting. After the column heading is clicked to sort a column, the report refeshes...with the table collapsed (as it should because of the default setting). The user must then re-expand the section to see the detail s/he just sorted. Not an ideal user experience!
My preference is to set up the report to refresh with the detail showing whenever interactive sorting has been chosen by the user. Any suggestions?
Thanks!