croutledge

Can i setup a custom template? I've tried creating a normal report and then importing it via the Tools -> Templates menu option but my template doesn't appear as a valid choice when you want to create a new report. Cheers Carl

Sorry found it. You need to right click on the Reports name in the explorer and the group by option is in there./tools/fckeditor/editor/images/smiley/msn/embaressed_smile.gif Cheers Carl

Is it possible to perform a group by when using a JavaBean Datasource? I've picked the domain object and designed a report from its fields and even managed to export it to a PDF stream in my web project loaded with a list of the chosen domain objects. But i now want to start grouping and inserting sum columns. Is this possible? Cheers Carl

Is it possible in Java code to access the data in a field after you fill it? We produce a report, actually a label, and want to be able to see the data in certain fields and then perhaps store that data into our DB for later use? We are using Jasper to generate packing labels, etc and we have barcodes on those labels that can contain a number of different fields combined. As we sometimes want to verify that our printing is producing good quality output we want the user to scan back the barcode and we check it match's what we thought was in it. Previously we generated all our labels via code and knew when we created a barcode and wrote it to the db for checking later. But as we are using iReport and Jasper to take a collection of our DTO's to create the label we don't know, without doing a lot of work, if the label contains a barcode. So i was hoping to either get the report to write the barcode contents to the db (don't think this is possible or wise) or once we fill the report in our Java code access the fields and there data to store into the db. Cheers Carl

I'm using ireport/jasperreports to create pallet labels. I'm passing a list custom DTO's to the report. All seems to be work fine. In the DTO i have an object that represents a customer order. Now in this object we have a list of what we call special instructions (Integer and a Description). I want to be able to show/hide parts of the label if a particular instruction appears in the list. Is this possible?

Hmm, indeed. I have them in the classpath and set to reloadable. I suppose i will just fight on with it as it is. Cheers Carl

Thanks for the reply dman. This is one option i can look into. We did one of our original J2EE projects with property files but felt it was limited in that a whole project would need to be released to add a new set of language data. So in our latest J2EE project we have used a db table to drive this and just look the information up from there. So because we have a lot of data already in a table that we could use in a report i would like to do just that. Cheers Carl

Hitting a problem with this on one of my test reports. In my Pallet class i have an attribute of type currentPalletLocation, which itself contains a attribute of type PalletStore. Now i want to display the location attribute of the PalletStore. If i add a field via the JavaBean Datasource choosing currentPalletLocation the report will preview (not added the field to the report). If i add the field to the report and then change the expression to $F{currentPalletLocation}.getPalletStore().getLocation() it works just fine. If i add a field via the JavaBean Datasource straight to the location attribute the report doesn't even preview even when it isn't actually added to report. See error below ErrorÂfillingÂprint...ÂErrorÂretrievingÂfieldÂvalueÂfromÂbeanÂ:Âlocation net.sf.jasperreports.engine.JRException:ÂErrorÂretrievingÂfieldÂvalueÂfromÂbeanÂ:Âlocation ÂÂÂÂatÂnet.sf.jasperreports.engine.data.JRAbstractBeanDataSource.getBeanProperty(JRAbstractBeanDataSource.java:127) ÂÂÂÂatÂnet.sf.jasperreports.engine.data.JRAbstractBeanDataSource.getFieldValue(JRAbstractBeanDataSource.java:100) ÂÂÂÂatÂnet.sf.jasperreports.engine.data.JRBeanCollectionDataSource.getFieldValue(JRBeanCollectionDataSource.java:104) ÂÂÂÂatÂnet.sf.jasperreports.engine.fill.JRFillDataset.setOldValues(JRFillDataset.java:822) ÂÂÂÂatÂnet.sf.jasperreports.engine.fill.JRFillDataset.next(JRFillDataset.java:786) ÂÂÂÂatÂnet.sf.jasperreports.engine.fill.JRBaseFiller.next(JRBaseFiller.java:1413) ÂÂÂÂatÂnet.sf.jasperreports.engine.fill.JRVerticalFiller.fillReport(JRVerticalFiller.java:111) ÂÂÂÂatÂnet.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:899) ÂÂÂÂatÂnet.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:821) ÂÂÂÂatÂnet.sf.jasperreports.engine.fill.JRFiller.fillReport(JRFiller.java:89) ÂÂÂÂatÂnet.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:628) ÂÂÂÂatÂnet.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:544) ÂÂÂÂatÂcom.jaspersoft.ireport.designer.compiler.IReportCompiler.run(IReportCompiler.java:921) ÂÂÂÂatÂorg.openide.util.RequestProcessor$Task.run(RequestProcessor.java:561) ÂÂÂÂatÂorg.openide.util.RequestProcessor$Processor.run(RequestProcessor.java:986) CausedÂby:Âjava.lang.NoSuchMethodException:ÂUnknownÂpropertyÂ'location' ÂÂÂÂatÂorg.apache.commons.beanutils.PropertyUtilsBean.getSimpleProperty(PropertyUtilsBean.java:1122) ÂÂÂÂatÂorg.apache.commons.beanutils.PropertyUtilsBean.getNestedProperty(PropertyUtilsBean.java:686) ÂÂÂÂatÂorg.apache.commons.beanutils.PropertyUtilsBean.getProperty(PropertyUtilsBean.java:715) ÂÂÂÂatÂorg.apache.commons.beanutils.PropertyUtils.getProperty(PropertyUtils.java:290) ÂÂÂÂatÂnet.sf.jasperreports.engine.data.JRAbstractBeanDataSource.getBeanProperty(JRAbstractBeanDataSource.java:115) ÂÂÂÂ...Â14Âmore Print not filled. Try to use an EmptyDataSource... Any idea's? Cheers Carl

