Jasper report - ireport but in java class - dynamic report using jasper report api

[vijaykumar shah]

Hello experts
I am working on jasper reports to generaete reports and also i have downloaded ireports latest version for working with jasper reports and creating reports .. its all working fine ... but now my requirement currently is something different
1. User will have a page where he would input the parameters like From Date - To Date and will select one another parameter
2. Depending on the parameter the search would be executed on the db and all the records matching the same criterial are required to be shown would be saved into the array list or what ever..
3. Now a report shall be generated for the same.. means a pdf, .html will be generated and given to the client in the email ..
so my report creation is dynamic .. i have worked for attaching files in email using java mail and all .. but now the major question is how do i totally create a dynamic report using jasper report and its api..
a sample code matching to the same would be highly appreciated as i am working under time constraints ..
awaiting for response
with regards
vijay
:roll:

[Michael Ernest]

Moving this to Other APIs

[Joel McNary]

When you say that the report needs to be dynamic, are you saying that you need to dynamically change the structure of the report, or that you need to dynamically change the data in the report? From what you say, the latter sounds like what you are trying to do, and should be very easy to accomplish.
What follows is the guts of my method that runs a JasperReport. You will, of course, need to modify this to suit your preferences.

            //find the connection
            String connectionURL = aData.getConnectionMetadata().getConnectionURL();
            String userName = aData.getConnectionMetadata().getConnectionUserName();
            String password = aData.getConnectionMetadata().getConnectionPassword();
            
            Class.forName(aData.getConnectionMetadata().getConnectionDriverClass());
            java.sql.Connection aConnection = java.sql.DriverManager.getConnection(connectionURL, userName, password);
            
            //Prepare the parameters
            java.util.Map parameters = new java.util.HashMap();
            java.util.Iterator parameterList = aData.getParameters().iterator();
            JasperReport aReport = null;
            if(aData.getReportFileName() == null){
                aReport = JasperManager.loadReport(aData.getSource());
            }
            else{
                aReport = JasperManager.loadReport(aData.getReportFileName());
            }
            java.util.Map reportParameters = HashToArraySorter.mapify(aReport.getParameters(), "getName");
            
            while(parameterList.hasNext()){
                NameValuePair aPair = (NameValuePair)parameterList.next();
                String parameterName = (String)aPair.getNameObject();
                Value aValue = (Value)aPair.getValueObject();
                
                JRParameter aReportParameter = (JRParameter)reportParameters.get(parameterName);
                Class expectedClass = aReportParameter.getValueClass();
                Object parameterValue = aValue.getValueAs(expectedClass);
                parameters.put(parameterName, parameterValue);
                //                System.out.println("Assigned: " + parameterName + " to: " + parameterValue);
            }
            //Create the report
            JasperPrint aPrint = JasperManager.fillReport(aReport, parameters, aConnection);
            aPrint.setCopies(aData.getNumberOfCopies());
            if("Preview".equals(aData.getMode())){
                JRViewer aViewer = new JRViewer(aPrint);
                JFrame aFrame = new JFrame("Report Viewer");
                aFrame.getContentPane().add(aViewer);
                java.awt.Dimension screenSize = java.awt.Toolkit.getDefaultToolkit().getScreenSize();
                aFrame.setSize(screenSize.width/2, screenSize.height/2);
                java.awt.Insets insets = aFrame.getInsets();
                aFrame.setSize(aFrame.getWidth() + insets.left + insets.right, aFrame.getHeight() + insets.top + insets.bottom + 20);
                aFrame.setLocation((screenSize.width-aFrame.getWidth())/2,(screenSize.height-aFrame.getHeight())/2);
                aFrame.show();
            }
            else{
                JasperManager.printReport(aPrint, true);
            }

[Ilja Preuss]

Basically, you need to either
- pass your data as parameters to the report (if they are just a few simple values),
- pass your report a jdbc connection and specify a query in the report xml, or
- pass your report a JRDataSource

[vijaykumar shah]

Hello,
So i am clearing the perspective of my approach to write this program and asking the question,
What i need is At Run time a report should be created and The report design should also be made at run time and depending on the dynamic results i.e query results the columns and its data should be shown in run time
so it s all together a Complete Dynamic report
So there are few confusions in the code ..
First is what is "aData"
Next is "HashToArraySorter"
Then "NextvaluePair"
Then "Value"
so either provide me with these classes and methods or put the functionality of the same here in the same code..
So for example u can take a Microsoft Access as a database
create a table "personal"
add columns id , name , address , designation , joindate
Now i want to display a report with
Header/title: Personal Data Information
Then below will be the details
ID Name Address Designation JoinDate
1 Vijay Sharjah Software Engineer 12-12-2003
and like wise ..
so in future i would get the records depending on date so let's say i want user from 1-1-2002 till 1-12-2003 so i will get the two parameters from the user and execute the query and show the results..
Now let's say the table in future get's too complex where in the address is not accessible to a user who is making the report ... so when i create a report i would first check what are the user rights and then depending on it i will create the columns and then display the report to the user...
so i guess this would make more clear..
Next thing i wanted to ask is "Do i need to create a .jasper file before executing the program"
Below is the code...along with the error list
You can also modify the code and let me know

