Element type "chartLegend" must be declared

[karthika Rangasamy]

Hi,

I create a reports in pdf in chart view using ireport1.3.3.i have created jrxml using ireport then i call this jrxml in code i got error.

package Com.PeopleTech;

import java.io.IOException;
import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.Statement;
import java.text.SimpleDateFormat;
import java.util.Date;
import java.util.HashMap;
import java.util.Map;

import javax.servlet.ServletException;
import javax.servlet.ServletOutputStream;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import org.springframework.web.servlet.ModelAndView;
import org.xml.sax.SAXParseException;
import net.sf.jasperreports.engine.JRResultSetDataSource;
import net.sf.jasperreports.engine.JasperCompileManager;
import net.sf.jasperreports.engine.JasperPrint;
import net.sf.jasperreports.engine.JasperReport;
import net.sf.jasperreports.engine.JasperRunManager;
import net.sf.jasperreports.engine.design.JasperDesign;
import net.sf.jasperreports.engine.xml.JRXmlLoader;

/**
 * Servlet implementation class for Servlet: AgentProductivityPdf
 *
 */
 public class AgentProductivityPdf extends javax.servlet.http.HttpServlet implements javax.servlet.Servlet
 {
   static final long serialVersionUID = 1L;
   protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException 
	{
		
		JasperReport jasperReport;
		JasperPrint jasperPrint;
		Map parameters = new HashMap();
		JRResultSetDataSource obj;
		
		
		System.out.println("inside the Agent productivity report in PDF..............................");
		String camp1=request.getParameter("camp_name");
		String f_date=request.getParameter("fdate");
		String t_date=request.getParameter("tdate");
		System.out.println("inside the Agent Productivity pdf page.");
		System.out.println("From date  "+f_date);
		System.out.println("Todate      "+t_date);
		System.out.println("Campaign Name"+camp1);
		
		FDDBDataSource fdb = new FDDBDataSource();
	  	Connection conn = fdb.getConnection();
	  	
	  	String loggedintime;
		String firstlogintime= null;
		String lastlogouttime= null;
		String breaktime = null;
		String loggenintime= null;
		String nosession= null;
		String agenttalktime= null;
		String Answeredcalls = null;
		Integer loggedintime1;
		Integer slno1=0;
		String waitingtime= null;
		
		String talktime="0";
		String totalloggenintime="0";
		String totalbreaktime="0";
		Integer agentcount=0;
		ResultSet rsuser=null;
		ResultSet rsproduct=null;
		ResultSet rsTalktime=null;
		ResultSet rscal=null;
		Integer logcount=0;
		Integer logcount1=0;
		
		Statement stproduct1=null;
		Statement stproduct2=null;
		Statement stproduct3=null;
		Statement stproduct4=null;
        String agentname=null;
		  System.out.println("******** Inside the  AgentProductivity PDF Report *********");
		  try
			  {
				String tdate=null;
				String fdate=null;
				
				//System.out.println("campaign----" + campaign);
				//System.out.println("user----" + user);
				System.out.println("fdate----" + f_date);
				System.out.println("tdate----" + t_date);
				
				
				String[] spa=f_date.split("-");
			  	System.out.println("vvvvvvvvv"+spa[0]);
			  	System.out.println("aaaaaaaaaaaaa"+spa[1]);
			  	System.out.println("nnnnnnnnnnnn"+spa[2]);
			  	
				String[] spa1=spa[2].split(" ");
				System.out.println("ppppppppppppppppp"+spa1[0]);
				System.out.println("ppppppppppppppppp"+spa1[1]);
				
				String[] spa2=spa1[1].split(":");
				System.out.println("rrrrrrrrrrrrrrrrrr"+spa2[0]);
				System.out.println("aaaaaaaaaaaaaaaaa"+spa2[1]);
				System.out.println("bbbbbbbbbbbbbbbbbbbb"+spa2[2]);
				
				
				
				
				
				 if(spa2[0].equals("12"))
				    {
					System.out.println("equaltoooooooooooooooooooooooooo1222222222222222");
					
					SimpleDateFormat sdfdest112 = new SimpleDateFormat("dd-MM-yyyy");
					Date fdate112 = sdfdest112.parse(f_date);
				    //frontdate = sdfdest112.format(fdate112);
					
					SimpleDateFormat sdfdest113 = new SimpleDateFormat("yyyy-MM-dd");
					String fdate12 = sdfdest113.format(fdate112);
				
					
					
					System.out.println("t_datet_datet_datet_datet_date"+t_date);
					String hha12=spa2[0];
					System.out.println("12hhhhhhhhhhh"+hha12);
					String mma12=spa2[1];
					String ssa12=spa2[2];
					
					String hoursminseca=hha12+":"+mma12+":"+ssa12;
					System.out.println("hourssssssssssssssmmmmmmmmmmmmiiiiiiiiiiiiiiiinnnnnnnssssssssssseccc"+hoursminseca);
					
					
				    fdate=fdate12+" "+hoursminseca;
					System.out.println("coreectoutputvalueeeeeeeeeeeeeeeeeeeeeeeeeeeee"+fdate);
					
					
					
					
					   
				    }
				    else
				     {
				    	
				    	System.out.println("noteqqqqqqqqqqqqqqqqqqqqqquuuuuuuuuuuuuuto 122222222222222222222");
				    	
				    	SimpleDateFormat sdfSource = new SimpleDateFormat("dd-MM-yyyy hh:mm:ss");
						Date fromdate = sdfSource.parse(f_date);
						System.out.println("fromdatefromdatefromdate"+fromdate);
						/*Date todate = sdfSource.parse(t_date);
						System.out.println("todatetodatetodatetodatetodate"+todate);*/
						SimpleDateFormat sdfdest = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
					    fdate = sdfdest.format(fromdate);
					 	System.out.println("fdateyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyy"+fdate);
				     }
				  	
				
				
				
				
				String[] sp=t_date.split("-");
			  	System.out.println("vvvvvvvvv"+sp[0]);
			  	System.out.println("aaaaaaaaaaaaa"+sp[1]);
			  	System.out.println("nnnnnnnnnnnn"+sp[2]);
			  	
				String[] sp1=sp[2].split(" ");
				System.out.println("ppppppppppppppppp"+sp1[0]);
				System.out.println("ppppppppppppppppp"+sp1[1]);
				
				String[] sp2=sp1[1].split(":");
				System.out.println("rrrrrrrrrrrrrrrrrr"+sp2[0]);
				System.out.println("aaaaaaaaaaaaaaaaa"+sp2[1]);
				System.out.println("bbbbbbbbbbbbbbbbbbbb"+sp2[2]);
				
			    if(sp2[0].equals("12"))
			    {
				System.out.println("equaltoooooooooooooooooooooooooo1222222222222222");
				
				SimpleDateFormat sdfdest112 = new SimpleDateFormat("dd-MM-yyyy");
				Date tdate112 = sdfdest112.parse(t_date);
				
				SimpleDateFormat sdfdest113 = new SimpleDateFormat("yyyy-MM-dd");
				String tdate12 = sdfdest113.format(tdate112);
				
				
				System.out.println("t_datet_datet_datet_datet_date"+t_date);
				String hh12=sp2[0];
				System.out.println("12hhhhhhhhhhh"+hh12);
				String mm12=sp2[1];
				String ss12=sp2[2];
				
				String hoursminsec=hh12+":"+mm12+":"+ss12;
				System.out.println("hourssssssssssssssmmmmmmmmmmmmiiiiiiiiiiiiiiiinnnnnnnssssssssssseccc"+hoursminsec);
				
				
			    tdate=tdate12+" "+hoursminsec;
				System.out.println("coreectoutputvalueeeeeeeeeeeeeeeeeeeeeeeeeeeee"+tdate);
			    }
			    else
			     {
			    	
			    	System.out.println("noteqqqqqqqqqqqqqqqqqqqqqquuuuuuuuuuuuuuto 122222222222222222222");
			    	
			    	SimpleDateFormat sdfSource = new SimpleDateFormat("dd-MM-yyyy hh:mm:ss");
			    	Date todate = sdfSource.parse(t_date);
					System.out.println("todatetodatetodatetodatetodate"+todate);
			    	SimpleDateFormat sdfdest = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
					
				    tdate = sdfdest.format(todate);
					System.out.println("tdateyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyy"+tdate);
			    	
				
			     }
			  	
			
			
			    SimpleDateFormat sdfSource = new SimpleDateFormat("dd-MM-yyyy hh:mm:ss");
				Date fr = sdfSource.parse(f_date);
				

				
				SimpleDateFormat sdfdest1 = new SimpleDateFormat("dd-MM-yyyy");
				String displaydate = sdfdest1.format(fr);
			    System.out.println("showinnnnnnnnnnnnnnnnnnnnnnnnnnnnn"+displaydate);
			    
			  
				Statement tempst=conn.createStatement();
				Statement st34=conn.createStatement();
				Statement tempcreate=conn.createStatement();
				String campaign="cc_"+camp1;
			    
			    
				String query34="DROP table IF EXISTS `temp_prodpdf`";
				st34.executeUpdate(query34);
				System.out.println("Successfully erase the temp_prodpdf before create");
				
				tempcreate.executeUpdate("CREATE TABLE temp_prodpdf (Username varchar(30),Campaignname varchar(30),Logintime varchar(30),Logouttime varchar(30),Nosession INT,Totalloggedintime varchar(30),Talktime varchar(30),Answewredcalls INT)");
				System.out.println("Successfully temp_prodpdf TAble created");	
			  
			     stproduct1=conn.createStatement();
				 stproduct2=conn.createStatement();
				 stproduct3=conn.createStatement();
				 stproduct4=conn.createStatement();
			  
				String query1="select username from cc_user";		 
		    	rsuser = stproduct1.executeQuery(query1);
		    	
		    	
		    	while(rsuser.next())
				{
					agentname=(rsuser.getString("username"));
					System.out.println("username............."+agentname);
					
				    int talk1 = 0;
				    int talk = 0;
				    System.out.println("firstloggedintime");
				   
		    	
				try
				{
			
				 System.out.println("inside the Agent productivity report");
				
				 String queryproduct="SELECT count( distinct(logintime )) AS Total ,min(logintime),max(logouttime),TIME_TO_SEC(TIMEDIFF( max(logouttime),min(logintime) )) FROM cc_log WHERE logintime BETWEEN '"+ fdate +"' AND '"+ tdate +"' and campaignname='"+campaign+"' and username='"+agentname+"' GROUP BY username";
				 System.out.println(queryproduct);
				 rsproduct = stproduct2.executeQuery(queryproduct);
		    	
				  while(rsproduct.next())
					{
					
					  firstlogintime=rsproduct.getString("min(logintime)");	
					  System.out.println("firstlogintime........."+firstlogintime);
					  lastlogouttime=rsproduct.getString("max(logouttime)");	
					  System.out.println("lastlogouttime........."+lastlogouttime);
					 
					  loggenintime=rsproduct.getString("TIME_TO_SEC(TIMEDIFF( max(logouttime),min(logintime) ))");	
					  System.out.println("loggenintime in seconds........."+loggenintime);
					  
					  nosession=rsproduct.getString("Total");
					  System.out.println("number of session &&&&&&&&&&........."+nosession);
					  
					 
					  
						 if(firstlogintime==null || firstlogintime.equals("null"))
						 {
							 
							 firstlogintime="0";
							 System.out.println("firstlogintime@@@@@@@@@@@@@@@@@@"+firstlogintime);
							 
							 
						 }
						 else
						 {
						  
						 }
					
					    if(lastlogouttime==null || lastlogouttime.equals("null"))
						 {
							 
						  lastlogouttime="0";
							 System.out.println("logouttime@@@@@@@@@@@@@@@@@@"+ lastlogouttime);
							 
							 
						 }
						 else
						 {
						  
						 }
					  
					
		
					if (loggenintime==null || loggenintime.equals("null"))
					 {
						loggenintime="0";
						 System.out.println("firstlogintime@@@@@@@@@@@@@@@@@@"+loggenintime);
						 
						 
					 }
					 else
					   {
						 int loggenintime1=Integer.parseInt(loggenintime); 
					     int loggeninhours = loggenintime1/ 3600,
						    loggeninremainder = loggenintime1 % 3600,
						    loggeninminutes = loggeninremainder / 60,
						    loggeninseconds = loggeninremainder % 60;

							String loggenindisHour = (loggeninhours < 10 ? "0" : "") + loggeninhours,
							loggenindisMinu = (loggeninminutes< 10 ? "0" : "") + loggeninminutes ,
							loggenindisSec = (loggeninseconds < 10 ? "0" : "") + loggeninseconds ;

							System.out.println(loggenindisHour +":"+ loggenindisMinu+":"+loggenindisSec);
							loggenintime=loggenindisHour +":"+ loggenindisMinu+":"+loggenindisSec;
							String logintime=loggenintime;
						
							System.out.println("loggenintime...................."+loggenintime);
					
					 
					   } 
					   String queryTalktime="SELECT count(*) as total,sum( TIME_TO_SEC( TIMEDIFF( endtime, starttime ) ) ) FROM cc_callback WHERE starttime BETWEEN '"+ fdate +"' AND '"+ tdate +"' and endtime!=0 and starttime<=endtime and username='"+agentname+"' and campaignname='"+campaign+"' GROUP BY username";
					    System.out.println(queryTalktime);
					    rsTalktime = stproduct3.executeQuery(queryTalktime);
					
						if(rsTalktime.next())
						{
							String queryTalktime1="SELECT count(*) as total,sum( TIME_TO_SEC( TIMEDIFF( endtime, starttime ) ) ) FROM cc_callback WHERE starttime BETWEEN '"+ fdate +"' AND '"+ tdate +"' and endtime!=0 and starttime<=endtime and username='"+agentname+"' and campaignname='"+campaign+"' GROUP BY username";
							 System.out.println("queryTalktime$$$$$$$$$$$$$$"+queryTalktime1);
							 Statement stproduct7=conn.createStatement();
							 ResultSet rsTalktime1 = stproduct7.executeQuery(queryTalktime1);
						     
				     
						while(rsTalktime1.next())
						{
						  System.out.println("queryTalktime..............");
						  agenttalktime=rsTalktime1.getString("sum( TIME_TO_SEC( TIMEDIFF( endtime, starttime ) ) )");	
						  System.out.println("talktime........."+agenttalktime);
						  
						  Answeredcalls=(rsTalktime1.getString("total"));
					      System.out.println("Total calls........."+Answeredcalls);
						
						 int agentcount1=Integer.parseInt(agenttalktime); 
							  
						 int hours = agentcount1/ 3600,
						 remainder = agentcount1 % 3600,
						 minutes = remainder / 60,
						 seconds = remainder % 60;

						String disHour = (hours < 10 ? "0" : "") + hours,
						disMinu = (minutes < 10 ? "0" : "") + minutes ,
						disSec = (seconds < 10 ? "0" : "") + seconds ;

						System.out.println(disHour +":"+ disMinu+":"+disSec);
						agenttalktime=disHour +":"+ disMinu+":"+disSec;
						System.out.println("agenttalktime...................."+agenttalktime);
						
						  }
			
				       }
						
						else
						   {
							System.out.println(agentname+"mmmmmmmmmmmmmmmmmm not talktime");
							agenttalktime="0";
							System.out.println("agenttalktime nonoooooooooooo"+agenttalktime);
							Answeredcalls="0";
							System.out.println("answeredcalls noooooooooooooooooooooo"+Answeredcalls);  
						    }
						tempst.executeUpdate("Insert into temp_prodpdf values('"+ agentname +"','"+ campaign +"','"+ firstlogintime +"','"+ lastlogouttime +"','"+ nosession +"','"+ loggenintime+"','"+agenttalktime+"','"+ Answeredcalls +"')");
			            System.out.println("insert the values successfully....."+ agentname +"','"+ campaign +"','"+ firstlogintime +"','"+ lastlogouttime +"','"+ nosession +"','"+ loggenintime+"','"+agenttalktime+"','"+ Answeredcalls +"')");
					}
				   
		
				}
				
				catch (Exception e)
				{
					e.printStackTrace();
				}
				   
			    }
		    	
		    	    Statement tempselectvalues=conn.createStatement();
					String tempselect="select * from temp_prodpdf";
					ResultSet rs3 = tempselectvalues.executeQuery(tempselect);
					System.out.println("tempselect&&&&&&&&&&&&&&&&&&&&"+tempselect);
					obj = new JRResultSetDataSource(rs3);					 
					
			        System.out.println("getting the values&&&&&&&&&&&&&&&&&&&&^^^^^^^^^^");
				    JasperDesign design = JRXmlLoader.load("C:\\jrxmlreports1\\Agentprod.jrxml");
				   // JasperDesign design = JRXmlLoader.load("/usr/tmp/report/Agentprod.jrxml");
					System.out.println("mapping@@@@@@@@@@@@@@@@^^^^^^^^^^^^^^&&&&&&&&&&&&&&&&&&&&^^^^^^^^^^");
					jasperReport = JasperCompileManager.compileReport(design);
					Statement st21=conn.createStatement();
					parameters.put("campaign", camp1);
					//parameters.put("fdate", fdate1);
					//parameters.put("tdate", tdate1);
					byte[] bytes = JasperRunManager.runReportToPdf(jasperReport,parameters,obj);
					response.setContentType("application/pdf");
					System.out.println(" pdf process++++++++++++++++++++++++++++++++++++++++++");
				    response.setContentLength(bytes.length);
					ServletOutputStream ouputStream = response.getOutputStream();
					ouputStream.write(bytes, 0, bytes.length);
					ouputStream.flush();
					ouputStream.close();
					System.out.println("completed pdf process!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!");
		    
			}
			
			
		  catch (Exception e1)
			{
				e1.printStackTrace();
			}
			

	   }
  
 }