Any response to my question around just having the folder in the classpath not a jar?

Thanks for the reply Giulio, So would i be able to pass in a map as a parameter and then use display text from that map for textfields on my report?

In our Web Application we are using a table to hold text used in our JSP pages (column headings, output boxes, etc) for each page and a language. For example code, displayText, language, group welcome, Welcome, en_GB, UIWelcomePage Now on each Form we pull the full the entire list for the current page and language and use them. Will i be able to do something similar in a report? I need to be able to call a java operation passing the code, group and language and then use the correct display text. But if i do this for each label then it could be consuming. Or would it be easier to pass a list (Map) to the report and use it that way. A lot of our reports will be ran from Java code and supplied with either a db connection or a JRBeanCollectionDataSource dependant on how we created the report in the first place. Any suggestions? Cheers Carl Post Edited by croutledge at 05/08/2009 05:54

Giulio, Just tried it with a jar file and the refresh works just fine that way. So i created a jar, previewed the report. Changed the Java code to a new value, created the jar and refreshed the preview and it was updated. Would be handy to have this work with a folder as i'm using RAD and i wouldn't normaly create a JAR file. Thanks for help Carl

Fantastic. I didn't realise you can double click on an object to see its attributes and then add these as a selectable field. Thanks for the help. Carl

What do you mean by map? I just tried changing a field from $F{packCodeMD}.getId(), which works, to $F{packCodeMD.id} and it doesn't work. I get a line in the Report Problem Window saying File Not Found: packCodeMD.id. In the report output window i get: - net.sf.jasperreports.engine.design.JRValidationException:ÂReportÂdesignÂnotÂvalidÂ:Â ÂÂÂÂÂ 1.ÂFieldÂnotÂfoundÂ:ÂpackCodeMD.id ÂÂÂÂ atÂnet.sf.jasperreports.engine.design.JRAbstractCompiler.verifyDesign(JRAbstractCompiler.java:262) ÂÂÂÂ atÂnet.sf.jasperreports.engine.design.JRAbstractCompiler.compileReport(JRAbstractCompiler.java:144) ÂÂÂÂ atÂcom.jaspersoft.ireport.designer.compiler.IReportCompiler.run(IReportCompiler.java:525) ÂÂÂÂ atÂorg.openide.util.RequestProcessor$Task.run(RequestProcessor.java:561) ÂÂÂÂ atÂorg.openide.util.RequestProcessor$Processor.run(RequestProcessor.java:986

This seems weird. I put some try catch in the code and added the field to the available fields in the report and it seemed to preview just fine. So i added the actual field to the report and called the appropriate get inside it to access the object data and it previewed just fine. So i removed the try catch code from the class and it still worked...strange.

I have included the folder to the class in the classpath and set it to reloadable and it still won't refresh the data until i close iReport and start again. Does it need to be in a jar file? I find it easier to add the folder the java project is in, into the classpath so i don't always have to export it to a jar. Cheers

I have created a JavaBeans set datasource to load some test data so i can preview my report in iReport. But if i amend the code in the Java Class it will only show the new data in the Preview in iReport if i close iReport and start it up again. Is there any way to get around this? No matter how many times i click refresh it won't pull the new data in.

