onoboaits

I have the same error, i have a procedure that retrive a query. CALL usp_formulario_periodico($P{compania}, $P{identificacion}, $P{formulario}); The datasource is a MySql Connection, in IReport 5.6 there was work fine.

Grettings, My name is Omar, i have a trouble with my environment: 1.- XAMPP Server Ver. 5.5.34-0 2.- Web application in PHP developed with PHP Maker Ver. 12 3.- Report Developed with Jasper Ireport Ver. 5.6 The application is fine, y have an hyperlink that invoke a php script to show the report, but when i tried show this error: ----------------------------------------------------------------------------------------------------------------------------------------------------------------------- http://localhost:8081/hrmanager/jspr_resumen_ejecutivo.php?clave=0000000100000001RQ161101 ----------------------------------------------------------------------------------------------------------------------------------------------------------------------- Fatal error: Uncaught [[o:Exception]:"java.lang.Exception: ReferenceClass failed: new net.sf.jasperreports.engine.JasperCompileManager. Cause: java.lang.ClassNotFoundException: net.sf.jasperreports.engine.JasperCompileManager VM: 1.7.0_79@http://java.oracle.com/" at: #-10 org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1720) #-9 org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1571) #-8 java.lang.Class.forName0(Native Method) #-7 java.lang.Class.forName(Class.java:274) #-6 php.java.bridge.Util.classForName(Util.java:1518) #-5 php.java.bridge.JavaBridge.CreateObject(JavaBridge.java:445) #-4 php.java.bridge.Request.handleRequest(Request.java:444) #-3 php.java.bridge.Request.handleRequests(Request.java:500) #-2 php.java.bridge.http.ContextRunner.run(ContextRunner.java:145) #-1 php.java.bridge.ThreadPool$Delegate.run(ThreadPool.java:60) #0 http://localhost:8080/JavaBridge/java/Java.inc(232): java_ThrowExceptionProxyFactory->getProxy(5, 'java.lang.Class', 'T', false) # in http://localhost:8080/JavaBridge/java/Java.inc on line 195 -------------------------------------------------------------------------------------------------------------------------- This is the script that invoke the ireport -------------------------------------------------------------------------------------------------------------------------- <?php//Programa que realiza una consulta a la Base de Datos//Y compila un reporte JasperReport XML//Y lo presenta en pantalla con formato PDF//Llamando las libreriasrequire_once('http://localhost:8080/JavaBridge/java/Java.inc');require('../php-jru/php-jru.php');set_time_limit(0);//Capturo la variable Id$vId=$_GET['clave'];$vGrupo=substr($vId,0,8);$vEmpresa=substr($vId,8,8);$vRolCodigo=substr($vId,16,8);$SalidaReporte='C:/xampp/htdocs/tics/reports/rptResumExe.pdf';$ReporteJrXml='C:/xampp/htdocs/tics/reports/rptResumExe.jrxml';$ReportePDF = 'rptResumExe.pdf';$class = new JavaClass("java.lang.Class");$class->forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");$driverManager = new JavaClass("java.sql.DriverManager");$strUrl = "jdbc:sqlserver://localhostSQL2012X";$strDbUser = "sa";$strDbPassword = "XXXXX";$conn = $driverManager->getConnection("jdbc:sqlserver://localhostSQL2012X;databaseName=dbProduccion;username=sa;password=ONOBOAITS;");//$conn = $driverManager->getConnection($strUrl,$strDbUser,$strDbPassword);$compileManager = new JavaClass("net.sf.jasperreports.engine.JasperCompileManager");$report = $compileManager->compileReport(realpath($ReporteJrXml));$params = new Java("java.util.HashMap");$params->put("grupo",$vGrupo);$params->put("empresa",$vEmpresa);$params->put("rolcodigo",$vRolCodigo);$fillManager = new JavaClass("net.sf.jasperreports.engine.JasperFillManager");$jasperPrint = $fillManager->fillReport($report, $params, $conn);$exportManager = new JavaClass("net.sf.jasperreports.engine.JasperExportManager");$outputPath = realpath($SalidaReporte);$exportManager->exportReportToPdfFile($jasperPrint, $outputPath);//Muestro el Archivo PDF reemplazr $outputPath por $SalidaReporte if (file_exists($SalidaReporte)) { header('Content-type: application/pdf');header('Content-Disposition: inline; filename="' . $ReportePDF . '"');header('Content-Transfer-Encoding: binary');header('Accept-Ranges: bytes');echo file_get_contents($SalidaReporte);//unlink($SalidaReporte); } ?>Thanks Omar