leonardomartinez

Hi, I'm trying to display a dynamic image. In JasperStudio I added a image with custom expression like this: "repo:/Images/" + $P{name} + ".jpg". In my JasperServer repository have severeal images and when I run the report, I send a image name with P{name} parameter and I got this error "Byte data not found at : repo:/Images/name1.jpg" Any idea? thanks

Thanks for the answer, if I understood correctly, the parametrize JDBC URL take the parameters from the attributes defined from the user, organization or server, but I have to take the parameter "database" dynamically from a report parameter Thanks

Hi, I have a report in jasperserver that have a datasource point to a database "dbA", in my report I have a query that calls a stored procedure in that data base "exec SP Parameter1, Parameter2..." and works fine, but now I have to call the same report but consulting others databases dbB, dbC... that have the same stored procedure "SP", i.e. the same report with diferent data depending of what database is consulting, in my web application I have acces to a parameter that tells me what database is used, Any idea how can I achievement this? Thanks!

I need to change the location to Español (Mexico) for a correct numer format, if I click in regional configuration in login page, show just "es_ES(Español España)" ..and others, but not Español, Mexico. Actually I changed my system regional configuration but nothing happened. Thanks for your help!

Thanks! it works with &output=xls parameter in the HTTP API Call Regards.

Hi, I have a report in JasperServer embedding via iFrame like this: <iframe height=100% width=100% seamless id="frame1" name="frame1" frameborder="0" marginheight="0" marginwidth="0" src="server:port/jasperserver/flow.html?_flowId=viewReportFlow&standAlone=true&_flowId=viewReportFlow&ParentFolderUri=%2Freports&reportUnit=%2Freports%2FReporte_Ventas_Cliente_Under_Armour_Mexico&j_acegi_security_check&j_username=jasperadmin&j_password=jasperadmin&decorate=no</cfoutput>"> Ant that give me the standard view of jasperserver where I can export to pdf, xls, etc, but i'd like to access direct to xls view, is there a way for accomplish it? Thanks.

Thanks for the reply. Thats what i'm doing http.......&empId=1&fecha1=20140801&fecha2=20140802&cliente=0&sitio=0&userId=1 and it works, but my parameter empId, fecha1,... are variables in my web application, non static, so if I try something like that in my html page application: empIdVar=#URL.empId# .. give me an empty report, ie, the report don't catch the parameter. I hope i have been explained. Thanks!

Hi, I have my report on jasperserver, and i call it on my web application via iFrame like this: <iframe height=750px width=1500px seamless id="frame1" name="frame1" scroll="no" frameborder="0" onload='javascript:resizeIframe(this);' src="http://server:port/jasperserver/flow.html?_flowId=viewReportFlow&standAlone=true&_flowId=viewReportFlow&ParentFolderUri=%2Freports&reportUnit=%2Freports%2Fventas_cliente_v2&j_acegi_security_check&j_username=jasperadmin&j_password=jasperadmin&decorate=no&empId=1&fecha1=20140801&fecha2=20140802&cliente=0&sitio=0&userId=1" ></iframe>[/code]that works fine, but my parameters empId, fecha1, etc, needs to be variables, any idea? Thaks!

