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).

I am not sure if it helps, but maybe you can use JRHtmlExporterParameter.HTML_HEADER parameter. I am not sure if it will work with jasper, but even if it does the quite big fallback is that you have to put that in your java code as HtmlExporter parameter, so for each report generated to html (if you have just one object of exporter) Also remeber that by default this parameter (HTML_HEADER) keeps default html header (all between and tags - don't forget to include that in your code)

I am quite new to jaspereports but the only way I know is subreporting (making 3 different subreports)

Well, I am not an expert in this matter, but I am afraid it is not possible with jasperreports API. The solution should be possible to obtain with some external XML templating tool, like Velocity. There is a great article (accessible from jasperreports Docs) about that: http://www.ibm.com/developerworks/websphere/library/techarticles/0505_olivieri/0505_olivieri.html BTW: How are planing on generating multiple cascade styles for your report (just curiosity :) ) Post Edited by pawel_r at 09/04/2009 11:21

Try parameter for report_count ($P{REPORT_COUNT})

Put subreport in summary band (or any other, that suits your needs, but not details band). Everything, which is in detail band, will be printed as many times as number of records fetched from datasource

Thanks a lot, lucianc. It seems that was the reason I was getting some Warnings from jboss that I am not closing my connections.

... and you forgot to add link to the thread :) I think you meant this one: http://jasperforge.org/plugins/espforum/view.php?group_id=102&forumid=103&topicid=7414

I am experiencing similar problem. I just uploaded my ReportServlet - hope that seeing code will help. Thanks for spending your time on this matter Paweł

Hi I am developing application, which was written in icefaces (1.5). I would like to add reporting functionality using jasperreports. Unfortunatelly, after long search I haven't found satysfying solution till now. The most popular way to integrate icefaces and jasperreport seems to be with ice:outputResource tag, as described in this thread: http://jasperforge.org/plugins/espforum/view.php?group_id=102&forumid=103&topicid=59388 Unfortunately, this tag comes with 1.7.2 version. The project, which I am working on, is already deployed and a lot stuff connected with icefaces was prepared to suit our needs. In other words -upgrading to newer version would be really time consuming. When it comes to icefaces 1.5 I found a solution by adding javascript code, which calls from backing bean a new window (as in code below) What I forgot to mention - I need to parametrize report, so passing all parameters in url brings security issues (reports have to be personalized depending on user rights). I tried to simply generate report in backing bean. I put pdf content, generated by jasper egnine to outputstrem (Servlet output stream -see code below). Then I used method responseComplete() to make sure that no other output will be generated. This code worked fine with in java server faces, but when I started using icefaces it just hangs the page for a moment and there is no change to the view (everything works like there was no action). I know it is more topic for icefaces forum, but I hope that someone had similar porblem and can help. Code:(Javascript call from backing bean, catched by servlet generating report)JavascriptContext.addJavascriptCall(fcontext, "window.open (\"raport.jasper"+paramUrl+"\");"); (raport generated in backing bean) FacesContext fcontext= FacesContext.getCurrentInstance(); ExternalContext context = fcontext.getExternalContext(); HttpServletResponse response = (HttpServletResponse)context.getResponse();(...)ServletOutputStream out = response.getOutputStream(); JasperReport jasperReport; if(filename.endsWith("jrxml")){ JasperDesign jasperDesign = JRXmlLoader.load(reportStream); jasperReport = JasperCompileManager.compileReport(jasperDesign); jasperPrint = JasperFillManager.fillReport(jasperReport, parameters,connection);response.setContentType("application/pdf"); exporter = new JRPdfExporter();exporter.setParameter(JRExporterParameter.JASPER_PRINT, jasperPrint); exporter.setParameter(JRExporterParameter.OUTPUT_STREAM, out); exporter.exportReport(); out.close(); fcontext.responseComplete();

Unfortunatelly, it is not clear for me at all. If I understood the report from the same pdf file is printed differently. That would suggest problem with driver, since pdf file always look the same. Possibly, it can be also problem with margins settings in your report. Please claryfi your problem.