Package org.pentaho.reporting.engine.classic.core.modules.misc.datafactory.sql

Examples of org.pentaho.reporting.engine.classic.core.modules.misc.datafactory.sql.SQLReportDataFactory.open()


    driverConnectionProvider.setProperty("user", "sa");
    driverConnectionProvider.setProperty("password", "");
    final SQLReportDataFactory sdf = new SQLReportDataFactory(driverConnectionProvider);
    sdf.setQuery("default", "SELECT * FROM CUSTOMERS WHERE CUSTOMERNUMBER IN (${parameter})");
    sdf.setQuery("params", "SELECT DISTINCT CUSTOMERNUMBER FROM CUSTOMERS");
    sdf.open();

    final ReportParameterValues parameterValues = new ReportParameterValues();
    parameterValues.put("parameter", pvalue);
    sdf.queryData("default", parameterValues);
    sdf.close();
View Full Code Here

TOP
Copyright © 2018 www.massapi.com. All rights reserved.
All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.