Hi, I need to compile and fill a JRXML file with Coldfusion, so i made a java proyect (packet in jar file) that do that, and the jar file placed it into application/wwwroot/web-inf/lib in that folder I placed jasper-reports-6.0 common-logging-1.1.1 common-digester-2.1 common-collections-3.2 common-beanutils1.9.0 xalan xerces-Impl-2.10.0 but when i call the compile method, I get this stack trace: thank for your suggests net.sf.jasperreports.engine.JRRuntimeException: Error creating SAX parser at net.sf.jasperreports.engine.xml.BaseSaxParserFactory.createParser(BaseSaxParserFactory.java:99) at net.sf.jasperreports.engine.xml.JRXmlDigesterFactory.createParser(JRXmlDigesterFactory.java:1504) at net.sf.jasperreports.engine.xml.JRXmlDigesterFactory.createDigester(JRXmlDigesterFactory.java:1480) at net.sf.jasperreports.engine.xml.JRXmlLoader.load(JRXmlLoader.java:262) at net.sf.jasperreports.engine.xml.JRXmlLoader.load(JRXmlLoader.java:218) at net.sf.jasperreports.engine.xml.JRXmlLoader.load(JRXmlLoader.java:193) at net.sf.jasperreports.engine.xml.JRXmlLoader.load(JRXmlLoader.java:184) at net.sf.jasperreports.engine.JasperCompileManager.compileToFile(JasperCompileManager.java:224) at net.sf.jasperreports.engine.JasperCompileManager.compileReportToFile(JasperCompileManager.java:539) at report_compile.CompilingJrxml.compilar(CompilingJrxml.java:13) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:483) at coldfusion.runtime.java.JavaProxy.invoke(JavaProxy.java:97) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:2483) at cfcoldFusionJasperReportsModParamLibs2ecfm2056129461.runPage(C:ColdFusion11cfusionwwwrootcoldFusionJasperReportsModParamLibs.cfm:30) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:246) at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:736) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:572) at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65) at coldfusion.filter.IpFilter.invoke(IpFilter.java:45) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:487) at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:42) at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40) at coldfusion.filter.PathFilter.invoke(PathFilter.java:142) at coldfusion.filter.LicenseFilter.invoke(LicenseFilter.java:30) at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:94) at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28) at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38) at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:58) at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:38) at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22) at coldfusion.filter.CachingFilter.invoke(CachingFilter.java:62) at coldfusion.CfmServlet.service(CfmServlet.java:219) at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:89) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:42) at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:46) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at coldfusion.inspect.weinre.MobileDeviceDomInspectionFilter.doFilter(MobileDeviceDomInspectionFilter.java:121) at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:46) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:220) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:122) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:501) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:171) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:422) at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1040) at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:607) at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:314) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) at java.lang.Thread.run(Thread.java:745) Caused by: org.xml.sax.SAXNotSupportedException: Property 'http://java.sun.com/xml/jaxp/properties/schemaLanguage' must be set before setting property 'http://java.sun.com/xml/jaxp/properties/schemaSource'. at org.apache.xerces.jaxp.SAXParserImpl$JAXPSAXParser.setProperty(Unknown Source) at org.apache.xerces.jaxp.SAXParserImpl.setProperty(Unknown Source) at net.sf.jasperreports.engine.xml.BaseSaxParserFactory.configureParser(BaseSaxParserFactory.java:134) at net.sf.jasperreports.engine.xml.BaseSaxParserFactory.createParser(BaseSaxParserFactory.java:94) ... 59 more[/code]

Hello, hope you can help me, I'm trying to compile a report from Coldfusion, this is my script: <cfscript>system = CreateObject("java", "java.lang.System");classpath = system.getProperty("java.class.path");if (FindNoCase("jasperreports", classpath) LTE 0){ classpath = classpath & ";C:ColdFusion8wwwrootWEB-INFlibReporteVentasCliente.jar;C:ColdFusion8wwwrootWEB-INFlibcommons-beanutils-1.8.0.jar;C:ColdFusion8wwwrootWEB-INFlibcommons-collections-2.1.1.jar;C:ColdFusion8wwwrootWEB-INFlibcommons-digester-2.1.jar;C:ColdFusion8wwwrootWEB-INFlibcommons-javaflow-20060411.jar;C:ColdFusion8wwwrootWEB-INFlibcommons-logging-1.1.1.jar;C:ColdFusion8wwwrootWEB-INFlibgroovy-all-2.0.1.jar;C:ColdFusion8wwwrootWEB-INFlibiText-2.1.7.js2.jar;C:ColdFusion8wwwrootWEB-INFlibjasperreports-6.0.0.jar;C:ColdFusion8wwwrootWEB-INFlibjasperreports-javaflow-6.0.0.jar;C:ColdFusion8wwwrootWEB-INFlibjasperreports-fonts-6.0.0.jar;C:ColdFusion8wwwrootWEB-INFlibjasperreports-javaflow-5.5.0.jar;C:ColdFusion8wwwrootWEB-INFlibjcommon-1.0.15.jar;C:ColdFusion8wwwrootWEB-INFlibjfreechart-1.0.12.jar;C:ColdFusion8wwwrootWEB-INFlibMerlia.jar;C:ColdFusion8wwwrootWEB-INFlibpng-encoder-1.5.jar;C:ColdFusion8wwwrootWEB-INFlibpoi-3.7-20101029.jar;C:ColdFusion8wwwrootWEB-INFlibservlet-api.jar;C:ColdFusion8wwwrootWEB-INFlibjxl-2.6.10.jar"; system.setProperty("java.class.path",classpath);}clazz = CreateObject("java", "java.lang.Class");clazz.forName("com.inet.tds.TdsDriver");driverManager = CreateObject("java", "java.sql.DriverManager");conurl = "jdbc:inetdae7:172.30.20.3:2717?database=db_ua_mex2";//VALIDAR login = "user";password = "password";connection = driverManager.getConnection(conurl, login, password); parameters = CreateObject("java", "java.util.HashMap"); parameters.put("empId", "1"); parameters.put("fecha1", "20140801"); parameters.put("fecha2", "20140802"); parameters.put("cliente", "0"); parameters.put("sitio", "0"); parameters.put("userId", "1");//// COMPILE ////jasperCompileManager = createObject("java", "net.sf.jasperreports.engine.JasperCompileManager");jasper = jasperCompileManager.compileReportToFile("C:ColdFusion8wwwrootjasperReportreporte_ventas_cliente_v2.jrxml");//// FILL //// jasperFillManager = createObject("java", "net.sf.jasperreports.engine.JasperFillManager");jasperPrint = jasperFillManager.fillReportToFile(jasper, parameters, connection);//// EXPORT ////jasperExportManager = createObject("java", "net.sf.jasperreports.engine.JasperExportManager");//JasperExportManager.exportReportToPdfFile(jasperPrint, "C:ColdFusion8wwwrootjasperReportsimpleTest3.pdf");//connection.close();</cfscript>[/code]<H3>Success!</H3> <A HREF="C:ColdFusion8wwwrootjasperReportsimpleTest3.pdf">SimpleTest.pdf</A> ... I have the libraries into C:ColdFusion8wwwrootWEB-INFlib I'm using jasperreports 6.0 I get this error: Error at line 19 char 8: net.sf.jasperreports.engine.design.JRDesignStyle cannot be cast to net.sf.jasperreports.engine.JRBox The error occurred in C:ColdFusion8wwwrootcoldFusionJasperReportsModParamLibs.cfm: line 48 46 : 47 : jasperCompileManager = createObject("java", "net.sf.jasperreports.engine.JasperCompileManager"); 48 : jasper = jasperCompileManager.compileReportToFile("C:ColdFusion8wwwrootjasperReportreporte_ventas_cliente_v2.jrxml"); 49 : 50 : [/code]Resources:Check the ColdFusion documentation to verify that you are using the correct syntax.Search the Knowledge Base to find a solution to your problem.Browser Mozilla/5.0 (Windows NT 6.3; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/40.0.2214.111 Safari/537.36Remote Address 192.168.1.75Referrer Date/Time 20-Feb-15 12:08 PM Stack Traceat cfcoldFusionJasperReportsModParamLibs2ecfm1826676198.runPage(C:ColdFusion8wwwrootcoldFusionJasperReportsModParamLibs.cfm:48) at cfcoldFusionJasperReportsModParamLibs2ecfm1826676198.runPage(C:ColdFusion8wwwrootcoldFusionJasperReportsModParamLibs.cfm:48) org.xml.sax.SAXParseException; lineNumber: 19; columnNumber: 8; Error at line 19 char 8: net.sf.jasperreports.engine.design.JRDesignStyle cannot be cast to net.sf.jasperreports.engine.JRBox at org.apache.commons.digester.Digester.createSAXException(Digester.java:2919) at org.apache.commons.digester.Digester.createSAXException(Digester.java:2945) at org.apache.commons.digester.Digester.startElement(Digester.java:1364) at org.apache.xerces.parsers.AbstractSAXParser.startElement(Unknown Source) at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl.scanStartElement(Unknown Source) at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl$FragmentContentDispatcher.dispatch(Unknown Source) at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl.scanDocument(Unknown Source) at org.apache.xerces.parsers.XML11Configuration.parse(Unknown Source) at org.apache.xerces.parsers.XML11Configuration.parse(Unknown Source) at org.apache.xerces.parsers.XMLParser.parse(Unknown Source) at org.apache.xerces.parsers.AbstractSAXParser.parse(Unknown Source) at org.apache.commons.digester.Digester.parse(Digester.java:1647) at net.sf.jasperreports.engine.xml.JRXmlLoader.loadXML(JRXmlLoader.java:240) at net.sf.jasperreports.engine.xml.JRXmlLoader.loadXML(JRXmlLoader.java:227) at net.sf.jasperreports.engine.xml.JRXmlLoader.load(JRXmlLoader.java:215) at net.sf.jasperreports.engine.xml.JRXmlLoader.load(JRXmlLoader.java:169) at net.sf.jasperreports.engine.xml.JRXmlLoader.load(JRXmlLoader.java:153) at net.sf.jasperreports.engine.JasperCompileManager.compileReportToFile(JasperCompileManager.java:81) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at coldfusion.runtime.java.JavaProxy.invoke(JavaProxy.java:87) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:2272) at cfcoldFusionJasperReportsModParamLibs2ecfm1826676198.runPage(C:ColdFusion8wwwrootcoldFusionJasperReportsModParamLibs.cfm:48) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:196) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:370) at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:279) at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:48) at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40) at coldfusion.filter.PathFilter.invoke(PathFilter.java:86) at coldfusion.filter.LicenseFilter.invoke(LicenseFilter.java:27) at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:70) at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28) at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38) at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:46) at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:38) at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22) at coldfusion.CfmServlet.service(CfmServlet.java:175) at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:89) at jrun.servlet.FilterChain.doFilter(FilterChain.java:86) at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:42) at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:46) at jrun.servlet.FilterChain.doFilter(FilterChain.java:94) at jrun.servlet.FilterChain.service(FilterChain.java:101) at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:106) at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42) at jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:286) at jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:543) at jrun.servlet.http.WebService.invokeRunnable(WebService.java:172) at jrunx.scheduler.ThreadPool$DownstreamMetrics.invokeRunnable(ThreadPool.java:320) at jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java:428) at jrunx.scheduler.ThreadPool$UpstreamMetrics.invokeRunnable(ThreadPool.java:266) at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66)Caused by: java.lang.ClassCastException: net.sf.jasperreports.engine.design.JRDesignStyle cannot be cast to net.sf.jasperreports.engine.JRBox at net.sf.jasperreports.engine.xml.JRBoxFactory.createObject(JRBoxFactory.java:70) at org.apache.commons.digester.FactoryCreateRule.begin(FactoryCreateRule.java:389) at org.apache.commons.digester.Digester.startElement(Digester.java:1361) ... 52 moreNESTED BY :net.sf.jasperreports.engine.JRException: Error at line 19 char 8: net.sf.jasperreports.engine.design.JRDesignStyle cannot be cast to net.sf.jasperreports.engine.JRBox at net.sf.jasperreports.engine.xml.JRXmlLoader.loadXML(JRXmlLoader.java:244) at net.sf.jasperreports.engine.xml.JRXmlLoader.loadXML(JRXmlLoader.java:227) at net.sf.jasperreports.engine.xml.JRXmlLoader.load(JRXmlLoader.java:215) at net.sf.jasperreports.engine.xml.JRXmlLoader.load(JRXmlLoader.java:169) at net.sf.jasperreports.engine.xml.JRXmlLoader.load(JRXmlLoader.java:153) at net.sf.jasperreports.engine.JasperCompileManager.compileReportToFile(JasperCompileManager.java:81) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at coldfusion.runtime.java.JavaProxy.invoke(JavaProxy.java:87) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:2272) at cfcoldFusionJasperReportsModParamLibs2ecfm1826676198.runPage(C:ColdFusion8wwwrootcoldFusionJasperReportsModParamLibs.cfm:48) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:196) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:370) at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:279) at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:48) at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40) at coldfusion.filter.PathFilter.invoke(PathFilter.java:86) at coldfusion.filter.LicenseFilter.invoke(LicenseFilter.java:27) at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:70) at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28) at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38) at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:46) at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:38) at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22) at coldfusion.CfmServlet.service(CfmServlet.java:175) at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:89) at jrun.servlet.FilterChain.doFilter(FilterChain.java:86) at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:42) at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:46) at jrun.servlet.FilterChain.doFilter(FilterChain.java:94) at jrun.servlet.FilterChain.service(FilterChain.java:101) at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:106) at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42) at jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:286) at jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:543) at jrun.servlet.http.WebService.invokeRunnable(WebService.java:172) at jrunx.scheduler.ThreadPool$DownstreamMetrics.invokeRunnable(ThreadPool.java:320) at jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java:428) at jrunx.scheduler.ThreadPool$UpstreamMetrics.invokeRunnable(ThreadPool.java:266) at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66)Caused by: org.xml.sax.SAXParseException; lineNumber: 19; columnNumber: 8; Error at line 19 char 8: net.sf.jasperreports.engine.design.JRDesignStyle cannot be cast to net.sf.jasperreports.engine.JRBox at org.apache.commons.digester.Digester.createSAXException(Digester.java:2919) at org.apache.commons.digester.Digester.createSAXException(Digester.java:2945) at org.apache.commons.digester.Digester.startElement(Digester.java:1364) at org.apache.xerces.parsers.AbstractSAXParser.startElement(Unknown Source) at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl.scanStartElement(Unknown Source) at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl$FragmentContentDispatcher.dispatch(Unknown Source) at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl.scanDocument(Unknown Source) at org.apache.xerces.parsers.XML11Configuration.parse(Unknown Source) at org.apache.xerces.parsers.XML11Configuration.parse(Unknown Source) at org.apache.xerces.parsers.XMLParser.parse(Unknown Source) at org.apache.xerces.parsers.AbstractSAXParser.parse(Unknown Source) at org.apache.commons.digester.Digester.parse(Digester.java:1647) at net.sf.jasperreports.engine.xml.JRXmlLoader.loadXML(JRXmlLoader.java:240) ... 42 moreCaused by: java.lang.ClassCastException: net.sf.jasperreports.engine.design.JRDesignStyle cannot be cast to net.sf.jasperreports.engine.JRBox at net.sf.jasperreports.engine.xml.JRBoxFactory.createObject(JRBoxFactory.java:70) at org.apache.commons.digester.FactoryCreateRule.begin(FactoryCreateRule.java:389) at org.apache.commons.digester.Digester.startElement(Digester.java:1361)[/code]

