05-25-2016 11:17 AM
Button on VA Report to "Clear all Filters"
i sometimes have multiple filters on tab on a report in VA.
is it possible to provide a button or link on a report that clears all the user entered filters?
05-26-2016 06:28 PM
I'm afraid there is no such button available in VA. However you can get the same effect by refreshing a report. This trick clears all filters and recovers a start version of the report :-)
05-27-2016 01:53 AM
That's correct. This capability doesn't exist, but I'd like to suggest a workaround that hopefully will help you.
First, you will need a source table with one character column (you can call it Reset_Release for example) and two rows, like below (make sure that table is loaded in memory):
Next, add a button bar object to your report and assign the Reset_Release column to its category role. Create and assign a character parameter (let's call it p_Button) to this button bar. Make sure that Required is checked under the button bar Properties tab. Optionally you can make the button to grow vertically instead of horizontally, which is the default, and it would look like this:
Suppose you have a category called Product that you want to add to a control object. Create a calculated item (let's call it Resetable Product) that is defined with the expression below. Observe that the yellow rectangle contains an empty string "" (missing), and not "text string" (but it could actually contain any value that does not exist as a product in our particular case - for example, it could be something like "Click Release to populate" - this will get clear at the end).
Assign Resetable Product in the category role of your control object.
To reset values that might be selected in the control object, you must first click on Reset, then click on Release in the button bar.
When you click on Reset in the button bar, Resetable Product resolves to missing and the control object will display only the missing value. At that moment, if there were products selected in the control object, the selections would be lost. When you click on Release in the button bar, Resetable Product resolves to Product and the control object is populated back, but none of its values will be selected.
04-28-2017 09:32 AM