amitksingh

Hi, I am using Jasper Report 3.1.4 for excel/pdf report generation in my web application. In one of the excel reports, I am getting one extra blank row. I have attached the generated report. In the report, two rows (2140 and 2141 are mergedd into one row). If I delete the row 2141, the report looks fine. So I assume that row 2141 is the blank row. In the java class, I am setting the JExcelApiExporter parameter as exporter.setParameter(JRxlsExporterParameter.IS_REMOVE_EMPTY_SPACE_BETWEEN_ROWS, Boolean.TRUE); but even then I am getting the empty row. I have attached the jrxml file along with the excel report for reference.

Hi, I am trying the Jasper Report API (/demo/samples/noxmldesign of JasperReports source code distribution package)to generate dynamic reports (reports with varying no. of columns). It seems the API has no support for Stacked Bar Chart. Though I am able to generate Bar Chart (JRDesignBarPlot), pie chart (JRDesignPiePlot) and line chart (JRDesignLinePlot), I couldn't find anything like "JRDesignStackedBarPlot" by which I could generate the Stacked Bar Chart. Please let me know if it is possible to generate StackedBarChart using Jasper Report API. Thanks, amit

Thanks for your reply...I am using iReport3.5.1. still not able to combine category expressions. Please let me know if you get any success with the newer version. Thanks amitksingh

somebody plz help..its urgent..I cudn't find a way to combine category expressions. amitksingh

Hi, I have a requirement to show a combination of Category Expression in one of my charts (please see the sample attachment). I have not been able to combine the Category expression for Product and Month. I am able to display the chart with a single Category expression (Product) but then the Months are not visible in the chart. Please let me know if this is possible to have a combination of the Category expression for the same Series expression. Is there any resolve this problem? Thanks amitksingh

Hi njrfrens, Have you been able to achieve your objective of grouping while implementing StackedBar Chart using Jasper Reports. If yes, can you please explain the solution to me. Thanks Amit

I am using JR version 3.1.2 that supports jdk 1.4.

Thanks a lot!!!! It worked. My only concern is that I am using query string for fetching the data. I have to convert this to Oracle Stored Procedure call that returns a refcursor (out parameter). I have figured one of your posts in the forum that explains this SP approach. Will try that now :). Thanks and Regards, Amit Singh

Thank you very much for your reply Teodor, Since I am new to Jasper Reports, I may not be following the correct approach. The data I want to show is not static and I am fetching the data from the Oracle Database. Now I want to show this data in the tabular format and charts (the same data in both chart and tables as shown in the attached sheet). I have attached a sample report that I want to generate through JR. I want to display two tables: Table 1 contains Sector wise Target and Achieved values and Table 2 contains Hub wise Target and Achieved values. Chart 1 and 3 are the representation of Table 1 data and Chart 2 is the representation of the Table 2 data. I want them to be displayed in a single pdf/excel report. Please tell me what is the best approach to achieve this requirement. I would really appreciate if you could provide me with some sample code which could help. Thanks and Regards, Amit Singh

I added the following line in my SampleReport.java class: this.setVariableValue("List", list);//list is ArrayList of values to be displayed. and the following line to the SampleReport.jrxml file <variable name="List" class="java.util.Collection" resetType="Report" calculation="System"> How can I iterate through this Arraylist to show the values in the report alongwith the 2 charts already being displayed. I have no problems in iterating through the arraylist values using JRBeanCollectionDataSource. JasperFillManager.fillReportToFile("C:\\reports\\SampleReport.jasper", "C:\\reports\\SampleReport.jrprint", null, new JRBeanCollectionDataSource(list)); But in that case I am not able to show the charts. So I am using JREmptyDataSource. JasperFillManager.fillReportToFile("C:\\reports\\SampleReport.jasper", "C:\\reports\\SampleReport.jrprint", null, new JREmptyDataSource()); Please help.

I am using Jasper Reports 3.1.2 to generate reports. Charts are displayed using jfreechart. My requirement is to display 2 different bar charts along with the chart data in a tabular format. I am able to display the 2 charts but couldn't find a way to display the data in tabular form. For displaying the chart, I have used <variable name="Chart" class="net.sf.jasperreports.engine.JRRenderable" calculation="System"></variable> <variable name="Chart2" class="net.sf.jasperreports.engine.JRRenderable" calculation="System"></variable> in the jrxml file and .setVariableValue("Chart", new JCommonDrawableRenderer(chart));this.setVariableValue("Chart2", new JCommonDrawableRenderer(chart)); in the Java class. I have attached the two files. Please let me know if this van be done. Thanks, Amit Singh this