Hi, i'm trying to compile a .jrxml with jasperreports api on coldfusion. Before, I made a java class that works fine, generate the .jasper file, all allright, but I need to do this on coldfusion, then I made a .jar that contain my compile class in java, I imported that .jar in my coldfusion script classpath and call to compile method like this: <cfscript> system = CreateObject("java", "java.lang.System");classpath = system.getProperty("java.class.path");if (FindNoCase("jasperreports", classpath) LTE 0){ classpath = classpath & ";C:ColdFusion11cfusionwwwrootWEB-INFlibMerlia.jar;C:ColdFusion11cfusionwwwrootWEB-INFlibjasperreports-6.0.0.jar;C:ColdFusion11cfusionwwwrootWEB-INFlibcommons-beanutils-1.9.0.jar;C:ColdFusion11cfusionwwwrootWEB-INFlibcommons-collections-3.2.1.jar;C:ColdFusion11cfusionwwwrootWEB-INFlibcommons-digester-2.1.jar;C:ColdFusion11cfusionwwwrootWEB-INFlibcommons-javaflow-20060411.jar;C:ColdFusion11cfusionwwwrootWEB-INFlibcommons-logging-1.1.1.jar;C:ColdFusion11cfusionwwwrootWEB-INFlibxercesImpl-2.10.0.jar;C:ColdFusion11cfusionwwwrootWEB-INFlibReporteVentasCliente.jar"; system.setProperty("java.class.path",classpath);} clazz = CreateObject("java", "java.lang.Class"); clazz.forName("com.inet.tds.TdsDriver");driverManager = CreateObject("java", "java.sql.DriverManager"); conurl = "jdbc:inetdae7:172.30.20.3:2717?database=db_ua_mex2"; //VALIDAR login = "usuario";password = "password"; connection = driverManager.getConnection(conurl, login, password); //////////////////////////////////////////////// PROYECTO JAR TEST reportXml = createObject("java", "report_compile.CompilingJrxml");jasperReport = reportXml.compilar("C:ColdFusion11cfusionwwwrootjasperReportsimpleTest3.jrxml"); ...</cfscript> I got this error: Error creating SAX parserThe error occurred in C:/ColdFusion11/cfusion/wwwroot/coldFusionJasperReportsModParamLibs.cfm: line 30Stack Traceat cfcoldFusionJasperReportsModParamLibs2ecfm2056129461.runPage(C:/ColdFusion11/cfusion/wwwroot/coldFusionJasperReportsModParamLibs.cfm:30)

