Ability to set default value based on SQL query
I need an option to be able to set default filter values dynamically. Something like we do for caching filter values via freehand sql.
Freehand sql for a report default filter values will be great.
Access filters should be considered as well as dependent filters.
This will allow a user to see the report with relevant data rather than empty screen once a report is loaded.