Is it possible to customize the file name when exporting a report from a table?

I dont think you can do it natively, but it is definitely feasible using a workato recipe. In fact if you are using a cloud service it will upload the csv file into the specific destination as well.

SO essentially you will trigger a webhook using a button that calls a workato recipe. It creates a csv file based on the query and uploads the resulting csv file to your designated location.