Hello, I'm a COMPLETE BEGINNER in Jasper Reports and JSON so please bear with me. So in JAVA, I'm trying to fill a report template by code (as in like JasperFillManager.fillReport(blah,blah)) using a JSON file as it parameter source. The JSON file that stores all of the information for the parameters willl be stored as a blob in a database and I will get it from the database in string form due to certain limitations with other technologies I am using. The JSON file would store a default value and a sql query for each parameter. What I want to do is run the sql query to fill the report OR use the default value in the case that the sql query does not yield any results or is null itself. The JSON file looks like this: In here, the parameters would be "ParameterName" and "WOMEN_ID" { "ParameterName": { "default": "Parameter1", "SQL": "SQL QUERY" }, "WOMEN_ID":{ "default": null, "SQL": "SELECT ID FROM USERS WHERE GENDER_CODE=2" }, .... } I was wondering if you could help me figure out how to fill a template in the method I mentioned before. Thanks!