Solved: JRC: NullPointerException

Former Member · ‎08-28-2008

Hi,

I m using the report viewer to display report in my JSP page. The report will take in some parameters which the user have to enter. After entering the parameters and clicking enter, i get a "java.lang.NullPointerException". Please help. Is there any additional steps i should do after the user enter the prameter? If so, how should i get the parameter the user enter? Thanks in advance.

Former Member · ‎09-01-2008

I know that you do not want to hard code the values. But I have a sample code that set the parameters' values and export (in batch). It works very well and you can refer to it to sort out your issue.

Here it is below:

<%

/* Applies to: XI 
* Date Created: March 25 2008
* Description: This sample Creates a reportClientDocument Instance
* then in a serial way set parameters and  exports a report to PDF using the Java Reporting Component
* (JRC) SDK.  
* It uses the ReportExportControl to export without viewing
*  It is a batch process that set a parameter and export to pdf serially
* Author: Alphonse Kouassi
*/

// 

final String EXPORT_FILE0 = "myExportedReport1.pdf";
final String EXPORT_FILE1 = "myExportedReport2.pdf";
final String EXPORT_FILE2 = "myExportedReport3.pdf";
final String EXPORT_LOC = "C:\\";


%>

<%
//Use the relative path to the report; the physical or full qualified URL cannot
// be used.



String reportName = "Java_JRC_CR115_Export_With-Parameters-Batch/Java_JRC_CR115_Export_With-Parameters-Batch.rpt";

//Database credentials for the report's datasource.
final String USERNAME = "system";
final String PASSWORD = "mutcho";


	try
	{
		        //---------- Create a ReportClientDocument -------------
		        
		        ReportClientDocument oReportClientDocument = new ReportClientDocument();
		        
		        //---------- Set the path to the location of the report soruce -------------
		
		        //Open report.
		        oReportClientDocument.open(reportName, 0);
		        
	ParameterFieldController parameterFieldController = oReportClientDocument.getDataDefController().getParameterFieldController();
	
	// Set the logon credentials of the database in case you might be prompted to do so
	oReportClientDocument.getDatabaseController().logon(USERNAME, PASSWORD);
		        	
//=======================================================================================
//           FIRST PROCESS OF SETTING THE FIRST PARAMETER AND EXPORT 

//=======================================================================================		        
		        	
		        
		          	parameterFieldController.setCurrentValue("", "ID", new String ("1"));
		          	
		 
	//Export report and obtain an input stream that can be written to disk.
	//See the Java Reporting Component Developer's Guide for more information on the supported export format enumerations
	//possible with the JRC.
	ByteArrayInputStream byteArrayInputStream = (ByteArrayInputStream)oReportClientDocument.getPrintOutputController().export(ReportExportFormat.PDF);
			

	
	//These utility methods below demonstrate how to use the Java I/O libraries to write the input stream content
	//directly to the browser, or the server's file system.  Note: We are now working with APIs completely outside of
	//Crystal at this point:  						
	//Write file to disk...
	String EXPORT_OUTPUT = EXPORT_LOC + EXPORT_FILE0;
	out.println("Exporting to " + EXPORT_OUTPUT +"<br>");
	writeToFileSystem(byteArrayInputStream, EXPORT_OUTPUT);
	
//=======================================================================================
//           SECOND PROCESS OF SETTING THE SECOND PARAMETER AND EXPORT 

//=======================================================================================
//Check to ensure the report using the most current data scheme from its database
 oReportClientDocument.verifyDatabase();
	
	parameterFieldController.setCurrentValue("", "ID",new String ("2"));
	oReportClientDocument.getDatabaseController().logon(USERNAME, PASSWORD);
		 
	//Export report and obtain an input stream that can be written to disk.
	//See the Java Reporting Component Developer's Guide for more information on the supported export format enumerations
	//possible with the JRC.
 byteArrayInputStream = (ByteArrayInputStream)oReportClientDocument.getPrintOutputController().export(ReportExportFormat.PDF);
			

	
	//These utility methods below demonstrate how to use the Java I/O libraries to write the input stream content
	//directly to the browser, or the server's file system.  Note: We are now working with APIs completely outside of
	//Crystal at this point:  						
	//Write file to disk...
    EXPORT_OUTPUT = EXPORT_LOC + EXPORT_FILE1;
	out.println("Exporting to " + EXPORT_OUTPUT +"<br>");
	writeToFileSystem(byteArrayInputStream, EXPORT_OUTPUT);
	
//=======================================================================================
//           THIRD PROCESS OF SETTING THE THIRD PARAMETER AND EXPORT 

//=======================================================================================
//Check to ensure the report using the most current data scheme from its database for updating the report

oReportClientDocument.verifyDatabase();

		parameterFieldController.setCurrentValue("", "ID", new String ("3"));
		 
	//Export report and obtain an input stream that can be written to disk.
	//See the Java Reporting Component Developer's Guide for more information on the supported export format enumerations
	//possible with the JRC.
 byteArrayInputStream = (ByteArrayInputStream)oReportClientDocument.getPrintOutputController().export(ReportExportFormat.PDF);
			
	
	//These utility methods below demonstrate how to use the Java I/O libraries to write the input stream content
	//directly to the browser, or the server's file system.  Note: We are now working with APIs completely outside of
	//Crystal at this point:  						
	//Write file to disk...
    EXPORT_OUTPUT = EXPORT_LOC + EXPORT_FILE2;
	out.println("Exporting to " + EXPORT_OUTPUT +"<br>");
	writeToFileSystem(byteArrayInputStream, EXPORT_OUTPUT);
	//===========================================================================================
		          	
	//Release report.
    oReportClientDocument.close();
    
	
	}
	catch(ReportSDKException ex) 
	{	
		out.println(ex);
	}
    catch(Exception ex) 
	{
		out.println(ex);			
	}

