With APEX 18.1 there is a new option within your interactive report, one of them is: PL / SQL Function Body return SQL Query.
With this function you can create interactive dynamic reports.
I have the problem that remains with the definition of the columns of the select with which the report is defined and can not be dynamically modified, is there a solution?