Hi,
Can we use the following java API to change the default Query of the report at runtime depending upon some business logic / user input? If it is true, it could be great use to supply different runtime SQL query to the report..

DriverConnectionProvider provider = new DriverConnectionProvider();
provider.setDriver("org.hsqldb.jdbcDriver");
provider.setProperty("user", "sa");
provider.setProperty("pass", "");
provider.setUrl("jdbc:hsqldb:file:data/libraryinfo");
SQLReportDataFactory dataFactory = new SQLReportDataFactory(provider);
String sqlQuery = "SELECT * FROM LIBRARYINFO";
dataFactory.setQuery("default", sqlQuery);
report.setDataFactory(dataFactory);