I'm using fields pulled into the report using a JavaBean DataSource. So i put in the full path of the Bean and it pulls the fields that i can choose from into the available fields menu. Now if i just then do a preview of the report, nothing added to it, i get the following error: - Error filling print... Error retrieving field value from bean : currentPalletLocation net.sf.jasperreports.engine.JRException: Error retrieving field value from bean : currentPalletLocation at net.sf.jasperreports.engine.data.JRAbstractBeanDataSource.getBeanProperty(JRAbstractBeanDataSource.java:123) at net.sf.jasperreports.engine.data.JRAbstractBeanDataSource.getFieldValue(JRAbstractBeanDataSource.java:100) at net.sf.jasperreports.engine.data.JRBeanCollectionDataSource.getFieldValue(JRBeanCollectionDataSource.java:104) at net.sf.jasperreports.engine.fill.JRFillDataset.setOldValues(JRFillDataset.java:807) at net.sf.jasperreports.engine.fill.JRFillDataset.next(JRFillDataset.java:771) at net.sf.jasperreports.engine.fill.JRBaseFiller.next(JRBaseFiller.java:1413) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReport(JRVerticalFiller.java:111) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:899) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:821) at net.sf.jasperreports.engine.fill.JRFiller.fillReport(JRFiller.java:89) at net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:628) at net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:544) at com.jaspersoft.ireport.designer.compiler.IReportCompiler.run(IReportCompiler.java:921) at org.openide.util.RequestProcessor$Task.run(RequestProcessor.java:561) at org.openide.util.RequestProcessor$Processor.run(RequestProcessor.java:986) Caused by: java.lang.reflect.InvocationTargetException 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.commons.beanutils.PropertyUtilsBean.invokeMethod(PropertyUtilsBean.java:1773) at org.apache.commons.beanutils.PropertyUtilsBean.getSimpleProperty(PropertyUtilsBean.java:1132) at org.apache.commons.beanutils.PropertyUtilsBean.getNestedProperty(PropertyUtilsBean.java:686) at org.apache.commons.beanutils.PropertyUtilsBean.getProperty(PropertyUtilsBean.java:715) at org.apache.commons.beanutils.PropertyUtils.getProperty(PropertyUtils.java:290) at net.sf.jasperreports.engine.data.JRAbstractBeanDataSource.getBeanProperty(JRAbstractBeanDataSource.java:115) ... 14 more The code in the getter part of that attribute on the bean is as follows: - // begin-user-code if (getCurrentPalletLocationList().isEmpty()) { return new PalletLocation(); } else { return getCurrentPalletLocationList().iterator().next(); } // end-user-code So it will be returning an empty PalletLocation i guess. Even when i used that field on the report and amend it to call the correct getters on the attributes to return a String, Integer or whatever i still get the error. So the report won't compile i guess. Is there someway of getting around this because when i do pass it a list of my data these will be filled in and not null and even then you can choose for the report to display empty when it is null. So it seems like a problem reading the getters of the fields of added to the report. Any help is much appreciated. Carl

I'm trying to use a list of my domain objects to create reports. I've been able to get the fields listed from the domain objects and can drag them on to a report. But when one of the properties is another domain object ireport is unable to see the getters in that object for me to call. i have to manually change it to $F{order}.getId() for example. Is this the only way of doing it or is it possible for ireport to provide some sort of context assist?

I'm using iReport 3.5.0 and trying to create a Hibernate Datasource. I've added the Hibernate3.jar file to the ClassPath through Tools -> Options. In there i've also added two folders. One has my domain objects (POJO's) and the other contains the Hibernate config file and each config file for the objects. I then go to add a hibernate datasource, click the test button and get the following error: - Error reading resource: <full package path><the xml file> I've commented things out of the file to try and find what is causing the issue because it will process some of my files. It is having a problem with the following: - < composite-id mapped="true" class="ArrayCodeId"> <key-property name="group" column="group" type="java.lang.String"></key-property> <key-property name="code1" column="code1" type="java.lang.String"></key-property> <key-property name="code2" column="code2" type="java.lang.String"></key-property> </composite-id>If i change my hibernate config file to ignore this file it hits an error on another file. From commenting out somethings in that file it is the following causing the problem as well: - < version name="versionId" generated="always" column="version_id" />Does anybody have any idea's why these are causing problems? Cheers Carl

Hi, I have created a report in iReports and i can import and print it via JasperReports. What i want to be able to do is not supply a query at design time. I would like to run my query through my Java DB layer not in the Report. The only way i've found this to work is by using a simple query like "SELECT 1 FROM DUAL;" and then using params for each piece of data i want to use on the report. The params part is exactly how i want it to work but if i don't specify the query at design time when i then print the report i get a blank page because of the setting in report properties. If i don't specify this setting i get a weird Java Exception error because there is no pages. So my question is really is there a way to not specify the little query at design time and have the report populated entirly by parameters. I've read a couple of posts from people with similar requests but no reponses. Cheers Carl Post edited by: croutledge, at: 2007/12/07 14:31

Was a solution found for this? I'm hitting this problem as well. I have created a report in iReport using the latest Java version. the report is a simple test with a barcode on filled with from a DB field. In iReport the preview works fine. I'm now using this in a Application on Websphere and i'm getting this error. I know the project is set to use Java 1.4...could this be the problem? Cheers