Forum Discussion
Paginated Report Interactive Sorting doesn't sort indicators
Anonymous I decided to try to use a font symbol color coded based on expressions rather than indicators which use images. In my initial testing this has worked! Now to reconfigure everything...annoying but a functional workaround. Thanks for your help in testing and feedback.
Thanks for the reply! The indicators I have set up were used using expression forumlas as their value so I was curious to try your recommendation for tying them directly to the data source. To test this, I created a calculated field in the data source that matched the indicator expression, tested that the values were correct in the data source calculated field, and then tied the indicator to that dataset calculated field rather than use a expression formula. When I use interactive sorting, still no luck.
You example only does an initial sorting which works. My solution breaks down when using interactice sorting.
I then added the calculated field directly to the table, turned on interactive sorting on that field, and tried again. Still no luck. None of the indicators shift when using interactice sorting on any of the fields where it is turned on.
I welcome any further insight or ideas you may have.