Hello, I'm trying to figure out how best to implement reports for a multi-tenant system where each tenant has their own database. Our goal is to build reports that can be run against any customers database without having to set up specific reports or connection details which are stored on the server. I'd like to create a generic report and be able to pass in the connection details. I'm not sure if this has any impact but we're running against a Mongo database. Our set up is that we are hosting and running reports from the JasperSoft report server and running reports thorugh the REST Client (Java). Right now we have a hardcoded DataAdapter which sets up a connection to a known tenant just to verify the report layout. I have seen examples of being able to do pass the report the connection details at runtime but that was for the embedded solution. Is it possible to create a report that is static in the query but is able to be executed against a specific tenant at runtime? I have been searching for a few hours and felt I would reach out since I'm not having much luck up to this point. Any help of guidance would be much appreciated. -Doug