%>




<%!
   /*
	* Utility method that demonstrates how to write an input stream to the server's local file system.  
	*/
	private void writeToFileSystem(ByteArrayInputStream byteArrayInputStream, String exportFile) throws Exception 
	{
	
		//Use the Java I/O libraries to write the exported content to the file system.
		byte byteArray[] = new byte[byteArrayInputStream.available()];

		//Create a new file that will contain the exported result.
		File file = new File(exportFile);
		FileOutputStream fileOutputStream = new FileOutputStream(file);

		ByteArrayOutputStream byteArrayOutputStream = new ByteArrayOutputStream(byteArrayInputStream.available());
		int x = byteArrayInputStream.read(byteArray, 0, byteArrayInputStream.available());

		byteArrayOutputStream.write(byteArray, 0, x);
		byteArrayOutputStream.writeTo(fileOutputStream);

		//Close streams.
		byteArrayInputStream.close();
		byteArrayOutputStream.close();
		fileOutputStream.close();
		
	}
%>

ted_ueda · ‎08-28-2008

Hello Noel,

You have a JSP passing values from one place to another, and something that shouldn't be null is null.

Sincerely,

Ted Ueda

ps - you may want to describe your issue in greater detail.

Former Member · ‎08-28-2008

Hello Noel,

java.lang.nullpointerexception indicates that crystal is not getting expected values at run time.Since value is not getting correctly passed to crystal engine or nuull value is getting passed,then you can get above exception.

Please check following things at your end :

1)Parameter type set in designer and parameter which you are passing at run time should be same.

2)If you are using JDBC/ODBC connectivity, make sure that you have set environmental entries in web.xml file.

3)Make sure that parameters that you are passing should retrive some records from the database i.e Corrosponding data should be present in database for that range

Thanks,

Chinmay

JRC: NullPointerException

Accepted Solutions (1)

Accepted Solutions (1)

Answers (2)

Answers (2)

SAP Queries/Infoset Queries data import to SAC (SA...

Re: Table DDNTF is not active in the dictionary er...

Re: How to Unsubscribe the Subscription for SAP Cl...

Consuming on-Premise Service in CAP Project

Re: How can I save Requirement in Cloud ALM