I am wondering if there is a way to default the Filter options for the user console. I have been looking for a while and cannot seem to figure this out.

Currently the filter options for interactive report are:

Name:  filteroptions.png
Views: 19
Size:  6.8 KB


During the design process for Interactive Report we train our users to deselect "Select Distinct" and to add a Row Limit; but we find that to be slightly inconvenient.

Designing report from the user console against our database is very slow without these options.

Is there are way I can deselect Select Distinct and select Row Limit and add value as default values?