iReport Tutorial (part 4) - Calling Report With Parameter

Sometimes we need to pass one or more parameters to our report. For example, we may need to generate a report for some items with a spesific category or price. Based on our previous tutorial, we're going to make a report to view the contacts list with a certain address. For this tutorial, you have to create a new report.

Adding New Parameter

You need to specify address as a parameter, so click on View menu, then click Parameters. Click New to add new parameter. Give a name for your new parameter and specify its data type. For example, I give the name PRM_ADDRESS for this parameter and its data type is String. After that, give a check mark on Use as a prompt option. You can see the picture below for a clearer information.

Create Report Query

After you create a new parameter, you have to create report query based on that new parameter. How we do this? Click on Data menu, then click on Report Query. In the query text box, type this SQL command: SELECT * FROM contact WHERE address=$P{PRM_ADDRESS}.

As you can see the $P{PRM_ADDRESS} represents the parameter that you've made before.

After that, you have to design the report. The report's layout is up to you now. I will not talk about how to design the report here because I have talked about it in the previous tutorial.

Write Your Code

Let's write the code! Same like the previous tutorial, I'll give you all the code so you can copy-paste and modify it if necessary.

import javax.swing.*; import java.awt.*; import java.awt.event.*; import net.sf.jasperreports.view.*; import net.sf.jasperreports.engine.*; import java.sql.*; import java.util.*; public class testParameter extends JFrame implements ActionListener{ JasperPrint JPrint; JButton btnShowReport; JLabel lblParameter; JTextField txtParameter; // INITIALIZE GUI COMPONENTS public void initComponent(){ btnShowReport=new JButton("SHOW REPORT"); btnShowReport.setMnemonic('S'); btnShowReport.addActionListener(this); lblParameter=new JLabel("Address"); txtParameter=new JTextField(15); } // DESIGN THE FORM public void design(){ setTitle("Test Parameter"); getContentPane().setLayout(new FlowLayout()); getContentPane().add(lblParameter); getContentPane().add(txtParameter); getContentPane().add(btnShowReport); pack(); setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE); show(); } // SHOW THE REPORT public void showReport(){ try{ // PREPARING DATABASE CONNECTION String jdbcDriver = "com.mysql.jdbc.Driver"; Class.forName(jdbcDriver); String url = "jdbc:mysql://localhost/contact"; String user = "user1"; String pass = "password"; Connection con = DriverManager.getConnection(url, user, pass); // PATH TO YOUR JASPER FILE String fullPath="/home/lucky/Documents/Java/report/TestParameter.jasper"; // PREPARE THE PARAMETERS Map<String, Object> param=new HashMap<String, Object>(); param.put("PRM_ADDRESS",txtParameter.getText()); // FILL THE REPORT JPrint=JasperFillManager.fillReport(fullPath,param,con); // VIEW THE REPORT JasperViewer.viewReport(JPrint,false); // CLOSE CONNECTION con.close(); } catch(Exception ex){ System.out.println(ex.toString()); } } // CONTRUCTOR testParameter(){ initComponent(); design(); } public static void main(String[] args){ new testParameter(); } // EVENT LISTENER public void actionPerformed(ActionEvent ae){ // IF SHOW BUTTON CLICKED, SHOW THE REPORT if(ae.getSource()==btnShowReport) showReport(); } }

Execute It!

Final step is execute your program. Don't forget to set the CLASSPATH. If you forget how to do that, you can see the previous tutorial right before this one.