Error while exporting to PDF using Jasper Report

Dear Ranchers,

I am trying to export a report in pdf document using jasper report. I got the code from some sites while searching in the google search engine. Attached here with the following files

<%@ page import="java.io.*"%>
<%@ page import="java.util.*"%>
<%@ page import="net.sf.jasperreports.engine.JRException"%>
<%@ page import="net.sf.jasperreports.engine.JasperCompileManager"%>
<%@ page import="net.sf.jasperreports.engine.JasperExportManager" %>
<%@ page import="net.sf.jasperreports.engine.JasperFillManager" %>
<%@ page import="net.sf.jasperreports.engine.JasperPrint" %>
<%@ page import="net.sf.jasperreports.engine.JasperReport" %>
<%@ page import="net.sf.jasperreports.engine.data.JRXmlDataSource"%>
<%@ page import="net.sf.jasperreports.engine.data.*"%>
<%@ page import="net.sf.jasperreports.engine.JRParameter" %>
<%@ page import="java.sql.Connection"%>
<%@ page import="java.sql.DriverManager"%>
<%!
public static boolean printReport(HttpServletResponse response)
{	JasperReport jr = null ;
	JasperPrint jp = null ;
	boolean error = true ;
	try 
	{	long start = 0 ;
		response.reset() ;
		response.setContentType("application/pdf"); 
		start = System.currentTimeMillis(); 
		Class.forName("com.mysql.jdbc.Driver");
		System.out.println("Aravind1");
		String url = "jdbc:mysql:///roadfreighters";
		Connection connection = DriverManager.getConnection(url,"root","");
		InputStream is = Class.forName("com.mysql.jdbc.Driver").getResourceAsStream("Y://LOGO//report1.jrxml"); 
		System.out.println("Sunitha __________________________________"+is);
		System.out.println("welcome");
		if (is == null)
			System.out.println("is is null") ;
		else
			System.out.println("is not null");
		System.out.println("Before Fill Report") ;
		jp=JasperFillManager.fillReport(is, new HashMap(), connection) ;
		System.err.println("Filling time : " + (System.currentTimeMillis() - start)+" msec");
		start = System.currentTimeMillis(); 
		java.io.OutputStream outputStream = response.getOutputStream() ;
		JasperExportManager.exportReportToPdfStream(jp, outputStream);
		System.err.println("Export to pdf time : " + (System.currentTimeMillis() - start)+" msec");
		error = false ;
	} 
	catch (JRException e1) 
	{	e1.printStackTrace();
	}
	catch (IOException ioe) 
	{	System.out.println(ioe);
		ioe.printStackTrace() ;
	}
	catch (Exception cnf)
	{	cnf.printStackTrace() ;
	}
	return error ;
} 
String output="";
boolean error = printReport(response) ;
if(error) 
{	output ="Encountered Error while running report." ;
%>
<html>
<head>
<title>Jasper Report Demo</title>
</head>
<body bgcolor="#8C92C6">
<center>
<font color="white"> <h2> <%=output%></h2></font>
</center>
</body>
</html>
<%
}
%>

Below is the error messgae i am getting from the system

HTTP Status 500 -

--------------------------------------------------------------------------------

type Exception report

message

description The server encountered an internal error () that prevented it from fulfilling this request.

exception

org.apache.jasper.JasperException: Unable to compile class for JSP:

An error occurred at line: 57 in the jsp file: /LOGO/test.jsp
response cannot be resolved
54: 	return error ;
55: } 
56: String output="";
57: boolean error = printReport(response) ;
58: if(error) 
59: {	output ="Encountered Error while running report." ;
60: %>

An error occurred at line: 58 in the jsp file: /LOGO/test.jsp
Syntax error on token "if", invalid AnnotationName
55: } 
56: String output="";
57: boolean error = printReport(response) ;
58: if(error) 
59: {	output ="Encountered Error while running report." ;
60: %>
61: <html>

An error occurred at line: 59 in the jsp file: /LOGO/test.jsp
Syntax error, insert "}" to complete Block
56: String output="";
57: boolean error = printReport(response) ;
58: if(error) 
59: {	output ="Encountered Error while running report." ;
60: %>
61: <html>
62: <head>

An error occurred at line: 72 in the jsp file: /LOGO/test.jsp
Syntax error, insert "Finally" to complete TryStatement
69: </body>
70: </html>
71: <%
72: }
73: %>

An error occurred at line: 131 in the generated java file
Syntax error on token "catch", Identifier expected

An error occurred at line: 133 in the generated java file
out cannot be resolved

An error occurred at line: 133 in the generated java file
_jspx_out cannot be resolved

An error occurred at line: 134 in the generated java file
out cannot be resolved

An error occurred at line: 135 in the generated java file
out cannot be resolved

An error occurred at line: 136 in the generated java file
_jspx_page_context cannot be resolved

An error occurred at line: 138 in the generated java file
Syntax error on token "finally", { expected

An error occurred at line: 139 in the generated java file
_jspxFactory cannot be resolved

An error occurred at line: 139 in the generated java file
_jspx_page_context cannot be resolved

Stacktrace:
	org.apache.jasper.compiler.DefaultErrorHandler.javacError(DefaultErrorHandler.java:93)
	org.apache.jasper.compiler.ErrorDispatcher.javacError(ErrorDispatcher.java:330)
	org.apache.jasper.compiler.JDTCompiler.generateClass(JDTCompiler.java:435)
	org.apache.jasper.compiler.Compiler.compile(Compiler.java:298)
	org.apache.jasper.compiler.Compiler.compile(Compiler.java:277)
	org.apache.jasper.compiler.Compiler.compile(Compiler.java:265)
	org.apache.jasper.JspCompilationContext.compile(JspCompilationContext.java:564)
	org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:302)
	org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:329)
	org.apache.jasper.servlet.JspServlet.service(JspServlet.java:265)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:729)

