amitksingh
Members-
Posts
12 -
Joined
-
Last visited
amitksingh's Achievements
-
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
-
Problem running Jasper Reports 3.5.1 in RAD 6.0
amitksingh replied to amitksingh's topic in Products
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: