derek_ricca

This may be a stupid question but can you give a full example of how to do that in the customize() function? I have a good idea but I'm still learning how to customize through iReport. Speaking of which, where would I put my class once it's compiled, and how would I tell my chart in iReport where to find it?

For a bunch of reports with bar charts that I've made for work, my boss wants all the interval numbers on the Y-axis to be whole numbers. In the chart data already, all of the numbers being plotted are Integers, but sometimes the interval numbers are incremented in decimals (and displayed as doubles). My question is, is there a way to force all of the Y-axis' interval numbers to be whole Integers, through iReport? If not, how can I do this easily? Thanks!

I'm trying to upgrade a JasperServer 1.2.1 database to work with a new install of JasperServer 2.0.0., but the scripts that were given with neither the install exe file nor the source .zip file work. I've tried creating the database using the jasperserverCreate-postgresql.ddl file, then upgrading using jasperserverCreateDefaultSecurity-postgresql.sql, but then Tomcat gives this error in the log whenever I try to connect: Code:10:19:19,658 ERROR ContextLoader,Thread-1:205 - Context initialization failed org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'profilingAspect' defined in ServletContext resource [/WEB-INF/applicationContext-profiling.xml]: Invocation of init method failed; nested exception is com.jaspersoft.jasperserver.api.JSExceptionWrapper: JDBC exception on Hibernate data access; nested exception is org.hibernate.exception.SQLGrammarException: could not execute query Caused by: com.jaspersoft.jasperserver.api.JSExceptionWrapper: org.springframework.orm.hibernate3.HibernateJdbcException: JDBC exception on Hibernate data access; nested exception is org.hibernate.exception.SQLGrammarException: could not execute query Caused by: org.hibernate.exception.SQLGrammarException: could not execute query at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:67) at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43) at org.hibernate.loader.Loader.doList(Loader.java:2214) at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2095) at org.hibernate.loader.Loader.list(Loader.java:2090) at org.hibernate.loader.criteria.CriteriaLoader.list(CriteriaLoader.java:95) at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1569) at org.hibernate.impl.CriteriaImpl.list(CriteriaImpl.java:283) at org.springframework.orm.hibernate3.HibernateTemplate$35.doInHibernate(HibernateTemplate.java:979) at org.springframework.orm.hibernate3.HibernateTemplate.execute(HibernateTemplate.java:367) at org.springframework.orm.hibernate3.HibernateTemplate.findByCriteria(HibernateTemplate.java:969) at org.springframework.orm.hibernate3.HibernateTemplate.findByCriteria(HibernateTemplate.java:962) at com.jaspersoft.jasperserver.api.metadata.common.service.impl.hibernate.HibernateRepositoryServiceImpl.findByName(HibernateRepositoryServiceImpl.java:531) at com.jaspersoft.jasperserver.api.metadata.common.service.impl.hibernate.HibernateRepositoryServiceImpl.findByURI(HibernateRepositoryServiceImpl.java:514) at com.jaspersoft.jasperserver.api.metadata.common.service.impl.hibernate.HibernateRepositoryServiceImpl.loadResource(HibernateRepositoryServiceImpl.java:127) at com.jaspersoft.jasperserver.api.metadata.common.service.impl.hibernate.HibernateRepositoryServiceImpl$1.execute(HibernateRepositoryServiceImpl.java:111) at com.jaspersoft.jasperserver.api.metadata.common.service.impl.HibernateDaoImpl.executeCallback(HibernateDaoImpl.java:58) at com.jaspersoft.jasperserver.api.metadata.common.service.impl.hibernate.HibernateRepositoryServiceImpl.getResourceUnsecure(HibernateRepositoryServiceImpl.java:109) 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 org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:281) at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:187) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:154) at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:107) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:176) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:210) at $Proxy2.getResourceUnsecure(Unknown Source) at com.jaspersoft.ji.util.properties.service.PropertiesManagementServiceImpl.initialize(PropertiesManagementServiceImpl.java:61) at com.jaspersoft.ji.util.profiling.service.GlobalProfilingState.initialize(GlobalProfilingState.java:47) at com.jaspersoft.ji.ja.profiling.ProfilingAspect.afterPropertiesSet(ProfilingAspect.aj:78) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1118) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1085) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:429) at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:250) at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:141) at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:247) at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:161) at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:273) at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:346) at org.springframework.web.context.support.AbstractRefreshableWebApplicationContext.refresh(AbstractRefreshableWebApplicationContext.java:156) at org.springframework.web.context.ContextLoader.createWebApplicationContext(ContextLoader.java:246) at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:184) at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:49) at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3827) at org.apache.catalina.core.StandardContext.start(StandardContext.java:4334) at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:791) at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:771) at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:525) at org.apache.catalina.startup.HostConfig.deployDirectory(HostConfig.java:920) at org.apache.catalina.startup.HostConfig.deployDirectories(HostConfig.java:883) at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:492) at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1138) at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:311) at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:117) at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1053) at org.apache.catalina.core.StandardHost.start(StandardHost.java:719) at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1045) at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:443) at org.apache.catalina.core.StandardService.start(StandardService.java:516) at org.apache.catalina.core.StandardServer.start(StandardServer.java:710) at org.apache.catalina.startup.Catalina.start(Catalina.java:566) 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 org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:288) at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:413) Caused by: org.postgresql.util.PSQLException: ERROR: relation "jireportoptions" does not exist at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1548) at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1316) at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:191) at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:452) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:351) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:255) at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:93) at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:186) at org.hibernate.loader.Loader.getResultSet(Loader.java:1778) at org.hibernate.loader.Loader.doQuery(Loader.java:662) at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:224) at org.hibernate.loader.Loader.doList(Loader.java:2211) ... 66 more Can someone post a script that will correctly upgrade my 1.2.1 DB to 2.0.0? Thanks! Post edited by: derek_ricca, at: 2007/09/26 14:24

Since nobody had any idea how to do this, I figured I would post up the solution I came up with. It's not perfect but it works. Maybe the writers of JasperReports can include it, it's pretty simple. Anyway, I simply created a Java class which extends the ManagementService class (part of the com.jaspersoft.jasperserver.ws.axis2 package), overwriting the "runReport" function with pretty much the same thing, except I add the following lines right before addAdditionalAttachmentsForReport(jasperPrint, attachments, format, new StringBuffer(new String(bos.toByteArray())));: Code: num_pages = jasperPrint.getPages().size(); or.setMessage("Total pages: " + num_pages); This just returns the number of pages in the operation result. I think this should have definitely been a standard part of HTML export, since otherwise it's pretty much impossible to get the total number of pages unless it's through a JSP (which I'm not using and many other people don't use either), and kind of stupid to force the user to guess or check for an error every time they increment the page they're displaying. If anyone needs the class file just reply and I'll post it up. Post edited by: derek_ricca, at: 2007/08/10 19:16 Post edited by: derek_ricca, at: 2007/08/10 19:18

Is that the only way to do it?

Ok, I saw in another thread that there's a fairly simple way in Java to get the total number of pages (identified in a jasper report as $P{PAGE_COUNT}. My question is how do I export that number through a PHP/SOAP interface? I'm trying to make a scrollable interface (ie: "Page 1|2|3|4" or something). The PHP example doesn't really help at all in this instance. Thanks.

Thanks for an answer that actually helps. It kinda sucks that they couldn't figure out a way to get it to make it work. Kinda lowers the functionality of the program a little.

How would I get the total number of pages through PHP?

I hate to crosspost like this, but nobody was able to help me in the other subforum. So, I'm putting together a set of reports for my employer. We put together the jrxml files using iReport 2.0.0, and we're connected to JasperServer using the JS plugin 2.0.0. Basically, I have 4 images. One in the columnheader, one in the detail section, and 2 in the columnfooter. The detail one (and one of the column footer ones) is a background for a static text field and a few variable text fields. The thing is, both of the ones that are behind the text fields don't show up at all in HTML. I can try to preview it in HTML using iReport, and it won't generate them. Same thing when I try running it on JasperServer directly, or through the CakePHP site we're using these on. However, export to PDF, RTF, or XLS and they show up fine. I've tried it with the textfields transparent and not transparent, images aren't created. If I delete the textfields the images show up correctly. Is this a bug within Jasper? Are images simply not able to be used as backgrounds for text fields? Versions: JasperServer - 1.2.1 (same with exporter tool) JasperReports (on jasperserver) - 1.3.1, (through iReport on my local syste) - 1.3.4 iReport - 2.0.0 (same w/JS Plugin) Post edited by: derek_ricca, at: 2007/08/01 20:47

Should I try posting this in a different subforum? I really need to get this bug fixed.

No go... didn't find anything useful on the bug report site.

codyjasperForge wrote: One other option would be to try viewing them using a different browser. With so many browser options these days there could be some kind of conflict with the browser you're using to view it with. One possible workaround is to export to something like .pdf format, then view that .pdf using your browser. I don't think that it is a bug. There is something that is occurring that we aren't aware of... Browser issues aside, this is a Jasper issue. As for your workaround, we already intend to allow our users to download it in PDF format, but we need to display to them - in HTML - the same thing.

Yea that had no effect. Is this a bug within JasperReports perhaps?

codyjasperForge wrote: Are your textfields set to 'Transparent' ? Have you tried 'Send To Front/Back' options? Are your URLs correct? Just a few ideas... I've tried it with the textfields transparent and not transparent. Image resource URLS are correct. Where is the "send to front/back" option? I haven't tried that.

Hi there. So, I'm putting together a set of reports for my employer. We put together the jrxml files using iReport 2.0.0, and we're connected to JasperServer using the JS plugin. Basically, I have 4 images. One in the columnheader, one in the detail section, and 2 in the columnfooter. The detail one (and one of the column footer ones) is a background for a static text field and a few variable text fields. The thing is, both of the ones that are behind the text fields don't show up at all in HTML. I can try to preview it in HTML using iReport, and it won't generate them. Same thing when I try running it on JasperServer directly, or through the CakePHP site we're using these on. However, export to PDF, RTF, or XLS and they show up fine. Any idea what could be causing it? Thanks. Post edited by: derek_ricca, at: 2007/07/30 15:30