pawel_r

It seems I found answer for my question - Jfree chart doesn't allow Date to be value for bubble chart axis http://www.jfree.org/jfreechart/api/javadoc/org/jfree/chart/ChartFactory.html#createBubbleChart(java.lang.String,%20java.lang.String,%20java.lang.String,%20org.jfree.data.xy.XYZDataset,%20org.jfree.chart.plot.PlotOrientation,%20boolean,%20boolean,%20boolean) Even though if someone has an idea how to make the Date values as much human readible as possible please share it :)

Hi I was looking for a way to put Date on the domain axis of the Bubble chart. I found a suggestion that possibly a chart theme can be a solution here but I am a little lost with example in dist/sample directory -they all seem to only change how chart looks, not what kind of data can be parsed by it. I was trying to do some kind of trick, like putting Date as category, unfortunatelly Bubble chart doesn't have such posibility. The best I got was to simply do $F{SOME_DATE}.getDate()*100+$F{SOME_DATE}.getMonth() but I would like to be able to put it in more readible form (with some separetor between day and month). Is that possible? I am looking for any clue which could potentially be leading to better solution

Well, as far as I know it depends only on browser setting. There is no way to set such behavior from server side (not in jasper niether in anything else) HTH Paweł

Have you also updated all libraries nedded by jasperreports during migration? Maybe there are some additional dependencies, which you forgot to add? I am more guessing than really knowing the issue. Try to add following library to your project http://mirrors.ibiblio.org/pub/mirrors/maven/log4j/jars/log4j-1.1.3.jar

Hi I have prepared report with 3 charts. First is showing all data, second all data wich have type set to type1, and third all data with type set to type2. I am using filtering expressions for charts 2 and 3. The problem is, that even though those charts have been copied from first one (Ctrl+C,Ctrl+V), the first two are showing correct data and the third one is empty. I was sure that it is my spelling mistake with filtering expression, however I checked it multiple times and it is correct (there are some records fetched with type set to type2). I am also ordering data by type. I am attaching full jrxml file. Post Edited by pawel_r at 09/15/2009 08:14

I am using iReport (v 3.6) and in its library directory I see groovy-all-1.5.5.jar, so I assume it is versios 1.5.5 :) Changing to java generates an error, since Java doesn't allow non explicit casting from oracle.sql.timestamp to java.sql.timestamp (and unfortuantelly I am using groovy capabilities in many other places - I will prepare a separate report to check taht issue) Oracle driver is ojdbc14.jar Thank you for response Post Edited by pawel_r at 09/15/2009 08:07

On each text field check the encoding. The default is cp1252 (Western Europe). I had exactly the same problem with encoding - I changed it manually to Western Europe (cp1500) and I had Polish characters. I am not sure what codepage uses Windows in Portugal, but I am sure you will find the right one :) By the way, there is option defaul encoding hidden in configuration in iReport(Options/General/Jasperproperties/net.sf.jasperreports.default.pdf.encoding for pdf and net.sf.jasperreports.export.character.encoding for others). Unfortunately, for me it worked only for "new" fields (it seemed that in all the encoding was changed but there was no effect until I changed it again, manually, field by field) HTH Paweł

Thanks Matt However I think you misunderstood my question a little. Yes, generally I know how to use variables in jasperreport. The problem is that I don't see a way how my data can fall into 2 categories at ones (like "Car", "Truck", "All vehicles" - any car is an vehicle and any truck is an vehicle, so on the chart the "all vehicles" category would sum up the values of two previous). I know how to put those data on separate charts - but I would like to get it at single chart as additional category. (Writing this post I just realized I could change my chart and use series for this aim -however I am already using series for another king of grouping)

