Auto Report generation

[gr4nt4]

Hi All

 

I've have the following code (which is not mine) which should be able to create pdf and xl output from a command line.

 

Code:

/**
*   This module will allow Jasper Reports, desinged via iReport, to be executed
*   in batch mode. 
*   The module takes the following arguments:
*       1)  Run Mode - (V)iew Report, (F)ormat Report or (B«»)oth
*       2)  Report Name (Full Path)
*       3)  Output File Name (Full Path) Suffixc is used as File Format
*           (PDF, Excel ...etc)
*       *)  The database connection strings are set using the -D (sets the
*           properties dbase.x (driver, url,user, password)
*       Also, the promptable paramaters can now be placed on the command
*       line - so typically the args become 
*           [V|F|B] [Full Report Path] [Full Output Formatted Report Name]
*           [-DParamName1=Paramvalue -DParamName2=ParamValue ...etc]
*       ...Be wary here as the ParamNames need to have embedded spaces replaced
*       with ^ (as space in a -D property appears to mess up) - so to pass
*       a parameter of This Is The First Number and This Is The Last Number
*       you would enter:
*       -DThis^Is^The^First^Number=1 -DThis^Is^The^Last^Number=999
*       The reason for doing this is that it means the reports can be run
*       completely unattended. IE, assume that you have a report that is to
*       be scheduled to run every day with the first day of the month (but can
*       have any date passed to it). typically the report would be designed to
*       have a parameter of date that is promptable, but in reality you just
*       want to schedule it to run with a 'calculated' date. So a run script
*       can be set up that calculates the first day of the month, and then
*       passes that as a -D property to this runner - this runner will detect
*       that the date parameter has been passed on the command line, and will
*       not try to prompt for it. So you can have unattended running of 
*       'parameterised' reports.


// Include the main Jasper Reports Driver.....
import net.sf.jasperreports.engine.*;
import net.sf.jasperreports.view.*;
import java.sql.*;
import java.util.*;
import java.text.*;
import javax.swing.*;

public class JReportRunner {

    public static void main(String[] args) {
        int i =  0;

        String sourceFileName       = null;
        JasperReport compiledReport = null;
        JRParameter[] prompts       = null;
        String reportPath           = null;
        String outputFileName       = null;
        String outputFormat         = null;
        String runMode              = null;
        Map parameters              = new HashMap();
        OpenDatabase openDatabase   = null;
        JasperPrint outputReport    = null;
        String commandLineParamName = null;
        String paramName            = null;
        Class paramClass            = null;
        String paramClassName       = null;
        String paramValue           = null;
        int     paramInt            = 0;
        long    paramLong           = 0;
        short   paramShort          = 0;
        double  paramDouble         = 0;
        float   paramFloat          = 0;
        byte    paramByte           = 0;
        boolean commandLine         = false;
        java.util.Date paramDate    = null;
        DateFormat dateFormat       = DateFormat.getDateInstance(DateFormat.SHORT);

        // By default date entry is lenient - that means the 0/0/01 is valid
        // as is 99/99/9999 - the days get mapped to existing days ie - 0 in
        // a day is the last day of the preceding month  and 99 would be the
        // date in circa 3 months time ..... (why would anyone want
        // that? - anyway, that's how it does it) - so make sure lenient is
        // turned off
        dateFormat.setLenient(false);

        System.out.println("In Runner With Date Format ("+dateFormat+"«»)"«»);
        while (i < args.length) {
            System.out.print("Arg ("+i+"«») Is ("+args+"«») "«»);
            // Move the arguments into named variables 
            if (i == 0) {
                runMode         = args;
            }
            if (i == 1) {
                reportPath      = args;
            }
            if (i == 2) {
                outputFileName  = args;
            }
            i++;
        }
        System.out.println();

        // Split the outputfile name to get the suffix - as we'll use this
        // to decide which methods to use to export the file....
        i                   = outputFileName.lastIndexOf("."«»);
        outputFormat        = outputFileName.substring(i+1,outputFileName.length());

        // We need to know the parameters in the report, I can't see any other
        // way of getting to this info apart from 'dummy' compiling the report
        // - but to do that we'll need a pointer to the source .jrxml file
        i                   = reportPath.lastIndexOf("."«»);
        sourceFileName      = reportPath.substring(0,i+1)+"jrxml";

        try {
            compiledReport      = JasperCompileManager.compileReport(sourceFileName);
        }
        catch (JRException e) {
		    System.err.println("JReportRunner: Cannot Compile Report ("+
		                       sourceFileName+"«») "+e);
        }

        prompts         = compiledReport.getParameters();

        // Now we need to loop through the paramaters and prompt (if promptable)
        // for the values - we'll put the parameters into a separate hash map
        // The prog can also be run with the parameters passed on the command
        // line (via -D) - to enable a true batch process......
        JFrame jframe = new JFrame("Dialog"«»);
        for (i = 0;i < prompts.length;i++) {
            if (!prompts.isSystemDefined()) {
                paramName       = prompts.getName();
                // If passed on the command line, the parameter has spaces
                // replaced with ^, so From Claim No becomes From^Claim^No
                // (as spaces messes up the System Properties) - so create
                // a command line parameter from the main parameter, with ^
                // instead of embedded space.......
                commandLineParamName= paramName.trim(); 
                commandLineParamName= commandLineParamName.replaceAll(" ","^"«»);
                paramClass      = prompts.getValueClass();
                paramClassName  = prompts.getValueClassName();
                commandLine     = false;
                while (true) {
                    if (commandLine) {
                        // can't do owt else apart from abort here, as we're
                        // in 'unattended' mode (in theory)
		                System.err.println(
                            "JReportRunner: Command Line Parameter ("+
                            paramName+"«») Failed Validationn"+
                            "Value Set To ("+paramValue+"«»)"«»);
                        System.exit(1);    
                    }        
                    paramValue  = (System.getProperty(commandLineParamName));
                    if (paramValue == null) {
                        paramValue  =
                            JOptionPane.showInputDialog
                                    (jframe,
	                                 "Please Enter Value For "+
                                     paramName+" n "+paramClass,
                                     paramName+" (Type "+paramClassName+"«»)",
	                                 JOptionPane.QUESTION_MESSAGE);
                    }
                    else {
                        // This will be detected at the start of the loop,
                        // and if set means that a command line parameter
                        // failed validation - so we'll have to abort
                        commandLine = true;
                    }
                    if (paramClassName.endsWith("Integer"«»)) {
                        try {
                            paramInt    = Integer.parseInt(paramValue);
                        }
                        catch (NumberFormatException e) {
                            if (!commandLine){
		                        JOptionPane.showMessageDialog
                                        (jframe,
                                         "Invalid Input ("+
                                         paramValue+"«») "+e,
                                         "Invalid Integer Value",
                                         JOptionPane.ERROR_MESSAGE);
                            }             
                            continue;
                       }
                        parameters.put(paramName,new Integer(paramInt));
                    }
                    if (paramClassName.endsWith("Short"«»)) {
                        try {
                            paramShort  = Short.parseShort(paramValue);
                        }
                        catch (NumberFormatException e) {
                            if (!commandLine) {
		                        JOptionPane.showMessageDialog
                                        (jframe,
                                         "Invalid Input ("+
                                         paramValue+"«») "+e,
                                         "Invalid Short Value",
                                         JOptionPane.ERROR_MESSAGE );
                            }             
                            continue;
                        }
                        parameters.put(paramName,new Short(paramShort));
                    }
                    if (paramClassName.endsWith("Long"«»)) {
                        try {
                            paramLong   = Long.parseLong(paramValue);
                        }
                        catch (NumberFormatException e) {
                            if (!commandLine) {
		                        JOptionPane.showMessageDialog
                                        (jframe,
                                         "Invalid Input ("+
                                         paramValue+"«») "+e,
                                         "Invalid Long Value",
                                         JOptionPane.ERROR_MESSAGE );
                            }             
                            continue;
                        }
                        parameters.put(paramName,new Long(paramLong));
                    }
                    if (paramClassName.endsWith("Float"«»)) {
                        try {
                            paramFloat  = Float.parseFloat(paramValue);
                        }
                        catch (NumberFormatException e) {
                            if (!commandLine) {
		                        JOptionPane.showMessageDialog
                                        (jframe,
                                         "Invalid Input ("+
                                         paramValue+"«») "+e,
                                         "Invalid Float Value",
                                         JOptionPane.ERROR_MESSAGE );
                            }
                            continue;
                        }
                        parameters.put(paramName,new Float(paramFloat));
                    }
                    if (paramClassName.endsWith("Double"«»)) {
                        try {
                            paramDouble = Double.parseDouble(paramValue);
                        }
                        catch (NumberFormatException e) {
                            if (!commandLine){
		                        JOptionPane.showMessageDialog
                                        (jframe,
                                         "Invalid Input ("+
                                         paramValue+"«») "+e,
                                         "Invalid Double Value",
                                         JOptionPane.ERROR_MESSAGE );
                            }             
                            continue;
                        }
                        parameters.put(paramName,new Double(paramDouble));
                    }
                    if (paramClassName.endsWith("Byte"«»)) {
                        try {
                            paramByte = Byte.parseByte(paramValue);
                        }
                        catch (NumberFormatException e) {
                            if (!commandLine){
		                        JOptionPane.showMessageDialog
                                    (jframe,
                                     "Invalid Input ("+
                                     paramValue+"«») "+e,
                                     "Invalid Byte Value",
                                     JOptionPane.ERROR_MESSAGE );
                            }         
                            continue;
                        }
                        parameters.put(paramName,new Byte(paramByte));
                    }
                    if (paramClassName.endsWith("Date"«»)) {
                        try {
                            paramDate = (java.util.Date)dateFormat.parse(paramValue);
                        }
                        catch (ParseException e) {
                            if (!commandLine){
		                        JOptionPane.showMessageDialog
                                        (jframe,
                                         "Invalid Input ("+
                                         paramValue+"«»)n "+
                                         "Please Use Format (dd/mm/yy[yy])n"+e,
                                         "Invalid Date Value",
                                         JOptionPane.ERROR_MESSAGE );
                            }
                            continue;
                        }
                        parameters.put(paramName,paramDate);
                    }
                    if (paramClassName.endsWith("String"«»)) {
                        parameters.put(paramName,paramValue);
                    }
                    if (paramClassName.endsWith("Text"«»)) {
                        parameters.put(paramName,paramValue);
                    }
                    break;
                }
            }
        }

        // Set up the SQL connection via our old database open class (hope this
        // was left in a working state!)
        openDatabase    = new OpenDatabase("","","",""«»);

        // Fill the report.....
        try {
            outputReport    = JasperFillManager.fillReport(reportPath,
            		                                       parameters,
            		                                       openDatabase.connection);
        }
        catch (JRException e) {
		    System.err.println("JReportRunner: Cannot Fill Report ("+
		                       reportPath+"«») "+e);
        }

        if (runMode.equalsIgnoreCase("V"«») || runMode.equalsIgnoreCase("B"«»)){
            // Now preview the report using the printmanager class....
            try {
                JasperViewer.viewReport(outputReport);
            }
            // Did not compile, because viewReport does not throw this: catch (JRException e) {
            catch (Exception e) {
		        System.err.println("JReportRunner: Cannot View Report ("+
		                           reportPath+"«») "+e);
            }
        }

        // Finally DO something - we have the file format, so case the format
        // and call the respective processor......
        if (runMode.equalsIgnoreCase("F"«») || runMode.equalsIgnoreCase("B"«»)){
            try {
                if (outputFormat.equalsIgnoreCase("pdf"«»)) {
                    JasperExportManager.exportReportToPdfFile(outputReport,outputFileName);
                }
                else if (outputFormat.equalsIgnoreCase("html"«»)) {
                        JasperExportManager.exportReportToHtmlFile(outputReport,outputFileName);
                }
                else if (outputFormat.equalsIgnoreCase("xml"«»)) {
                        JasperExportManager.exportReportToXmlFile(outputReport,outputFileName,1==1);
                }
                else {
                    System.err.println("Invalid File Format: ("+outputFormat+"«»)"«»);
                }
            }
            catch (JRException e) {
		        System.err.println("JReportRunner: Cannot Create Export ("+
		                           outputFileName+"«») Type ("+outputFormat+"«») "+e);
            }
        }
    }
}

 

However I get the error

 

JReportRunner: Cannot Compile Report (C:DatajrunnerTest.jrxml) net.sf.

jasperreports.engine.JRException: Error compiling report java source files : C:

DatajrunnerUnnamed_1189149333642_675773.java

Exception in thread "main" java.lang.NullPointerException

at JReportRunner.main(JReportRunner.java:127)

 

When Running the command line

 

"java -classpath C:DataiReportsiReport-1.3.1libcommons-beanutils-1.7.jar;C:

DataiReportsiReport-1.3.1libcommons-collections-2.1.jar;C:DataiReportsiR

eport-1.3.1libcommons-digester-1.7.jar;C:DataiReportsiReport-1.3.1libcomm

ons-logging-1.0.2.jar;C:DataiReportsiReport-1.3.1libjasperreports-1.3.1.jar

;C:datajrunner JReportRunner F C:DatajrunnerTest.jasper c:anoutfile

.pdf -Ddbase.driversun.odbc.JdbcOdbcDrive -Ddbase.urlBBR -Ddbase.user

 

I've little knowlage of java and would appriciate any pointers you can give.

 

Many thanks in advance

[csbac]

Please try again to post the code of the JReportRunner class.

Sebastian

[gr4nt4]

Thanks I got the problem solved I found the missing jar file