shainaztamboli

I am using Jasper iReport 4.7. Where I need to use a Table Component to show my column data.Only problem I faced is, number formatting over data inside the table,which not work if I use to pass Parameter in Pattern Expression.However I can set pattern directly but what i want to make my document multilingual.So I want to set number format according to locale, which I normally do to column directly using parameter (Columns outside Table component). Please help either with alternative or with solution.Thanks.

Hi All, I am exporting report in HTML format. The HTML report working fine with IE-8.0. But not working with firefox-10.0.2. Letters not displayed properly like 'g', underscore(_), etc. See the attached HTML files. Please help me to fixed this issue. Regards, Shainaz

Hi all, I am using internationalization with iReport. But having some problem with PDF export for UTF-8 Characters. I am not able to see the arabic, Chinese, Greece character in PDF. Can youn please tell me how to display multi language data in PDF. Regards, Shainaz

problem is solved now. I put crosstab in summary band. - Shainaz

hi all, I have a Report in that I have a crosstab and I am using custom data source for crosstab but I am getting following error when calling jasper report. SEVERE: Servlet.service() for servlet zkLoader threw exception java.lang.RuntimeException: net.sf.jasperreports.engine.JRRuntimeException: Error incrementing crosstab dataset at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source) at java.lang.reflect.Constructor.newInstance(Unknown Source) at bsh.Reflect.constructObject(Unknown Source) at bsh.BSHAllocationExpression.constructObject(Unknown Source) at bsh.BSHAllocationExpression.objectAllocation(Unknown Source) at bsh.BSHAllocationExpression.eval(Unknown Source) at bsh.BSHPrimaryExpression.eval(Unknown Source) at bsh.BSHPrimaryExpression.eval(Unknown Source) at bsh.BSHThrowStatement.eval(Unknown Source) at bsh.BSHBlock.evalBlock(Unknown Source) at bsh.BSHBlock.eval(Unknown Source) at bsh.BSHBlock.eval(Unknown Source) at bsh.BSHTryStatement.eval(Unknown Source) at bsh.BSHBlock.evalBlock(Unknown Source) at bsh.BSHBlock.eval(Unknown Source) at bsh.BshMethod.invokeImpl(Unknown Source) at bsh.BshMethod.invoke(Unknown Source) at bsh.BshMethod.invoke(Unknown Source) at bsh.Name.invokeLocalMethod(Unknown Source) at bsh.Name.invokeMethod(Unknown Source) at bsh.BSHMethodInvocation.eval(Unknown Source) at bsh.BSHPrimaryExpression.eval(Unknown Source) at bsh.BSHPrimaryExpression.eval(Unknown Source) at bsh.Interpreter.eval(Unknown Source) at bsh.Interpreter.eval(Unknown Source) at org.zkoss.zk.scripting.bsh.BSHInterpreter.exec(BSHInterpreter.java:119) at org.zkoss.zk.scripting.util.GenericInterpreter.interpret(GenericInterpreter.java:310) at org.zkoss.zk.ui.impl.PageImpl.interpret(PageImpl.java:796) at org.zkoss.zk.ui.impl.EventProcessor.process0(EventProcessor.java:176) at org.zkoss.zk.ui.impl.EventProcessor.process(EventProcessor.java:141) at org.zkoss.zk.ui.impl.EventProcessingThreadImpl.process0(EventProcessingThreadImpl.java:519) at org.zkoss.zk.ui.impl.EventProcessingThreadImpl.run(EventProcessingThreadImpl.java:446) Caused by: net.sf.jasperreports.engine.JRRuntimeException: Error incrementing crosstab dataset at net.sf.jasperreports.engine.fill.JRFillCrosstab$JRFillCrosstabDataset.customIncrement(JRFillCrosstab.java:665) at net.sf.jasperreports.engine.fill.JRFillElementDataset.increment(JRFillElementDataset.java:169) at net.sf.jasperreports.engine.fill.JRCalculator.calculateVariables(JRCalculator.java:152) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillDetail(JRVerticalFiller.java:682) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReportContent(JRVerticalFiller.java:275) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReport(JRVerticalFiller.java:117) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:895) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:817) at net.sf.jasperreports.engine.fill.JRFiller.fillReport(JRFiller.java:89) at net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:601) at net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:582) at net.sf.jasperreports.engine.JasperRunManager.runReportToPdf(JasperRunManager.java:402) 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 bsh.Reflect.invokeMethod(Unknown Source) at bsh.Reflect.invokeStaticMethod(Unknown Source) at bsh.Name.invokeMethod(Unknown Source) at bsh.BSHMethodInvocation.eval(Unknown Source) at bsh.BSHPrimaryExpression.eval(Unknown Source) at bsh.BSHPrimaryExpression.eval(Unknown Source) at bsh.BSHAssignment.eval(Unknown Source) ... 23 more Caused by: net.sf.jasperreports.engine.JRException: Crosstab data has already been processed. at net.sf.jasperreports.crosstabs.fill.calculation.BucketingService.addData(BucketingService.java:296) at net.sf.jasperreports.engine.fill.JRFillCrosstab$JRFillCrosstabDataset.customIncrement(JRFillCrosstab.java:661) ... 45 more Please can you tell me why i am getting above error. - Shainaz