yes, i tested with sql and plsql and the result is the same

Hi, i'm trying to call a stored procedure from JasperSoft Studio 5.6.2, The stored procedure is allocated in a bd SQL SERVER, i'm using sqljdbc4 connector The parameters of sp are: @emp_id tinyint, @fecha1 char(8), @fecha2 char(8), @cliente int, @sitio varchar(200), @usu_id int and i'm calling the sp like this: execute rep_dr_ventas_cli_sec_nx 1,'20140801','20140802',0,'0',1 i get this Exception: La instrucción no devolvió un conjunto de resultados net.sf.jasperreports.engine.JRException: Error executing SQL statement for : Blank_A4_Landscapeat net.sf.jasperreports.engine.query.JRJdbcQueryExecuter.createDatasource(JRJdbcQueryExecuter.java:240)at com.jaspersoft.studio.data.jdbc.JDBCFieldsProvider.getFields(JDBCFieldsProvider.java:67)at com.jaspersoft.studio.data.jdbc.JDBCDataAdapterDescriptor.getFields(JDBCDataAdapterDescriptor.java:75)at com.jaspersoft.studio.property.dataset.dialog.DataQueryAdapters.doGetFields(DataQueryAdapters.java:359)at com.jaspersoft.studio.data.designer.AQueryDesignerContainer$1.run(AQueryDesignerContainer.java:54)at org.eclipse.jface.operation.ModalContext$ModalContextThread.run(ModalContext.java:121)Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: La instrucción no devolvió un conjunto de resultados.at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDriverError(SQLServerException.java:190)at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(SQLServerPreparedStatement.java:408)at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PrepStmtExecCmd.doExecute(SQLServerPreparedStatement.java:350)at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:5696)at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1715)at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:180)at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:155)at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.executeQuery(SQLServerPreparedStatement.java:285)at net.sf.jasperreports.engine.query.JRJdbcQueryExecuter.createDatasource(JRJdbcQueryExecuter.java:233)... 5 more ..Any idea?, Thanks!