Hi I am fetching data from Oracle database (v 9.2) into my jasprereport (v 3.6.0). When I try to put a oracle.sql.timestamp(6) field into my report I get following error: org.codehaus.groovy.runtime.typehandling.GroovyCastException: Cannot cast object 'oracle.sql.TIMESTAMP@b20eb8' with class 'oracle.sql.TIMESTAMP' to class 'oracle.sql.TIMESTAMP' (details below) I don't quite get the reason of the error. I changed the field type to java.sql.timestamp and I removed quotation marks added by iReport. Anyone has faced similar problem? Code:ErrorÂfillingÂprint...ÂErrorÂevaluatingÂexpressionÂ: ÂÂÂÂSourceÂtextÂ:Â$F{DataÂwejÅ›ciaÂwÂstan} net.sf.jasperreports.engine.fill.JRExpressionEvalException:ÂErrorÂevaluatingÂexpressionÂ: ÂÂÂÂSourceÂtextÂ:Â$F{DataÂwejÅ›ciaÂwÂstan} ÂÂÂÂ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.fillColumnBand(JRVerticalFiller.java:1423) ÂÂÂÂatÂnet.sf.jasperreports.engine.fill.JRVerticalFiller.fillDetail(JRVerticalFiller.java:725) ÂÂÂÂatÂnet.sf.jasperreports.engine.fill.JRVerticalFiller.fillReportContent(JRVerticalFiller.java:272) ÂÂÂÂatÂnet.sf.jasperreports.engine.fill.JRVerticalFiller.fillReport(JRVerticalFiller.java:114) ÂÂÂÂatÂnet.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:908) ÂÂÂÂatÂnet.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:811) ÂÂÂÂatÂnet.sf.jasperreports.engine.fill.JRFiller.fillReport(JRFiller.java:59) ÂÂÂÂatÂnet.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:417) ÂÂÂÂatÂnet.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:247) ÂÂÂÂatÂcom.jaspersoft.ireport.designer.compiler.IReportCompiler.run(IReportCompiler.java:855) ÂÂÂÂatÂorg.openide.util.RequestProcessor$Task.run(RequestProcessor.java:561) ÂÂÂÂatÂorg.openide.util.RequestProcessor$Processor.run(RequestProcessor.java:986) CausedÂby:Âorg.codehaus.groovy.runtime.typehandling.GroovyCastException:ÂCannotÂcastÂobjectÂ'oracle.sql.TIMESTAMP@b20eb8'ÂwithÂclassÂ'oracle.sql.TIMESTAMP'ÂtoÂclassÂ'oracle.sql.TIMESTAMP' ÂÂÂÂatÂorg.codehaus.groovy.runtime.typehandling.DefaultTypeTransformation.castToType(DefaultTypeTransformation.java:340) ÂÂÂÂatÂorg.codehaus.groovy.runtime.ScriptBytecodeAdapter.castToType(ScriptBytecodeAdapter.java:632) ÂÂÂÂatÂtabela8_1252914922122_990236.evaluate(calculator_tabela8_1252914922122_990236:339) ÂÂÂÂatÂnet.sf.jasperreports.engine.fill.JREvaluator.evaluate(JREvaluator.java:182) ÂÂÂÂ...Â19ÂmoreÂ

Hi I am using grouping in order to put my data into 2 categories, but on the chart I would like to have also additional category, wich sums the values of two prevoius. Can it be done with jasperreports or I simply need to fetch additional field from database Regards Paweł

Yes, it did :) Sorry to make you trouble - it seems I havn't searched for this matter long enough :)

http://jasperreports.sourceforge.net/api/net/sf/jasperreports/engine/export/JRXlsAbstractExporterParameter.html#SHEET_NAMES Regards

Hi I was trying to make sure that all values displayed on chart are intergers (no label like "1,5" since I am counting things which cannot be divided :D ). I found a way - by putting # sign in field Value Axis Thick Label Mask, but then I noticed, that when there is no data (or small values) to display and chart is big enough I am getting single values multiple times. I realized (after over an hour looking for solution) that's all because of that mask (it simply cuts decimal endings). Is there any better way to fomat values on value axis in chart?

No solution, till now. The one I presented above is really easy to hack (I mean not registered user can get access to those data - that's definitely not acceptible in commercial application). I hope someone has found a better solution (well, if really migration to newer version of icefaces is needed than I am also interested in such solution). Till now I just get backing bean, which is geting the request from icefaces, but report is not generated :(

Hi I have following problem - I wanted to try the web example from demo/sample directory in order to see how jasperreports works. I built a war file using ant and putt it in jboss deploy directory. The web application seems to work fine, I get message that aplet works on my pc, but when I try launch it I get an error - "Error load object from URL ..." (details are in screenshot).