hi, check this http://jasperforge.org/plugins/espforum/view.php?group_id=83&forumid=101&topicid=77145 it works for me

use evaluation time as report

hi, use ur detail band position type --> fix relative to top and subreport position type --> float

hi, create a variable In subreport say returnValue variable class type --> whatever u want calculation type --> nothing reset type and increment type -->none variable expression --> value you want to return In main report create variable with same name as returnValue variable class type --> same as return type calculation type --> nothing reset type and increment type -->none variable expression --> blank In main report Subreport --> properties -->Subreport(other)-->subreport return values-->add Subreport variable--> variable name as returnValue(u want to return) local destination variable --> main report variable (returnValue) calculation type --> nothing and use that variable wherever u want . one more thing use evaluation time of that variable as report hope it will work for you -Shainaz

hi, I have tried the same and for me its working...check ur steps--> Create a new variable say PriceSum Variable class type--> whatever u want(Integer/BigDecimal) calculation type --> sum Reset Type--> group Reset group --> ur group name Increment type--> none variable expression --> your field name(price) thats it. and use this field. hope this help you. -Shainaz

hi, I am trying to pass a collection(Arraylist) as a parameter to report and its work fine when I passed string as a value. List data= new ArrayList(); Map map = new Hashmap(); map.put("M1","Filed1"); map.put("M2","Field2"); data.add(map); params.put("Send",l1);// set the Arraylist to report parameter(Send) But I need to sent Collection as a value for a particular key. List data= new ArrayList(); ArrayList al1 = new Arraylist("1","2","3"); ArrayList al2 = new Arraylist("One","Two","Three"); Map map = new Hashmap(); map.put("M1",al1); map.put("M2",al2); data.add(map); params.put("Send",l1);// set the Arraylist to report parameter(Send) when i am trying to do this I am getting following error because In my report I have created the field M1 and M2 as a String and passing collection. Jul 20, 2010 12:33:58 PM net.sf.jasperreports.engine.fill.JRFillSubreport prepare SEVERE: Fill 33376867: exception net.sf.jasperreports.engine.fill.JRExpressionEvalException: Error evaluating expression : Source text : $F{M1} at net.sf.jasperreports.engine.fill.JREvaluator.evaluate(JREvaluator.java:197) at net.sf.jasperreports.engine.fill.JRCalculator.evaluate(JRCalculator.java:537) at net.sf.jasperreports.engine.fill.JRCalculator.evaluate(JRCalculator.java:505) at net.sf.jasperreports.engine.fill.JRFillElement.evaluateExpression(JRFillElement.java:826) 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:275) at net.sf.jasperreports.engine.fill.JRFillBand.evaluate(JRFillBand.java:426) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillColumnBand(JRVerticalFiller.java:1380) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillDetail(JRVerticalFiller.java:692) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReportStart(JRVerticalFiller.java:255) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReport(JRVerticalFiller.java:113) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:879) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:801) at net.sf.jasperreports.engine.fill.JRFillSubreport.fillSubreport(JRFillSubreport.java:536) at net.sf.jasperreports.engine.fill.JRSubreportRunnable.run(JRSubreportRunnable.java:63) at net.sf.jasperreports.engine.fill.JRThreadSubreportRunner.run(JRThreadSubreportRunner.java:209) at java.lang.Thread.run(Unknown Source) Caused by: java.lang.ClassCastException: java.util.ArrayList cannot be cast to java.lang.String at CrossTab1_1279603262432_852646.evaluate(CrossTab1_1279603262432_852646:173) at net.sf.jasperreports.engine.fill.JREvaluator.evaluate(JREvaluator.java:186) ... 17 more So can u please tell me how to create report fields as a collection data type. Thanks in Advance, Shainaz

Hi, I need to generate a PDF report that consist of millions record and produce about 20000 pages. I have used many approach, in my case there is no issue with my query. the sql execution takes minimum time. But the filling, transform and pdf generation takes lots of time. I also used the JRSwapFileVirtualizer but no effect. Please can u tell me how to improve the PDF report performance? Regards, Shainaz

hi, can u give me a a detailed information related to the passing a collection as a parameter. I followed above steps told by lionelv. but not working for me. please tell me its very urgent. Regards, Shainaz