fenix4life

Does anyone has an idea which correction (SVN number of timestamp) can be linked to the correction of the sheet names in XLS(X) export. Version 5.0.1 exports those names incorrectly and 5.5.0 is correct. I've been able to track that the correction has been made between version 5.2.0 and 5.5.0. Reason why I'm looking for this, is that I would like to merge those changes back on 5.0.1 Regards

Does anyone had any luck when using the PPTX exporter?

Hello, I'm having some issue's in testing the export to PowerPoint. Whatever the content of the document is it always results in a "Powerpoint is unable to open... corrupt ....". I've found a page mentioning that this could be related to a char(0) problem. Now I've made a very small document only contain 1 statis text but even this export is failing. Do I need to perform something specific to make this work? I've added my small example as an attachment.

Hello, Is there any property/setting available which enable 'strecht with overflow' but avoids words to be split in half when wrapping to a secon dline. Currently we have a situation where a licenseplate is being split in half. I would rather have that the licenseplate is kept together. Current result: This is a test 1-BUG -569 for a text with a licenseplate. Requested result This is a test 1-BUG-569 for a text with a licenseplate.

Hello, It looks like I'm having problems using the 'print order' horizontal columns together with a print when expression. From a recordset I need to remove a record before displaying the result into 2 columns. When I use display in 1 columns or 2 columns in combination with vertical everything goes fine. Result 2 3 4 5 When I use vertical as a print order it looks like the first item is still being displayed. Result 2 3 4 5 I would have expected 2 3 4 5 Anyone with an idea how to solve this issue. I need to display this in vertical as I don't really know how many records will be shown in the end.

It looks like there is a small difference between the groovy version used in the iReport zip file and the one present in the jasperreports projects. iReport contains version 1.7.5 and the jasperreports project contains version 2.0.1. Which version should be used? Is it better to upgrade the jar to 2.0.1 having both containing identical sources? (In recent iReport/Jasper it now both uses 2.0.1) Regards,

Any idea if it's normal that 3 of the 6 defaults have the same output when exporting to PDF? This would mean that we always have to use Font Extensions to be sure of the exported result

Thank Lucian. I got a bit confused within iReport. When adding the /* and later the closing */ it underlines the / giving the impression that it concerns an error in the syntax.

Hello, It is possible to add comments in expressions. I've tried with /* */, // , -- but they all did not seem to accept those. Any idea if this is possible. Thx,

Hello, Just a quick question regarding the export behaviour to PDF with the available fonts. I know that fonts like Arial, Times new Roman (all below the line in iReport) are not available when exporting to PDF. (When using such a font you have a - font xxxx not in JVM - error.) In such a case you need to create a jar file on the classpath with the truetype fonts. However I do not understand that some of the default fonts can also not be exported to PDF. Should I do something specific. I would really have thought that the default font like SansSerif - Arial equivalent- would be exportable to PDF? Second question. Does someone have the mapping of the 6 fonts. DejaVu Sans -> ? DejaVu Sans Mono -> Verdana DejaVu Serif -> ? Monospaced -> Courier New SansSerif -> Arial Serif -> Times New Roman

Changed Assigned User from - to @User_306070

Hello, any idea on how to access some POI functions within JasperReports. I'm trying to have a crosstab with as a content the result of the PMT function. I've added the POI 3.9 in my classpath and created a dynamic field with the following content new org.apache.poi.ss.formula.functions.FinanceLib().pmt($P{PAR_INTERESTRATE}, $F{duration}, $F{catalogprice}, $F{catalogprice_rv}, false) => returns 'The constructor FinanceLib() is not visible' I've tried directory org.apache.xxxx.pmt without the new but this also does not work. Any idea on how this might be possible. Or maybe an alternative way to calculate the PMT value THx

Hello, I've just created a Chart Theme to define once a set of colors and fonts to be used in the jfreecharts that will be used within JasperReports. All charts seem to be using the update color series from the altered Plot however the Meter Chart remains black. Whatever settings/color I change in the the chart theme (even those not related to the Plot section) they seem to have no effect on the Plot Meter. Is the Meter chart changeable using a Chart Theme. I would presume yes as for instance the sixties theme has a different layout. Unfortunattely I'm not able to open the jrctx file from the sixties template. Regards

