Thanks Mike, this was very helpful. I could successfuly load a custom report based on a parameterized SQL query through my Activator.
However something bugs me while developing this: I can’t modify anything after running the Activator once. At the moment it really is a one-time install unless I change the report’s UUID.
And this despite using the same trick as in PIH/openmrs-module-pihmalawi: invoking this removeOldReports() method prior to doing anything else.