pumaking

Hi, due to my lack of Java/Groovy knowledge I have to ask how to create a printwhen expression with a and/or condition. Example: $F{Field1}==1 and $F{Field2}!=0 Does someone know the syntax?

Hi, I want to generate a template on which basis I can create new reports. For just the report iteself this is not a problem. But I want to include the ressources and input controls. I tried this: I can create a folder called "templates". Herein I create the report that I want to use as a template with all the ressources. Now I can copy this report to the folder where I want to create the final report. The problem is that the report-ID remains the same and I cannot change this. This is not elegant, I want to create a report based on my template AND I want to give a new ID to it. How can I achieve this?

Yes, I get all scheduled reports that are blank. When I run of of these reports manually, they are empty. So it definitely has to be a bug. The problem is that the tracker seems to be offline at the moment... OK, that helped me a bit. I removed the barcode and now I see the problem: When I pass the articleno that is a number then the report doesn't take it over. So only if I use an article no in the format 1111.22.33.4444 it works. As said, in the 4.0 version this worked also with the "number" articlenumbers. Do have another idea what I can do? I also tried to put the articleno in " and ' but that doesn't help either.

Hi, I recently upgraded to 4.5.0 (from 4.0.0) and I found two issues that 4.0.0 didn't have: I schedule some reports. For many of them I have a schedule which mails the reports at a specific time. For those I set the option to skip empty reports. Now after the upgrade to 4.5.0 I get some empty reports via email. Before, 4.0.0 skipped those. The second one requires a bit more explanation: We use an external program on our clients that directly opens Internet Explorer with a URL as parameter to open a specific report as PDF. Before this worked without a problem. Here are the details: This is the URL that IE opens: http://jasperserver:8080/jasperserver/flow.html?_flowId=viewReportFlow&reportUnit=/deparmtent/report&j_username=xxx&j_password=xxx&decorate=no&articleno=378402640010&company=xxx&sparepart=0&output=pdf With that one, I get the error that I attached as file. The problem relates to the article number. When I have an article number that is not a number (e.g. 4668.01.64.0000) then it works without a problem. The second weird thing is that when I run the report from the webinterface manually with e.g ' 378402640010' the report runs without problems. I already tried setting the article number in ' or " but that also doesn't work.

OK, done. Thanks for the info. Unfortunately there's no hint when this will be implemented...

Hi, I want to export a scheduled report to an FTP server. Has anyone done this before or is it definitely not possible?

Hi, I have enourmous performance problems with Ireport 4.1.3 and 4.5.0. I use Jasperreports server 4.0.2 and load the reports via the repository navigator. Java is installed in version 1.60_23, I user Win7 X64 and have quite a performant workstation with 8 GB Ram and a Core i7-CPU. I measured the time it takes to open a quite complex report: 4.0.1: 7 seconds 4.1.3: 96 seconds 4.5.0: I killed the process after it was loading 5 minutes... Btw: I imported the settings from 4.0.1 to the other versions, so everything should be configured the same. Ireport compatibility is set to 4_0_1. Someone an idea what goes wrong here?

Hi, thanks for your answer. I solved it by putting the calculation into the textfields and not in the variables.

Hi, we ran Jasperserver 3.0 for some time now. Now I set up a new server with Jasperreports Server 4.0. I now manually moved the reports which we use to the new server. So far eveything OK. But now I have one report which doesn't run on the new server: com.jaspersoft.jasperserver.api.JSExceptionWrapper: Error evaluating expression : Source text : 100 / $V{SumUm} * $V{SumDB1} I can run the report locally in Ireport without problems and it also still runs on the 3.0 server. I don't understand this as I use exactly the same jrxml files and the datasource is also the same. Does someone have an explanation for this behaviour?

Hi, I now tried to export the repository first and I get the following error: Exporting repository resource /Alle_Abteilungen/Ersatzteilinfo 08:29:25,610 ERROR JDBCTransaction:198 - Could not toggle autocommit java.sql.SQLException: Unknown character set index for field '-13765' received from server. at com.mysql.jdbc.Connection.getCharsetNameForIndex(Connection.java:3274) at com.mysql.jdbc.Field.<init>(Field.java:159) at com.mysql.jdbc.MysqlIO.unpackField(MysqlIO.java:644) at com.mysql.jdbc.MysqlIO.getResultSet(MysqlIO.java:414) at com.mysql.jdbc.MysqlIO.readResultsForQueryOrUpdate(MysqlIO.java:1991) at com.mysql.jdbc.MysqlIO.readAllResults(MysqlIO.java:1413) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1757) at com.mysql.jdbc.Connection.execSQL(Connection.java:3020) at com.mysql.jdbc.Connection.setAutoCommit(Connection.java:4989) at org.apache.commons.dbcp.DelegatingConnection.setAutoCommit(DelegatingConnection.java:268) at org.apache.commons.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.setAutoCommit(PoolingDataSource.java:293) at org.hibernate.transaction.JDBCTransaction.toggleAutoCommit(JDBCTransaction.java:194) at org.hibernate.transaction.JDBCTransaction.rollbackAndResetAutoCommit(JDBCTransaction.java:186) at org.hibernate.transaction.JDBCTransaction.rollback(JDBCTransaction.java:162) at org.springframework.orm.hibernate3.HibernateTransactionManager.doRollback(HibernateTransactionManager.java:581) at org.springframework.transaction.support.AbstractPlatformTransactionManager.processRollback(AbstractPlatformTransactionManager.java:745) at org.springframework.transaction.support.AbstractPlatformTransactionManager.rollback(AbstractPlatformTransactionManager.java:722) at org.springframework.transaction.interceptor.TransactionAspectSupport.completeTransactionAfterThrowing(TransactionAspectSupport.java:325) at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:111) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:176) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:210) at $Proxy1.findResource(Unknown Source) at com.jaspersoft.jasperserver.export.modules.repository.ResourceExporter.getFolderResources(ResourceExporter.java:203) at com.jaspersoft.jasperserver.export.modules.repository.ResourceExporter.exportFolder(ResourceExporter.java:187) at com.jaspersoft.jasperserver.export.modules.repository.ResourceExporter.exportFolders(ResourceExporter.java:252) at com.jaspersoft.jasperserver.export.modules.repository.ResourceExporter.exportFolder(ResourceExporter.java:191) at com.jaspersoft.jasperserver.export.modules.repository.ResourceExporter.exportFolders(ResourceExporter.java:252) at com.jaspersoft.jasperserver.export.modules.repository.ResourceExporter.exportFolder(ResourceExporter.java:191) at com.jaspersoft.jasperserver.export.modules.repository.ResourceExporter.processUri(ResourceExporter.java:162) at com.jaspersoft.jasperserver.export.modules.repository.ResourceExporter.process(ResourceExporter.java:121) at com.jaspersoft.jasperserver.export.ExporterImpl.invokeModules(ExporterImpl.java:174) at com.jaspersoft.jasperserver.export.ExporterImpl.process(ExporterImpl.java:139) at com.jaspersoft.jasperserver.export.ExporterImpl.performExport(ExporterImpl.java:119) at com.jaspersoft.jasperserver.export.ExportCommandImpl.process(ExportCommandImpl.java:57) at com.jaspersoft.jasperserver.export.BaseExportImportCommand.process(BaseExportImportCommand.java:87) at com.jaspersoft.jasperserver.export.ExportCommand.main(ExportCommand.java:43) Any idea?

Hi, I set up a new server with an installation of 4.0. Now I want to migrate the repository from my old 3.1 installation to the new one. Is this possible and if yes how?

Thanks for the quick reply. This is exactly what I wanted, it works. Thank you very much!

Hi, we need to create a report in which all data from the current date is displayed. The field in the database which I compare it against has the following format: 20100701 and is a big decimal. Now I created several parameters to find out the current date in Ireport: currentdate: java.util.Date - new java.util.Date() Now I convert it to a string with the following parameters: currendate_year: java.lang.String - $P{currentdate}.getYear()+1900 currendate_month: java.lang.String - $P{Datumheute}.getMonth()+1 currendate_day: java.lang.String - $P{Datumheute}.getDate() I don't know why but with the function getmonth I need to add a month because otherwise it's the month before the actual month. With this parameter I connect the values to the decimal value as it is in the database: currentdate_decimal: java.lang.String - $P{currendate_year} + "0" + $P{currendate_month} + $P{currendate_day} However, as you can see, I have to add a "0" to the month, because for month july the function only returns "7" and not "07". The same problem do I have with the days, here I also get lack of the "0". For the months I could change that twice a year but for the days this work is too annoying. Does anybody have an idea how to get rid of this problem in a better way?

Hi, we have a report with a filed that contains the excel date format. That means it'a a big decimal field with the value "40144" (27.11.2009) for example. How can I display this field in Ireport in the correct date format? Is this possible without changing the format of the data source?

Hi, I am wondering if it's possible to create a report counter. That means that I want to have a continuous number that I print on my report every time I open it. I create the reports with Ireport and run them from Jasperserver. Does someone have an idea how to realize this?

