I have created a matrix with a toggle option on one of the rows (when the report is initially run this row is hidden).
This row when toggled produces 10 or more rows with data.
In the column headings I have given the user the option to interactively sort through the data that is stored in this row.
The problem that I am having is that when I choose to sort the data after I have toggled to see the data, the report re-renders and the goes back to the un-toggled view.
So I have to re-toggle to see what my sorted data.
I want to be able to view my sorted data without having to toggle back out.
I believe the solution lies in Row visibility "show or hide based on expression". I just don’t know what expression to use... or if the solution is more complex.
View Complete Post