Hi, I am trying to run Jasper Reports 3.5.1 with RAD 6.0 (jdk 1.4). While running the jfreechart sample, I am getting the exception as: [java] java.lang.UnsupportedClassVersionError: JFreeChartApp (Unsupported major.minor version 49.0) [java] at org.apache.tools.ant.taskdefs.ExecuteJava.execute(ExecuteJava.java:172) [java] at org.apache.tools.ant.taskdefs.Java.run(Java.java:705) [java] at org.apache.tools.ant.taskdefs.Java.executeJava(Java.java:177) [java] at org.apache.tools.ant.taskdefs.Java.execute(Java.java:83) [java] at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:275) [java] at org.apache.tools.ant.Task.perform(Task.java:364) [java] at org.apache.tools.ant.Target.execute(Target.java:341) [java] at org.apache.tools.ant.Target.performTasks(Target.java:369) [java] at org.apache.tools.ant.Project.executeTarget(Project.java:1214) [java] at org.apache.tools.ant.Project.executeTargets(Project.java:1062) [java] at org.eclipse.ant.internal.ui.antsupport.InternalAntRunner.run(InternalAntRunner.java:377) [java] at org.eclipse.ant.internal.ui.antsupport.InternalAntRunner.main(InternalAntRunner.java:135) [java] Caused by: java.lang.UnsupportedClassVersionError: JFreeChartApp (Unsupported major.minor version 49.0) [java] at java.lang.ClassLoader.defineClass0(Native Method) [java] at java.lang.ClassLoader.defineClass(ClassLoader.java:800) [java] at org.apache.tools.ant.loader.AntClassLoader2.defineClassFromData(AntClassLoader2.java:76) [java] at org.apache.tools.ant.AntClassLoader.getClassFromStream(AntClassLoader.java:1073) [java] at org.apache.tools.ant.AntClassLoader.findClassInComponents(AntClassLoader.java:1137) [java] at org.apache.tools.ant.AntClassLoader.findClass(AntClassLoader.java:1090) [java] at org.apache.tools.ant.AntClassLoader.forceLoadClass(AntClassLoader.java:591) [java] at org.apache.tools.ant.taskdefs.ExecuteJava.execute(ExecuteJava.java:114) [java] ... 11 more [java] --- Nested Exception --- [java] java.lang.UnsupportedClassVersionError: JFreeChartApp (Unsupported major.minor version 49.0) [java] at java.lang.ClassLoader.defineClass0(Native Method) [java] at java.lang.ClassLoader.defineClass(ClassLoader.java:800) [java] at org.apache.tools.ant.loader.AntClassLoader2.defineClassFromData(AntClassLoader2.java:76) [java] at org.apache.tools.ant.AntClassLoader.getClassFromStream(AntClassLoader.java:1073) [java] at org.apache.tools.ant.AntClassLoader.findClassInComponents(AntClassLoader.java:1137) [java] at org.apache.tools.ant.AntClassLoader.findClass(AntClassLoader.java:1090) [java] at org.apache.tools.ant.AntClassLoader.forceLoadClass(AntClassLoader.java:591) [java] at org.apache.tools.ant.taskdefs.ExecuteJava.execute(ExecuteJava.java:114) [java] at org.apache.tools.ant.taskdefs.Java.run(Java.java:705) [java] at org.apache.tools.ant.taskdefs.Java.executeJava(Java.java:177) [java] at org.apache.tools.ant.taskdefs.Java.execute(Java.java:83) [java] at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:275) [java] at org.apache.tools.ant.Task.perform(Task.java:364) [java] at org.apache.tools.ant.Target.execute(Target.java:341) [java] at org.apache.tools.ant.Target.performTasks(Target.java:369) [java] at org.apache.tools.ant.Project.executeTarget(Project.java:1214) [java] at org.apache.tools.ant.Project.executeTargets(Project.java:1062) [java] at org.eclipse.ant.internal.ui.antsupport.InternalAntRunner.run(InternalAntRunner.java:377) [java] at org.eclipse.ant.internal.ui.antsupport.InternalAntRunner.main(InternalAntRunner.java:135) While I run the same thing using eclipse, its working fine. I can't switch to RAD 7 (jdk 1.5). Is there any way I can use Jasper Reports 3.5.1 with RAD 6.0. javac: compile: