sambitgudu

I need to create two tables in summry section but using same dataset and the sql qeury for two tables is same. As per my knowledge sql query will run twice when creating two tables, but i want to execute the sql query once because the sql query is same for both table. Plase help me with this. Is it possible to run query once for two tables?

- Yes it is happening to all jrxml files. - It seems iReport unable to load any JRXML file. Till yesterday everything was working fine. - Today i reinstall iReport 5.1 and it started working but after some time it again failed to load JRXML files, when loading it only show the message "loading report". - I checked the log file and there i foud below error happening frequently : org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'legendBaseFontSize': Invocation of init method failed; nested exception is java.lang.NoSuchFieldException: LEGEND_BASEFONT_SIZE at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1362) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:540) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory$1.run(AbstractAutowireCapableBeanFactory.java:485) at java.security.AccessController.doPrivileged(Native Method) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:455) at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:251) at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:169) at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:248) at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:170) at org.springframework.beans.factory.support.AbstractBeanFactory.getTypeForFactoryBean(AbstractBeanFactory.java:1210) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.getTypeForFactoryBean(AbstractAutowireCapableBeanFactory.java:679) at org.springframework.beans.factory.support.AbstractBeanFactory.isTypeMatch(AbstractBeanFactory.java:444) at org.springframework.beans.factory.support.DefaultListableBeanFactory.getBeanNamesForType(DefaultListableBeanFactory.java:208) at org.springframework.beans.factory.support.DefaultListableBeanFactory.getBeanNamesForType(DefaultListableBeanFactory.java:184) at net.sf.jasperreports.extensions.SpringExtensionsRegistry.findExtensionBeanNames(SpringExtensionsRegistry.java:100) at net.sf.jasperreports.extensions.SpringExtensionsRegistry.getExtensionBeanNames(SpringExtensionsRegistry.java:91) at net.sf.jasperreports.extensions.SpringExtensionsRegistry.getExtensions(SpringExtensionsRegistry.java:67) at net.sf.jasperreports.extensions.DefaultExtensionsRegistry.getExtensions(DefaultExtensionsRegistry.java:110) at com.jaspersoft.ireport.designer.options.IReportPanel.load(IReportPanel.java:3156) at com.jaspersoft.ireport.designer.options.IReportOptionsPanelController.update(IReportOptionsPanelController.java:64) at org.netbeans.modules.options.CategoryModel$Category.update(CategoryModel.java:378) at org.netbeans.modules.options.OptionsPanel.setCurrentCategory(OptionsPanel.java:177) at org.netbeans.modules.options.OptionsPanel.access$100(OptionsPanel.java:95) at org.netbeans.modules.options.OptionsPanel$1$1.run(OptionsPanel.java:154) at java.awt.event.InvocationEvent.dispatch(InvocationEvent.java:209) at java.awt.EventQueue.dispatchEventImpl(EventQueue.java:641) at java.awt.EventQueue.access$000(EventQueue.java:84) at java.awt.EventQueue$1.run(EventQueue.java:602) at java.awt.EventQueue$1.run(EventQueue.java:600) at java.security.AccessController.doPrivileged(Native Method) at java.security.AccessControlContext$1.doIntersectionPrivilege(AccessControlContext.java:87) at java.awt.EventQueue.dispatchEvent(EventQueue.java:611) at org.netbeans.core.TimableEventQueue.dispatchEvent(TimableEventQueue.java:104) at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:269) at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:184) at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:174) at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:169) at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:161) at java.awt.EventDispatchThread.run(EventDispatchThread.java:122) Caused by: java.lang.NoSuchFieldException: LEGEND_BASEFONT_SIZE at java.lang.Class.getField(Class.java:1520) at org.springframework.beans.factory.config.FieldRetrievingFactoryBean.afterPropertiesSet(FieldRetrievingFactoryBean.java:189) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1390) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1359) ... 38 more

From last one year i am using ireprot, now i am getting a very strange problme i.e when i am trying to open a JRXML file the iReport 5.1 cashes, i do not know what is happening since it was working fine yesterday. I need your help. Thanks Sambit

Please help me to find out the MAVEN repo location for - "jasperserver-ireport-plugin-3.0.0.jar" and "js_jasperserver-common-ws-3.5.0.jar" Thanks Sambit

This type of error generally occurs when someting wrong in your XML tag, according to your error you there is some thing wrong at line 247 and column 18. so you have to open your report in XML preview and need to fix manually.

You need to use expressions. ex : $F{field_name} !=null ? $F{field_name} : "N/A"

In the first image border of two text fields are not overlapping so the colour is blue("see the small square shape "). In the second image border of two text fields are overlapping so the colour is green. - I am trying to say that always make sure that two text fields should not overlap.

Change report language type to JAVA

- Avoid field merging when designing report. ex. fields which is not merged ("colour is blue") ex. fields which is merged("colour is green")

Yes it is possible. In your case you are missing '!' , it should be look like $P!{pdf_query}

Hey I hvae tested in my side your code is working fine. You can check with $F{birthDate} field , are you getting correct date form DB or not.

STEP 1: l upload you JAR to jasper server as given below: - STEP 2: Then go to "Control & Resources" page of a report and there add the resource created in STEP 1 as given below. - After this you can call access any java methods from JRXML file

I am not sure what's happening in your side but i can give some points which may resolve your issue: 1. Adjust height of details band same as that of text fields used in the details band. 2. Check "Blank When Null" and "Remove Line When Blank" property for all fields used in details band.

You can use condtion " $V{PAGE_NUMBER} == 1 " in the Print When Expression of that image.

Not getting your query ?? Can you elaborate your requriment ??