I've created a stripped out version of the report and select statement based upon a load of the content of the data mentioned in the xls file into an Oracle database

Apparently a similar issue was report @ iReport tracker (number 0004567 and 0004873) I'm currently using variants of the sort / group by clause which results in the same dataset but still without luck to be using the 'Data is presorted'. Removing this flag results in a 'Heap issue' as I'm processing rather a lot of records.

Hmm, a bit of a double feeling there. It's indeed correct that removing that flag is resulting in correct values however I've created my query such that the data returned by the database is sorted in the way, I think, it needs to be processed. In this crosstab I have 1 line for every vehicle and then for every Year (sort asc), every month (sort asc). The data returned by the SQL (shown in the excel) is effectively sorted on vehicle (only 1) year and month. In the last column you can see the months and years going up like a regular calendar. I added this sort statement to avoid any possible performance issue during report generation as I think sorting is quicker if I let the Oracle database perform this.

Case can be closed found it :-)

Hello All, We have deployed an identical application from WebSphere to WebLogic. At first view everything is working except 2 reports who are rather identical. It looks like WebLogic has issues with XML as a DataSource where this issue was not existing in WebSphere. Source text : $F{SUN_CNTRCT_EXPECTEDENDDATE} Stacktrace: net.sf.jasperreports.engine.fill.JRExpressionEvalException: Error evaluating expression : Source text : $F{SUN_CNTRCT_EXPECTEDENDDATE} at net.sf.jasperreports.engine.fill.JREvaluator.evaluate(JREvaluator.java:193) at net.sf.jasperreports.engine.fill.JRCalculator.evaluate(JRCalculator.java:570) at net.sf.jasperreports.engine.fill.JRCalculator.evaluate(JRCalculator.java:538) at net.sf.jasperreports.engine.fill.JRFillElement.evaluateExpression(JRFillElement.java:868) at net.sf.jasperreports.engine.fill.JRFillTextField.evaluateText(JRFillTextField.java:368) at net.sf.jasperreports.engine.fill.JRFillTextField.evaluate(JRFillTextField.java:353) at net.sf.jasperreports.engine.fill.JRFillElementContainer.evaluate(JRFillElementContainer.java:256) at net.sf.jasperreports.engine.fill.JRFillBand.evaluate(JRFillBand.java:482) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillTitle(JRVerticalFiller.java:308) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReportStart(JRVerticalFiller.java:244) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReport(JRVerticalFiller.java:110) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:923) at net.sf.jasperreports.engine.fill.JRFiller.fillReport(JRFiller.java:119) at net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:435) at be.sofico.basecamp.sys.document.engines.SofJasperReportEngine.generateDocument(SofJasperReportEngine.java:149) at be.sofico.basecamp.sys.document.DocumentMgrBean.generateDocument(DocumentMgrBean.java:679) at be.sofico.basecamp.sys.document.DocumentMgrBean.generateDocument(DocumentMgrBean.java:634) at be.sofico.basecamp.sess.document.DocumentSessionBean.generateDocument(DocumentSessionBean.java:118) at be.sofico.basecamp.sess.document.DocumentSession_rbfvxs_EOImpl.__WL_invoke(Unknown Source) at weblogic.ejb.container.internal.SessionRemoteMethodInvoker.invoke(SessionRemoteMethodInvoker.java:40) at be.sofico.basecamp.sess.document.DocumentSession_rbfvxs_EOImpl.generateDocument(Unknown Source) at be.sofico.basecamp.sess.document.DocumentSession_rbfvxs_EOImpl_WLSkel.invoke(Unknown Source) at weblogic.rmi.internal.BasicServerRef.invoke(BasicServerRef.java:667) at weblogic.rmi.cluster.ClusterableServerRef.invoke(ClusterableServerRef.java:230) at weblogic.rmi.internal.BasicServerRef$1.run(BasicServerRef.java:522) at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:363) at weblogic.security.service.SecurityManager.runAs(SecurityManager.java:146) at weblogic.rmi.internal.BasicServerRef.handleRequest(BasicServerRef.java:518) at weblogic.rmi.internal.wls.WLSExecuteRequest.run(WLSExecuteRequest.java:118) at weblogic.work.ExecuteThread.execute(ExecuteThread.java:207) at weblogic.work.ExecuteThread.run(ExecuteThread.java:176) Caused by: org.codehaus.groovy.runtime.typehandling.GroovyCastException: Cannot cast object '2014-02-01 12:00:00' with class 'java.lang.String' to class 'java.util.Date' at org.codehaus.groovy.runtime.typehandling.DefaultTypeTransformation.castToType(DefaultTypeTransformation.java:340) at org.codehaus.groovy.runtime.ScriptBytecodeAdapter.castToType(ScriptBytecodeAdapter.java:632) at Excess_Mileage_1314751202843_456954.evaluate(calculator_Excess_Mileage_1314751202843_456954:285) at net.sf.jasperreports.engine.fill.JREvaluator.evaluate(JREvaluator.java:182) ... 30 more The XML Datasource contains Dates which all have been formatted into a particular format. In this case YYYY-MM-dd hh:mm:ss As it was required we have also used in our application the default JRXPathQueryExecuterFactory.XML_DATE_PATTERN which was set accordingly (else it would not be working in WebSphere) I have found some other WebLogic/JasperReports issues (eg. http://grails-groovy.blogspot.com/2009/08/jasperreports-and-weblogic-deployment.html) Those however mention dependencies of jar files between those delivered by WebLogic and those used in the application. However the groovy jar is not present in the WebLogic application (only in our deployment) - at least I think - As a result I'm not really sure where to start ? Any one with an idea or hint where to start looking? Regards, Post Edited by fenix4life at 08/31/2011 13:49

Product Edition: Professional Product Version: 4.1.0 Build: 20110522_0312 License Type: Evaluation Expiration: 2011-09-25 23:59

We are currently having a look on the licensed version of Jasper. (In particular the fusioncharts abilities which are a bit better in comparison to jFreeChart). Now when we create the report in iReport and export in (x)html we have a nice output with only the chart in it. (Image 1) When we add the report from within JasperServer we have the same good result (Image 2) However if we create a Dashboard or use the viewasdashboardframe parameter an additional element is placed with the mention 'Report is empty'. This is rather strange as data is being shown? (Image 3 and 4) And idea what might cause this? Is this some kind of prevention mechanism?

Has anyone tried to upgrade the Mondrian engine delivered with jasper reports? We are having some issues which look to be mondrian related. Thos issues are however solved end 2010/beginning 2011. To be able to test those we would like to upgrade somehow the engine. I've tried to replace the mondrian jar added in the tomcat > webapps however this resulted in an error. Any ideas else I need to wait a next jasper version

It looks indeed that an issue was made during the upload. I Uploaded the document before saving the report :-). I've attached a new version of the report.

Anyone with an idea? What I would like to create is to setup of a connection possibility to access the OLAP schema from an external application (eg. iReport) Currently when I connect with iReport to this server I oncly can see the default foodmart/sugarcrm but not the analysis view which was added by myself Regards

Hello all, It looks like I'm experiencing difficulties to create a working XML/A connection. At this stage what we have done is: 1) create a analysis data source (JDBC) 2) create a analysis connection (Mondrian Connection) 3) create an analysis schema 4) create an analysis view We are currently able to use this additional OLAP connection in the embedded jPivot using the configured view. However what we are looking is to make this OLAP available using XML/A connection. What we tried is to create a Mondrian XML/A source connection for this. We used a couple of names as Catalog - schema name, connection names, but all of them resulted in no real difference. We still are only able to connect to the 2 default connections (sugarcrm and foodmart) Am I doing something wrong? Regards

Hello, Currently we have in our application the jasperreports-fontsxxx.jar included in our project for the PDF export. This is working like a charme. However now we have the question of adding some additional jars. For this we have created a jar using the 'export as extension' functionality within iReport. Now can we just add the resulting jar next to the existing one or should we create a new jar with the content of both. Now sure is 2 instances of jasperreports_extensions.properties may exists. Regards