Team,
Here is my Requirement. Please let me know if there is a way to implement this.
1) I have a value prompt which is Single Selection
2) I changed the Select UI to List Box
3) Auto Submit Property is set to "Yes" to filter the records in the List based on the selection.
5) Run with Full Interactive mode is "Yes"
6) when the user run the report and when he select a value in the prompt, the records in the List will get filtered. Which is fine.
7) Now user changed his mind to deselect the option and see for OverAll values. So I need the Deselect option for List Box - Single Selection Prompt.
Thanks!
Kiran
Quote from: Kiran Kandavalli on 11 Dec 2017 11:19:01 AM
Team,
Here is my Requirement. Please let me know if there is a way to implement this.
1) I have a value prompt which is Single Selection
2) I changed the Select UI to List Box
3) Auto Submit Property is set to "Yes" to filter the records in the List based on the selection.
5) Run with Full Interactive mode is "Yes"
6) when the user run the report and when he select a value in the prompt, the records in the List will get filtered. Which is fine.
7) Now user changed his mind to deselect the option and see for OverAll values. So I need the Deselect option for List Box - Single Selection Prompt.
Thanks!
Kiran
Hi,
Add a Static Choice to the prompt of a single value - All
Then modify the filter from [Your list item] = ?Your Parameter? to [Your list item] = ?Your Parameter? or 'All' = ?Your Parameter'
This will give you an extra entry in your prompt for 'All' which will return all rows
Cheers!
MF.
Thank you MF!