org.xml.sax.SAXParseException: Element type "chartLegend" must be declared.
at com.sun.org.apache.xerces.internal.util.ErrorHandlerWrapper.createSAXParseException(Unknown Source)
at com.sun.org.apache.xerces.internal.util.ErrorHandlerWrapper.error(Unknown Source)
at com.sun.org.apache.xerces.internal.impl.XMLErrorReporter.reportError(Unknown Source)
at com.sun.org.apache.xerces.internal.impl.XMLErrorReporter.reportError(Unknown Source)
at com.sun.org.apache.xerces.internal.impl.dtd.XMLDTDValidator.handleStartElement(Unknown Source)
at com.sun.org.apache.xerces.internal.impl.dtd.XMLDTDValidator.startElement(Unknown Source)
at com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImpl.scanStartElement(Unknown Source)
at com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImpl$FragmentContentDriver.next(Unknown Source)
at com.sun.org.apache.xerces.internal.impl.XMLDocumentScannerImpl.next(Unknown Source)
at com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImpl.scanDocument(Unknown Source)
at com.sun.org.apache.xerces.internal.parsers.XML11Configuration.parse(Unknown Source)
at com.sun.org.apache.xerces.internal.parsers.XML11Configuration.parse(Unknown Source)
at com.sun.org.apache.xerces.internal.parsers.XMLParser.parse(Unknown Source)
at com.sun.org.apache.xerces.internal.parsers.AbstractSAXParser.parse(Unknown Source)
at com.sun.org.apache.xerces.internal.jaxp.SAXParserImpl$JAXPSAXParser.parse(Unknown Source)
at org.apache.commons.digester.Digester.parse(Digester.java:1745)
at net.sf.jasperreports.engine.xml.JRXmlLoader.loadXML(JRXmlLoader.java:238)
at net.sf.jasperreports.engine.xml.JRXmlLoader.loadXML(JRXmlLoader.java:225)
at net.sf.jasperreports.engine.xml.JRXmlLoader.load(JRXmlLoader.java:213)
at net.sf.jasperreports.engine.xml.JRXmlLoader.load(JRXmlLoader.java:167)
at net.sf.jasperreports.engine.xml.JRXmlLoader.load(JRXmlLoader.java:151)
at Com.PeopleTech.AgentProductivityPdf.doPost(AgentProductivityPdf.java:418)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:849)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:454)
at java.lang.Thread.run(Unknown Source)

please help me to solve this issue.
thankyou.