Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi,
In my report two sheets are there, how to clear all selection if I move to next sheet .
basically filters in first sheet should not applicable on second sheet.
Use a trigger OnLeaveSheet, right click on the background of the sheet Properties > Triggers > OnLeaveSheet > Add Actions Selection > Clear All
If you need to select or deselect when activating a new sheet, use instead OnActivateSheet following the same steps
Use a trigger OnLeaveSheet, right click on the background of the sheet Properties > Triggers > OnLeaveSheet > Add Actions Selection > Clear All
If you need to select or deselect when activating a new sheet, use instead OnActivateSheet following the same steps