asked on
How Do I Pass a Value from a Scriplet Variable to an iReport Parameter?
I wrote a scriptlet that executes an Oracle SQL function called "get_bps_rept_gn". It returns a number that I am trying to pass to an iReport 3.5.1 parameter. The parameter is called $P{bps_rept_gn}. Whenever I try to pass the value to this parameter, the parameter displays as null. I can successfully pass the value to a variable of the same name as the parameter ($V{bps_rept_gn}. This value displays in the report. I'm new to scriplets so I may be missing something in the syntax.
/*
* To change this template, choose Tools | Templates
* and open the template in the editor.
*/
package com.BPS_scriptlet_pg;
import net.sf.jasperreports.engine.JRDefaultScriptlet;
import net.sf.jasperreports.engine.JRScriptletException;
/*import net.sf.jasperreports.engine.query.JRQueryExecuter;*/
import java.sql.Connection;
import java.sql.SQLException;
import java.sql.CallableStatement;
import java.util.HashMap;
import java.util.Map;
/**
*
* @author
*/
public class BPS022_scriptlet extends JRDefaultScriptlet {
Connection con;
@Override
public void afterReportInit() throws JRScriptletException
{
con = (Connection)this.getParameterValue("REPORT_CONNECTION");
try{
seeCon(con);
Integer pi_rept_gn2 = 0;
CallableStatement cs4 = con.prepareCall("{? = call get_bps_rept_gn}");
cs4.registerOutParameter(1, java.sql.Types.NUMERIC);
cs4.executeUpdate();
pi_rept_gn2 = cs4.getInt(1);
this.setVariableValue("bps_rept_gn", pi_rept_gn2);
//parametersMap.put("bps_rept_gn", pi_rept_gn2.intValue());
Map parameters = new HashMap();
parameters.put("bps_rept_gn", pi_rept_gn2);
} catch (SQLException e){
System.out.println("Caught SQL Exception: " + e.getErrorCode());
}
System.out.flush();
}
public void seeCon (Connection c) throws SQLException
{
System.out.println("Con is closed? :" + c.isClosed());
}
}
Scripting LanguagesJScriptJava
Last Comment
mrcoffee365
ASKER
I've linked the scriptlet to the report so that's why I'm not calling the report. There is a parameter defined in the report that's called $P{bps_rept_gn}. I was hoping that the new parameter value would replace the default value of the parameter. But maybe this is not possible. Maybe the parameter value can only be passed at the time that the report is called rather than after the report is already initialized?
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
I'm sorry. I didn't include the .jrxml report file with the code because that's a separate file. The scriptlet was being called from the .jrxml file. After investigating, I found that I need to call the report in a manner similar to this:
jasperReport = JasperCompileManager.compi
"reports/jasperreports_dem
jasperPrint = JasperFillManager.fillRepo
jasperReport, new HashMap(), new JREmptyDataSource());
JasperExportManager.export
jasperPrint, "reports/simple_report.pdf
So your answer got me on the right track and I'm not trying to pass the parameter from the scriplet called by the report. Now I'm trying to create a little Java app that will call the report and pass the parameter to it. Thanks for your help and please wish me luck!
jasperReport = JasperCompileManager.compi
"reports/jasperreports_dem
jasperPrint = JasperFillManager.fillRepo
jasperReport, new HashMap(), new JREmptyDataSource());
JasperExportManager.export
jasperPrint, "reports/simple_report.pdf
So your answer got me on the right track and I'm not trying to pass the parameter from the scriplet called by the report. Now I'm trying to create a little Java app that will call the report and pass the parameter to it. Thanks for your help and please wish me luck!
ASKER
I didn't supply all the info that Mr. Coffee needed to give a complete solution. But I'm happy because he straightened out my incorrect approach to the problem.
Thanks, and good luck!
Also -- it's great that you posted your final solution. Was it the this.setVariableValue for the named variable that set the value the way you wanted? As long as you had the call done correctly, as you've posted?
Also -- it's great that you posted your final solution. Was it the this.setVariableValue for the named variable that set the value the way you wanted? As long as you had the call done correctly, as you've posted?
ASKER
I successfully passed the parameters in my test! In order to pass the parameter, I first created a parameter called $P{ReportTitle} in my iReport.
Then I created a Java program to run the report. Before the statement to fill the report, I created the statements below which change the value in the $P{ReportTitle} parameter to "Successfully Changed Title":
//Preparing parameters
Map parameters = new HashMap();
parameters.put("ReportTitl
Then I filled the report with this code:
JasperFillManager.fillRepo
parameters,connection); // creates .jrprint file
Now back to my project!
Then I created a Java program to run the report. Before the statement to fill the report, I created the statements below which change the value in the $P{ReportTitle} parameter to "Successfully Changed Title":
//Preparing parameters
Map parameters = new HashMap();
parameters.put("ReportTitl
Then I filled the report with this code:
JasperFillManager.fillRepo
parameters,connection); // creates .jrprint file
Now back to my project!
Great -- thanks for posting!
Map parameters = new HashMap();
parameters.put("bps_rept_g
but I don't see where that is put somewhere that would be visible outside of this method. And this method doesn't call the report, so it can't help you there. You create the object in the method, then the method ends and the object goes away.
Where do you want the new parameter value to be used to be sent to iReport?