Use CartoDB as a parameter, so users make a selection on a map and have it's report filtered by the selection. For this you can use the script parameter with CartoDB.js. example that does something similar with leaflet.js and postgis in Dropbox.
Use a scriptreport to visualize data on a map. Take a look at the customermap report from the demosystem. It uses the google maps api to show data on a map, you should be able to adapt this to use CartoDB.
Provide a custom output generator so you can export a dynamic list result as a map. (No example on this, but take a look at chapter 10 in the scriptguide, that should give you an idea)
More info on script reports and script parameters can be found in the scriptguide.
More info on script reports and script parameters can be found in the scriptguide.
Dropbox folder with files: https://www.dropbox.com/sh/kr5skr3gi3gb6z9/AADGNeKlDnmtXvcqJewj8q-Xa?dl=0