note The full stack trace of the root cause is available in the Apache Tomcat/5.5.27 logs.

--------------------------------------------------------------------------------

Apache Tomcat/5.5.27

Please help me to rectify this problem

Regards

Aravind

Aravind,
First of all, note that it's horrible practice to have large chunks of code in a JSP. Good practice would have no code, but static methods are even worse. It makes debugging and maintenance very difficult.

In this particular case, the whole thing should be a servlet and there should be no JSP. After all, if you have a PDF, you shouldn't have HTML too. What would the browser do wit that?

Try copying that large method into a servlet and printing the result to the output.

Hi Jeanne

Thank you for your reply. I am very new to the Jasper Report and I would really appreciate, if i can get a real help of the code, which can able to export to pdf from jasper report.
This is really very urgent.

Thanks/aravind

Aravind Prasad wrote:This is really very urgent.

Please read this.

Jeanne Boyarsky wrote:Try copying that large method into a servlet and printing the result to the output.

Jeanne has already given you the next step.

Hi Ranchers,

Thankyou for your inputs. I could finally export the jasper report to PDF format. I have tested it OK.

I have now another problem for passing the parameter to jrxml file to create dynamic report. Every time, depending on the unique key, the report has to bring the information from the database.

Below is the XML code for the report and the the parameter which I am passing is file_no, which I am manipulating in the query.

The jrxml, compiled successfully but in the PDF it is not having any values. Please help me.

<?xml version="1.0" encoding="UTF-8"?>
<jasperReport xmlns="http://jasperreports.sourceforge.net/jasperreports" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://jasperreports.sourceforge.net/jasperreports http://jasperreports.sourceforge.net/xsd/jasperreport.xsd" name="fileCover" pageWidth="595" pageHeight="842" columnWidth="535" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20">
	<subDataset name="dataset1"/>
	<parameter name="SUBREPORT_DIR" class="java.lang.String" isForPrompting="false">
		<defaultValueExpression><![CDATA["c:\\Program Files\\Apache Software Foundation\\Tomcat 5.5\\webapps\\roadfreighters\\LOGO\\"]]></defaultValueExpression>
	</parameter>
	<parameter name="file_no" class="java.lang.String" isForPrompting="false"/>
	<queryString>
		<![CDATA[SELECT
     file_main.`file_no` AS file_main_file_no,
     file_main.`file_date` AS file_main_file_date,
     file_main.`file_type` AS file_main_file_type,
     client_profile.`client_code` AS client_profile_client_code,
     client_profile.`company_name` AS client_profile_company_name,
     client_profile.`addr1` AS client_profile_addr1,
     client_profile.`addr2` AS client_profile_addr2,
     client_profile.`addr3` AS client_profile_addr3,
     client_profile.`plot` AS client_profile_plot,
     client_profile.`pobox` AS client_profile_pobox,
     client_profile.`place` AS client_profile_place,
     ict_branch.`branch_name` AS ict_branch_branch_name,
     client_profile.`phone` AS client_profile_phone,
     client_profile.`fax` AS client_profile_fax,
     client_profile.`contact1` AS client_profile_contact1,
     file_cargo.`client_ref` AS file_cargo_client_ref,
     file_cargo.`cargo_type` AS file_cargo_cargo_type,
     file_cargo.`container_size` AS file_cargo_container_size,
     file_cargo.`weight` AS file_cargo_weight,
     file_cargo.`volume` AS file_cargo_volume,
     file_cargo.`cargo_desc` AS file_cargo_cargo_desc,
     file_cargo.`units` AS file_cargo_units,
     file_main.`client_name` AS file_main_client_name,
     file_main.`file_owner` AS file_main_file_owner,
     ict_country.`country_name` AS ict_country_country_name,
     login_details.`firstname` AS login_details_firstname,
     login_details.`lastname` AS login_details_lastname
FROM
     `client_profile` client_profile INNER JOIN `file_main` file_main ON client_profile.`client_code` = file_main.`client_id`
     INNER JOIN `ict_country` ict_country ON client_profile.`country` = ict_country.`country_id`
     INNER JOIN `ict_branch` ict_branch ON client_profile.`city` = ict_branch.`branch_id`
     INNER JOIN `file_cargo` file_cargo ON file_main.`file_no` = file_cargo.`file_no`
     INNER JOIN `login_details` login_details ON file_main.`file_owner` = login_details.`user_id`
WHERE
[b]    'file_main'.'file_no'='<![$P{file_no}]>'[/b]
GROUP BY
     file_main.`file_no`]]>
	</queryString>

Aravind