kito_park

Hi, im trying to create a report that use 2 columns, the report works fine except the size of the columns, the columns should have the same height. I want to set the max size between column A and B, noi matter the blank space on the smallest column there is a screenshots Thanks for help :)

Hi im using parameters on my query and a error is shown, when i use the values instead of the parameters the query works fine. The error is: Error:General problem:Error executing SQL statement for: nullCheck userName and password; is the DBMS active? Im using ireport 5.0.1 Here is my query with parameters ..Select trunc(n.fecha,$P{pFechas} ) mes_g, decode(substr(n.sector,1,1), 'B', '1', 'M', '2', 'T', '3', 'P', '4', '5') orden_g, decode(substr(n.sector,1,1), 'B', 'Burócratas', 'M', 'Maestros', 'T', 'Telesecundarias', 'P', 'D.P.E.', 'desconocido') sector_g, count(*) numero_g, sum(n.capital) monto_gfrom (select fecha, sector, capital from allpcps where nvl(estado,'A')='A' UNION ALL select fecha, sector, capital from psuas where nvl(estado,'A')='A') nwhere n.fecha between to_date( $P{pDesde}) and to_date($P{pHasta})group by trunc(n.fecha,$P{pFechas} ), decode(substr(n.sector,1,1), 'B', '1', 'M', '2', 'T', '3', 'P', '4', '5'), decode(substr(n.sector,1,1), 'B', 'Burócratas', 'M', 'Maestros', 'T', 'Telesecundarias', 'P', 'D.P.E.', 'desconocido')order by 1, 2 ..Here is my query with values:..Select trunc(n.fecha,'mm' ) mes_g, <------------- decode(substr(n.sector,1,1), 'B', '1', 'M', '2', 'T', '3', 'P', '4', '5') orden_g, decode(substr(n.sector,1,1), 'B', 'Burócratas', 'M', 'Maestros', 'T', 'Telesecundarias', 'P', 'D.P.E.', 'desconocido') sector_g, count(*) numero_g, sum(n.capital) monto_gfrom (select fecha, sector, capital from allpcps where nvl(estado,'A')='A' UNION ALL select fecha, sector, capital from psuas where nvl(estado,'A')='A') nwhere n.fecha between to_date( '01-01-2019') and to_date('02-08-2019') <---------------group by trunc(n.fecha,'mm' ), <----------------- decode(substr(n.sector,1,1), 'B', '1', 'M', '2', 'T', '3', 'P', '4', '5'), decode(substr(n.sector,1,1), 'B', 'Burócratas', 'M', 'Maestros', 'T', 'Telesecundarias', 'P', 'D.P.E.', 'desconocido')order by 1, 2 ..Can you help me?Regards[/code]

A guy who i cant contact deployed a war file and this server allow drag and drop functionallity. if i create a report, to publish it i just need to copy the .jasper file to a folder "<js-install>/reports" and now the report can be run on the web browser. I need do this on another server.

Hi, i have deployed the war version of Jasper Reports Server, there is any way to drag an drop reports to any folder and the server recognize them? i need to publish too many reports and the configuration of each report is very tedious. Can you tell me if it is possible ?

Hi, i've designed a report in Ireports 5.0.1 with a pie chart, in the software it run correctly, but when i publish the report on the server it show an error. I tried to compile the report on ireports 5.6.0 and jaspersoft studio, i have already put the library for charts (jfreechart) on jsInstall/WEB-INF/lib but the result is the same. The server is running on Oracle Linux. Can you help me? The error is: java.lang.NoClassDefFoundError: Lorg/jfree/chart/plot/PlotOrientation; at java.lang.Class.getDeclaredFields0(Native Method) at java.lang.Class.privateGetDeclaredFields(Class.java:2583) at java.lang.Class.getDeclaredField(Class.java:2068) at java.io.ObjectStreamClass.getDeclaredSUID(ObjectStreamClass.java:1703) at java.io.ObjectStreamClass.access$700(ObjectStreamClass.java:72) at java.io.ObjectStreamClass$2.run(ObjectStreamClass.java:484) at java.io.ObjectStreamClass$2.run(ObjectStreamClass.java:472) at java.security.AccessController.doPrivileged(Native Method) at java.io.ObjectStreamClass.(ObjectStreamClass.java:472) at java.io.ObjectStreamClass.lookup(ObjectStreamClass.java:369) at java.io.ObjectStreamClass.initNonProxy(ObjectStreamClass.java:598) at java.io.ObjectInputStream.readNonProxyDesc(ObjectInputStream.java:1843) at java.io.ObjectInputStream.readClassDesc(ObjectInputStream.java:1713) at java.io.ObjectInputStream.readNonProxyDesc(ObjectInputStream.java:1843) at java.io.ObjectInputStream.readClassDesc(ObjectInputStream.java:1713) at java.io.ObjectInputStream.readOrdinaryObject(ObjectInputStream.java:2000) at java.io.ObjectInputStream.readObject0(ObjectInputStream.java:1535) at java.io.ObjectInputStream.defaultReadFields(ObjectInputStream.java:2245) at java.io.ObjectInputStream.defaultReadObject(ObjectInputStream.java:552) at net.sf.jasperreports.engine.base.JRBaseChart.readObject(JRBaseChart.java:813) 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:498) at java.io.ObjectStreamClass.invokeReadObject(ObjectStreamClass.java:1058) at java.io.ObjectInputStream.readSerialData(ObjectInputStream.java:2136) at java.io.ObjectInputStream.readOrdinaryObject(ObjectInputStream.java:2027) at java.io.ObjectInputStream.readObject0(ObjectInputStream.java:1535) at java.io.ObjectInputStream.readObject(ObjectInputStream.java:422) at java.util.ArrayList.readObject(ArrayList.java:791) at sun.reflect.GeneratedMethodAccessor3.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at java.io.ObjectStreamClass.invokeReadObject(ObjectStreamClass.java:1058) at java.io.ObjectInputStream.readSerialData(ObjectInputStream.java:2136) at java.io.ObjectInputStream.readOrdinaryObject(ObjectInputStream.java:2027) at java.io.ObjectInputStream.readObject0(ObjectInputStream.java:1535) at java.io.ObjectInputStream.defaultReadFields(ObjectInputStream.java:2245) at java.io.ObjectInputStream.readSerialData(ObjectInputStream.java:2169) at java.io.ObjectInputStream.readOrdinaryObject(ObjectInputStream.java:2027) at java.io.ObjectInputStream.readObject0(ObjectInputStream.java:1535) at java.io.ObjectInputStream.defaultReadFields(ObjectInputStream.java:2245) at java.io.ObjectInputStream.defaultReadObject(ObjectInputStream.java:552) at net.sf.jasperreports.engine.base.JRBaseReport.readObject(JRBaseReport.java:790) at sun.reflect.GeneratedMethodAccessor68.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at java.io.ObjectStreamClass.invokeReadObject(ObjectStreamClass.java:1058) at java.io.ObjectInputStream.readSerialData(ObjectInputStream.java:2136) at java.io.ObjectInputStream.readOrdinaryObject(ObjectInputStream.java:2027) at java.io.ObjectInputStream.readObject0(ObjectInputStream.java:1535) at java.io.ObjectInputStream.readObject(ObjectInputStream.java:422) at net.sf.jasperreports.engine.util.JRLoader.loadObject(JRLoader.java:111) at net.sf.jasperreports.engine.JasperFillManager.fill(JasperFillManager.java:272) at net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:745) at com.mayabit.app.apex.jasper.ReportWrapper.service(ReportWrapper.java:201) at javax.servlet.http.HttpServlet.service(HttpServlet.java:790) at weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:286) at weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:260) at weblogic.servlet.internal.StubSecurityHelper.invokeServlet(StubSecurityHelper.java:137) at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:350) at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:247) at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.wrapRun(WebAppServletContext.java:3679) at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:3649) at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:326) at weblogic.security.service.SecurityManager.runAsForUserCode(SecurityManager.java:197) at weblogic.servlet.provider.WlsSecurityProvider.runAsForUserCode(WlsSecurityProvider.java:203) at weblogic.servlet.provider.WlsSubjectHandle.run(WlsSubjectHandle.java:71) at weblogic.servlet.internal.WebAppServletContext.doSecuredExecute(WebAppServletContext.java:2433) at weblogic.servlet.internal.WebAppServletContext.securedExecute(WebAppServletContext.java:2281) at weblogic.servlet.internal.WebAppServletContext.execute(WebAppServletContext.java:2259) at weblogic.servlet.internal.ServletRequestImpl.runInternal(ServletRequestImpl.java:1691) at weblogic.servlet.internal.ServletRequestImpl.run(ServletRequestImpl.java:1651) at weblogic.servlet.provider.ContainerSupportProviderImpl$WlsRequestExecutor.run(ContainerSupportProviderImpl.java:270) at weblogic.invocation.ComponentInvocationContextManager._runAs(ComponentInvocationContextManager.java:348) at weblogic.invocation.ComponentInvocationContextManager.runAs(ComponentInvocationContextManager.java:333) at weblogic.work.LivePartitionUtility.doRunWorkUnderContext(LivePartitionUtility.java:54) at weblogic.work.PartitionUtility.runWorkUnderContext(PartitionUtility.java:41) at weblogic.work.SelfTuningWorkManagerImpl.runWorkUnderContext(SelfTuningWorkManagerImpl.java:640) at weblogic.work.ExecuteThread.execute(ExecuteThread.java:406) at weblogic.work.ExecuteThread.run(ExecuteThread.java:346)Caused by: java.lang.ClassNotFoundException: org.jfree.chart.plot.PlotOrientation at weblogic.utils.classloaders.GenericClassLoader.findLocalClass(GenericClassLoader.java:1026) at weblogic.utils.classloaders.GenericClassLoader.findClass(GenericClassLoader.java:987) at weblogic.utils.classloaders.ChangeAwareClassLoader.findClass(ChangeAwareClassLoader.java:83) at weblogic.utils.classloaders.GenericClassLoader.doFindClass(GenericClassLoader.java:608) at weblogic.utils.classloaders.GenericClassLoader.loadClass(GenericClassLoader.java:540) at weblogic.utils.classloaders.GenericClassLoader.loadClass(GenericClassLoader.java:493) at weblogic.utils.classloaders.GenericClassLoader.loadClass(GenericClassLoader.java:470) at weblogic.utils.classloaders.ChangeAwareClassLoader.loadClass(ChangeAwareClassLoader.java:53) ... 81 more

Hi im trying to deploy jasperreports server war file on glassfish server, i used the comand "js-ant deploy-webapp-ce" the procees finish well and the files are copied to glassfish.../domain1/autodeploy, when i try to run the web application an error 404 is shown, in the glassfish console no applicationss are available to launch. i tried restart the glassfish server but the web application never appears

Hi, i need to create column header by group, i mean, for each different value of grouped field create a column. Also put values of each group in the rows. can you hel me to do this on ireports 5.0.1? the folowing image shows how it should be.