Hi, I've got a problem with a UNC image path which comes from the database. I work with these absolute paths from the database in other reports without any problem. But now I got the following error: com.jaspersoft.jasperserver.api.JSExceptionWrapper: Byte data not found at location : \\server\share\folder\file.jpg When I copy the path in the error message and paste in in windows explorer the file is shown without any problem. I also tried to manually add the file to the report as a static image to see if there could be a problem with the file itself. This works perfectly. So I thought if there is perhaps an empty space in the path which comes from the database. So I put the image expression together from the foldername and the filename which also comes from the database: "\\server\share\folder\" + $F{Imagename} With that I get the following error: com.jaspersoft.jasperserver.api.JSExceptionWrapper: net.sf.jasperreports.engine.JRException: Errors were encountered when compiling report expressions class file: 1. Invalid escape sequence (valid ones are \b \t \n \f \r \" \' \\ ) value = (java.lang.String)("\\server\share\folder\" + ((java.lang.String)field_Imagename.getValue())); //$JR_EXPR_ID=12$ So I tried: "\\server\\share\\folder\\" + $F{Imagename} Now the error is again (because the backslash appears only one time in the beginning): com.jaspersoft.jasperserver.api.JSExceptionWrapper: Byte data not found at location : \server\share\folder\file.jpg My next try was this one: "\\\server\\share\\folder\\" + $F{Imagename} And now again this error: com.jaspersoft.jasperserver.api.JSExceptionWrapper: net.sf.jasperreports.engine.JRException: Errors were encountered when compiling report expressions class file: 1. Invalid escape sequence (valid ones are \b \t \n \f \r \" \' \\ ) value = (java.lang.String)("\\\server\share\folder\" + ((java.lang.String)field_Imagename.getValue())); //$JR_EXPR_ID=12$ How can I solve this problem?

Hello, I have a quite complicated concern. Follwing conditions: I have a jasperserver (v.3.1) where I created a folder called "Ressources". In this folder I created some subfolders called "Templates", "Querys", "Images" and "Input Controls" where I put generally available templates for the according ressource types. Within iReport I can create references to these generally available ressources. The first problem is that I cannot reference to a query, I get the error message: 1-jsexception.resource.of.type.not.found So is my intention to use only one query for every report not possible? I know that I can edit the report manually in the jasperserver repository and change the report query to one which exists in the repository. But that way I can't ahndle it with iReport. My second problem or question is how to create a report unit template. I can only copy a existing report unit within jasperserver to another folder. The problem is that the name stays the same, I can only change the label. The intention of a template is to create a new report unit based on the template with the new name. Of course I could use a jrxml template in iReport but with that I don't have the ressources for the report unit in jasperserver. To simplify it, the way to create new reports for our report editors should be as described: Create a new report unit based on a report unit template where all the ressources from the repository are already available. Is there a way to achieve this goal?

Hi, thanks for your reply but I think this gets a bit too complicated for our purposes. Isn't it possible to use this translation also for the new version?: http://jasperforge.org/jasperbabylon/langdetails.php?appid=1&lang=de Most of the terms should be the same.

Hi, in the classic version of IReport 3.0.0 there was a plugin "translation status" with which I could import the translations from JasperBabylon. I don't find this plugin or feature in version 3.5. I want to localize it to german. I also searched in the options but I can't find a language option anywhere. Some menus even are translated to german in my version but the main elemtents as report elements and properties are still in english language. We plan to deploy IReport to some End-users who should edit some reports. Therefore I think that version 3.5 is more user-friendly than the classic version. so it would be great to have the new version translated. Perhaps I'm doing something wrong or I overlooked something?

Hi all, I am wondering if it's possible to update a data set with SQL with IReport/Jasperserver? The problem is that I need to know whether a report is already generated or not?

Hello, I have found out how to call a report with parameters directly in Firefox 3.0 with the following syntax: start firefox.exe "http://server/jasperserver/flow.html?_flowId=viewReportFlow&reportUnit=/report&j_username=admin&j_password=pwd&decorate=no&output=pdf&Artikelnummer=1234&Firma=company&Ersatzteil=0" This works very well but the problem is that Internet Explorer 7 is our default browser in the company. but when I run the command with "start iexplore.exe" it opens the internet explorer and the URL is displayed correctly but then an error is displayed: "navigation to this site was cancelled" (translated from german). Does anyone know how this works with IE7?

Hello, up to now I'm working with IReport 2.0.5 which includes support to generate barcodes. Now I'm testing iReport 3.1.4 NB and I don't find the barcode feature anymore. Do I have to use the old version of IReport when I want to use barcodes or is there a possibility to get barcodes working in the new one?

I thought that is is going this way. Isn't there a possibility to change the order directly in mysql? Also I have another question regarding input controls: When I create the input controls, I can enter a description. How can this description be displayed to the user? I need to explain some of my input control fields.

Hello, I have a simple question: Is it possible to change the order of the input controls I created in Jasperserver?

Hello, so far I got started well with Ireport and Jasperserver. The first quite complicated reports are running very well. Now I want to add the function that a print status is set in the database where I get the data from. So I would have to execute a simple sql like UPDATE table SET XY=50 WHERE Number=1234. The problem is I have no idea how to implement this in Ireport/Jasperserver. I searched the forum and found a similar request which wasn't answered yet. Perhaps anyone has an idea how I can do that.