import java.io.*;
import java.sql.*;
import javax.swing.*;
import dori.jasper.view.*;
import dori.jasper.engine.*;
import java.util.*;
//import 
class jasperexample 
{
public static void main(String[] args) 
{
System.out.println("Hello World! for Jasper Example");
try
{
//getting the database connnection
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
            Connection con1 = DriverManager.getConnection("jdbc  :-o	  dbc:Vijaytest","","");
            Statement s1 = con1.createStatement();
// To fill the report, first you need an instance of JRDataSource and a Map (possibly empty) of any params you use. Then: 
java.util.Map parameters = new java.util.HashMap();
// To load the .jasper file: 
JasperReport template = JasperManager.loadReport(new FileInputStream("c:\\REPOST1.jasper")); 
java.util.Map reportParameters = HashToArraySorter.mapify(template.getParameters(),"getName");
while(parameterList.hasNext())
{
NameValuePair aPair = (NameValuePair)parameterList.next();
String parameterName = (String)aPair.getNameObject();
Value aValue = (Value)aPair.getValueObject();
JRParameter aReportParameter = (JRParameter)reportParameters.get(parameterName);
Class expectedClass = aReportParameter.getValueClass();
Object parameterValue = aValue.getValueAs(expectedClass);
parameters.put(parameterName, parameterValue);
}
//create the report 

JasperPrint report = JasperManager.fillReport(template, parameters, con1);
report.setCopies("1");
//To show the reoprt, create a JRViewer and stick it in a dialog: 
JRViewer jrv = new JRViewer(report); 
JFrame aFrame = new JFrame("First Example Report Viewer");
aFrame.getContentPane().add(jrv);
java.awt.Dimension screenSize = java.awt.Toolkit.getDefaultToolkit().getScreenSize();
aFrame.setSize(screenSize.width/2, screenSize.height/2);
java.awt.Insets insets = aFrame.getInsets();
aFrame.setSize(aFrame.getWidth() + insets.left + insets.right, aFrame.getHeight() + insets.top + insets.bottom + 20);
aFrame.setLocation((screenSize.width-aFrame.getWidth())/2,(screenSize.height-aFrame.getHeight())/2);
aFrame.show();
JDialog viewer = new JDialog(); 
viewer.setTitle("Viewer"); 
viewer.getContentPane().add(jrv); 
viewer.pack(); 
viewer.show(); 
}
catch(Exception ex)
{
ex.printStackTrace();
}
}
}

---------- Compile ----------
jasperexample.java:29: cannot resolve symbol
symbol  : variable HashToArraySorter 
location: class jasperexample
java.util.Map reportParameters = HashToArraySorter.mapify(template.getParameters(),"getName");
                                                         ^
jasperexample.java:31: cannot resolve symbol
symbol  : variable parameterList 
location: class jasperexample
while(parameterList.hasNext())
                              ^
jasperexample.java:33: cannot resolve symbol
symbol  : class NameValuePair 
location: class jasperexample
NameValuePair aPair = (NameValuePair)parameterList.next();
                                ^
jasperexample.java:33: cannot resolve symbol
symbol  : class NameValuePair 
location: class jasperexample
NameValuePair aPair = (NameValuePair)parameterList.next();
                                                       ^
jasperexample.java:33: cannot resolve symbol
symbol  : variable parameterList 
location: class jasperexample
NameValuePair aPair = (NameValuePair)parameterList.next();
                                                                     ^
jasperexample.java:35: cannot resolve symbol
symbol  : class Value 
location: class jasperexample
Value aValue = (Value)aPair.getValueObject();
                                ^
jasperexample.java:35: cannot resolve symbol
symbol  : class Value 
location: class jasperexample
Value aValue = (Value)aPair.getValueObject();
                                                ^
jasperexample.java:47: cannot resolve symbol
symbol  : method setCopies (java.lang.String)
location: class dori.jasper.engine.JasperPrint
report.setCopies("1");
                              ^
8 errors
Output completed (1 sec consumed) - Normal Termination

--Edited to add CODE tags JAM
[ December 23, 2003: Message edited by: Joel McNary ]

[Joel McNary]

Sorry - those classes that you have questions about are classes that I wrote. As I said, you will need to modify that code to suit your needs. Basically, aData contains information on how to run a report, HashToArraySorter convertes between an array and a Map, and aValue is a generic Value that will hold any type of data (any primitive or Object). What you should do is use that code as a template for your code, not as the actual code itself.
What Ilja said is accurate: what you want to do is first build the report to report of a database/JRDataSource/whatever (I personally use iReport to do this), compile the report into a .jasper file.
Then in your application you should load that .jasper file and pass it any paramters as needed (use the above code as a template on how to do that).
Finally, print the report.
Judging from what you want to do with allowing different users to see different columns on the report, you have three options. IN terms of least complex to most complex, they are:
1). Create different reports for different users. Use application-level security to control which report which user can run.
2). Create 1 report that takes as a parameter the security level. That report then can have logic that suppresses columns based on that security level.
3). Dynamically build a report. This is not recommended, as it can be quite complex. The simple way to do this is to build the report as XML, compile the report into a .jasper file, run the report, and then (optionally) delete that .jasper file. There may be a more complex way through the Jasper API (I know that this functionality exists in Crystal Reports' C API, although Crystal is not overly Java-friendly), but I do not know of it.
At any rate, this is not really a question relating to a SUN-provided API, so I'm moving this to our Other Open Source Projects forum.
[ December 23, 2003: Message edited by: Joel McNary ]