run jrxml file with jsp

[shanmukhi]

Hi All,

i have written a code to run jrxml file from jsp page...
but im not able to run the report
please check my code

 
 
<%@ page language="java" import="java.util.*,java.sql.Connection,java.sql.ResultSet,java.sql.Statement" %>
<%@ page import="java.sql.*,net.sf.jasperreports.view.JasperViewer,net.sf.jasperreports.engine.xml.JRXmlLoader,
 net.sf.jasperreports.engine.JasperCompileManager,net.sf.jasperreports.engine.JasperFillManager,
 net.sf.jasperreports.engine.JasperPrint,net.sf.jasperreports.engine.design.JasperDesign,
 net.sf.jasperreports.engine.JasperReport"%>
<%@ page import="com.systeam.ms.DbDetails,java.sql.DriverManager"%>
 
 
<%!
Connection con;
ResultSet rs;
String query;
String ReportName;
String path="Reports/";
String ReportFile;
%>
 
<%
 //response.setContentType("application/pdf"); 
try{
 
con=DbDetails.getConnection();
query="select distinct FILENAME  from rpt_reportsform where 
TITLE_LOC='Access Control Group/Forms'";
rs=DbDetails.getRS(query,con);
 
while(rs.next())
{
 //rs returns only single record here that is report1.jrxml
 
String ReportName = rs.getString("FILENAME");
 //here the ReportFile returns the string  Reports/report1.jrxml.
 concatination is needed since Reports folder contains report1.jrxml file
ReportFile=path.concat(ReportName);
    }
 
try{
 
JasperDesign jasperDesign = JRXmlLoader.load(ReportFile);
JasperReport jasperReport = JasperCompileManager.compileReport(jasperDesign);
JasperPrint jasperPrint = JasperFillManager.fillReport(jasperReport, null,con);
System.out.println("run");
JasperViewer.viewReport(jasperPrint);  
//response.sendRedirect(ReportFile);
      }
      catch(Exception ex) {
         String connectMsg = "Could not create the report " + ex.getMessage() + " " + ex.getLocalizedMessage();
         out.println(connectMsg);
 
   }
 }}
catch(Exception e)
{
    out.print(e);
}  
 
%>
 
 
 

im not able to run that jrxml file. control is going to catch block since it is not taking the specified jrxml file path.

my application structure is like this

MSReports
|
V
pages
WEB-INF
Reports
|
V
report1.jrxml
report2.jrxml


can anybody help me please