Hello all, hoping you can shed some light on question - I have an interactive report with a prompt set to radio buttons, populated by query, whose selection I use to filter the records shown on screen. It works well, selecting a value by radio button filters records, doing auto-submits. However, when I click 'Deselect' below the prompt, nothing happens. I expected a Autosubmitto be executed, and the page refreshed to show all records. All the deselct does is clears the selected radio button. Is this by design ?! Anyone know any macros / js to make it perform as I expected it would?
many thanks!
If you are seeing the Select all Deselect all , then your prompt has Multi-Select set to Yes. And if that's the case, Auto-Submit must be set to No, which is why your results are not being refreshed.
I don't know if this is suitable for your report, but you could drag in a Prompt Button of type Finish.
I would expect that deselect does not invoke an auto submit. If you want another option besides a finish button you could add a static choice for "All Values" and then alter your filter expression accordingly.
[YourQueryItem] = ?Parameter?
or
?Parameter? = 'All Values'