Henry

Hello, when i create a value list i got a message that there is a limt (30). This value list are predefined values for a report parameter/input control. It looks thats only the "creation" of the value list has this limit. In other input controls without a predefined value list i can use values larger the 30 characters. Also when i create a report with an url call its possible to use values for the report parameter that are longer then 30 characters. Regards, Henry size=400]http://www.jasperforge.org/components/com_joomlaboard/uploaded/images/pic.jpg Post edited by: Henry, at: 2008/06/27 09:26 Post edited by: Henry, at: 2008/06/27 09:31

Hello, if there any way to increase the max length of value name and value in the definition of a "list of values"? Some of the values that i use for the report greater than the 30. I can fill the report parameter via url report call and direct input with values larger than 30 characters. But i can't use a list of value with predefined values because some needed values larger than 30 characters. Regards, Henry

Hello, i use in some reports my own java class/function. Not as customizer class, as function for parameters/variables. I defined my class in the report as "Report Import Directives". I compile the report manual in iR with no errors, the reports works. Also uploaded in the JasperServer, no problem. When i compile my reports with the Massive compiler sometimes i got an error that my function are not fond and sometimes the reports are compiled without an error messages. Code:net.sf.jasperreports.engine.JRException: Errors were encountered when compiling report expressions class file: 1. MyDBConnection cannot be resolved value = (java.lang.String)(MyDBConnection.CloseConnection(((java.sql.Connection)parameter_MyDatabaseConnection.getValue())));//$JR_EXPR_ID=138$ <------------> 2. MyDBConnection cannot be resolved value = (java.lang.String)(MyDBConnection.CloseConnection(((java.sql.Connection)parameter_MyDatabaseConnection.getValue())));//$JR_EXPR_ID=138$ <------------> 3. MyDBConnection cannot be resolved value = (java.lang.String)(MyDBConnection.CloseConnection(((java.sql.Connection)parameter_MyDatabaseConnection.getValue())));//$JR_EXPR_ID=138$ <------------> 3 errors at net.sf.jasperreports.engine.design.JRAbstractCompiler.compileReport(JRAbstractCompiler.java:193) at net.sf.jasperreports.engine.JasperCompileManager.compileReport(JasperCompileManager.java:219) at net.sf.jasperreports.engine.JasperCompileManager.compileReportToFile(JasperCompileManager.java:135) at net.sf.jasperreports.engine.JasperCompileManager.compileReportToFile(JasperCompileManager.java:117) at it.businesslogic.ireport.plugin.massivecompiler.CompileThread.run(CompileThread.java:230) at java.lang.Thread.run(Thread.java:595) Whats the difference between the "manual compile" and the massive Compiler? Regards, Henry

Hello Lucian, i found it already. Sometimes the easiest things are very difficult. ;) And i have don't forget to restart iReport when i change something in the customizer class with eclipse. Thanks, Henry

Hello, i use some ChartCustomizer with JasperReports. I build the Customizer Class with Eclipse and put all in on jar file. The jar file is in the class path. In the report definition (iReport) i use only the name without .class or .java. For example MyCategoryBarPlot. As package in eclipse i use the default package. This works fine. Now i try to build it with a Package like MyCustomizer How i have do "name" the Customizer Class that iReport/JasperReports found the class. at the moment i got always a error messages: Code:Error filling print... Could not create chart customizer instance. net.sf.jasperreports.engine.JRRuntimeException: Could not create chart customizer instance. at net.sf.jasperreports.engine.fill.JRFillChart.<init>(JRFillChart.java:344) at net.sf.jasperreports.engine.fill.JRFillObjectFactory.visitChart(JRFillObjectFactory.java:715) at net.sf.jasperreports.engine.base.JRBaseChart.visit(JRBaseChart.java:605) at net.sf.jasperreports.engine.JRAbstractObjectFactory.getVisitResult(JRAbstractObjectFactory.java:91) at net.sf.jasperreports.engine.fill.JRFillElementGroup.<init>(JRFillElementGroup.java:86) at net.sf.jasperreports.engine.fill.JRFillElementContainer.<init>(JRFillElementContainer.java:91) at net.sf.jasperreports.engine.fill.JRFillBand.<init>(JRFillBand.java:87) at net.sf.jasperreports.engine.fill.JRFillObjectFactory.getBand(JRFillObjectFactory.java:518) at net.sf.jasperreports.engine.fill.JRFillGroup.<init>(JRFillGroup.java:92) at net.sf.jasperreports.engine.fill.JRFillObjectFactory.getGroup(JRFillObjectFactory.java:497) at net.sf.jasperreports.engine.fill.JRFillVariable.<init>(JRFillVariable.java:85) at net.sf.jasperreports.engine.fill.JRFillObjectFactory.getVariable(JRFillObjectFactory.java:477) at net.sf.jasperreports.engine.fill.JRFillDataset.addVariable(JRFillDataset.java:290) at net.sf.jasperreports.engine.fill.JRFillDataset.setVariables(JRFillDataset.java:280) at net.sf.jasperreports.engine.fill.JRFillDataset.<init>(JRFillDataset.java:234) at net.sf.jasperreports.engine.fill.JRFillObjectFactory.getDataset(JRFillObjectFactory.java:1274) at net.sf.jasperreports.engine.fill.JRBaseFiller.<init>(JRBaseFiller.java:430) at net.sf.jasperreports.engine.fill.JRVerticalFiller.<init>(JRVerticalFiller.java:77) at net.sf.jasperreports.engine.fill.JRVerticalFiller.<init>(JRVerticalFiller.java:59) at net.sf.jasperreports.engine.fill.JRFiller.createFiller(JRFiller.java:147) at net.sf.jasperreports.engine.fill.JRFiller.fillReport(JRFiller.java:57) at net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:402) at net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:234) at it.businesslogic.ireport.IReportCompiler.run(IReportCompiler.java:947) at java.lang.Thread.run(Thread.java:595) Caused by: java.lang.ClassNotFoundException: MRCategoryBarPlot at java.net.URLClassLoader$1.run(URLClassLoader.java:200) at java.security.AccessController.doPrivileged(Native Method) at java.net.URLClassLoader.findClass(URLClassLoader.java:188) at java.lang.ClassLoader.loadClass(ClassLoader.java:306) at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:268) at java.lang.ClassLoader.loadClass(ClassLoader.java:251) at java.lang.ClassLoader.loadClassInternal(ClassLoader.java:319) at java.lang.Class.forName0(Native Method) at java.lang.Class.forName(Class.java:242) at net.sf.jasperreports.engine.util.JRClassLoader.loadClassForRealName(JRClassLoader.java:179) at net.sf.jasperreports.engine.util.JRClassLoader.loadClassForName(JRClassLoader.java:119) at net.sf.jasperreports.engine.fill.JRFillChart.<init>(JRFillChart.java:341) ... 24 more Print was not filled. Try using an EmptyDataSource... Regards, Henry

Hello, the same with iReport 3.0.0. Henry

Hello, the same problem with iReport 3.0.0. Someone else with the same problem or with a solution? Henry

Hello, i try to read data with a csv-datasource. I have problems to use the java.sql.Timestamp as field class type. 2007-02-01 00:00:00 is the format in the csv-file. I got the messages "Unable to get value for filed 'DateTime' of class 'java.sql.Timestamp' when i run the report. Is java.sql.Timestamp as field class type supportet for a csv-datasource and what format its to use in the csv-file for this? Regards, Henry

Hello, i try to read data with a csv-datasource. I have problems to use the java.sql.Timestamp as field class type. 2007-02-01 00:00:00 is the format in the csv-file. I got the messages "Unable to get value for filed 'DateTime' of class 'java.sql.Timestamp' when i run the report. Is java.sql.Timestamp as field class type supportet for a csv-datasource and what format its to use in the csv-file for this? Regards, Henry

Hi, when i start iReport i got the following messages in the main console: iReport home (from command line): /OVOReports/opt/iReport User home (from command line): /OVOReports/work/iReport/user-home iReport default compile directory: . iReport user home directory (iReport compiles here if there are no settings or if iReport isn't compiling to the report directory): /OVOReports/opt/iReport What means iReport user home directory? Why is it the same like the iReport home and not the same like User home? I start iReport (2.0.4) with the this option on the command line. -ireport-home /OVOReports/opt/iReport -user-home /OVOReports/work/iReport/user-home -temp-dir /OVOReports/work/iReport/temp-dir Regards, Henry

Hello, i try to switch from verion 2.04 to 2.05. I have some problems with the exteral viewers (e.g. for pdf or html). I got an error messages like this. size=400]http://www.jasperforge.org/components/com_joomlaboard/uploaded/images/error.jpg In the console window from iReport i got the normal message. Executing: /opt/kde3/bin/kpdf "/OVOReports/work/iReport/compiler/Call_OVOReports-A4Landscape.pdf" With iReport 2.04 it works normal. Regards, Henry Post edited by: Henry, at: 2008/04/09 15:00

Hello, i defined for each series in a time series report a separate color in the chart properties. The line colors changed in case the legend is disabled or enabled. You can see this in the picture that i attached on the post. This happens with iReport 2.04/2.05, jasperreport 2.05, jfreechart 1.06, jcommon 1.0.12. Regards, Henry [file name=Screen.jpg size=88904] Post edited by: Henry, at: 2008/04/09 14:32 Post edited by: Henry, at: 2008/04/09 14:32

Post edited by: Henry, at: 2008/04/09 14:22

I have tested it with different version of jfreechart. Till 1.0.6 the timeseries works with iReport, from 1.0.7 and up it doesn't works. In the ChangeLog from 1.0.7 i found something: 2007-11-05 David Gilbert <david.gilbert@object-refinery.com> * source/org/jfree/data/time/TimeSeries.java (TimeSeries(String)): Changed first argument to Comparable, (TimeSeries(String, Class)): Likewise, (TimeSeries(String, String, String, Class)): Likewise. In the API-DOC from 1.0.6 Constructor Summary TimeSeries(java.lang.String name) Creates a new (empty) time series. TimeSeries(java.lang.String name, java.lang.Class timePeriodClass) Creates a new (empty) time series with the specified name and class of RegularTimePeriod. TimeSeries(java.lang.String name, java.lang.String domain, java.lang.String range, java.lang.Class timePeriodClass) Creates a new time series that contains no data. In the API-DOC from 1.0.9 Constructor Summary TimeSeries(java.lang.Comparable name) Creates a new (empty) time series. TimeSeries(java.lang.Comparable name, java.lang.Class timePeriodClass) Creates a new (empty) time series with the specified name and class of RegularTimePeriod. TimeSeries(java.lang.Comparable name, java.lang.String domain, java.lang.String range, java.lang.Class timePeriodClass) Creates a new time series that contains no data. Maybe the type change from the first parameter (String => Comparable) is the problem. Regadrs, Henry

Hi Lucian, that the output from iReport when i try to create a simple timeseries report with jfreechart 1.0.9. The reports works if change to jfreechart 1.0.0. Regeards, Henry Code: Error filling print... java.lang.NoSuchMethodError: org.jfree.data.time.TimeSeries.<init>(Ljava/lang/String;Ljava/lang/Class;«»)V net.sf.jasperreports.engine.JRRuntimeException: java.lang.NoSuchMethodError: org.jfree.data.time.TimeSeries.<init>(Ljava/lang/String;Ljava/lang/Class;«»)V at net.sf.jasperreports.engine.fill.JRFillSubreport.prepare(JRFillSubreport.java:622) at net.sf.jasperreports.engine.fill.JRFillElementContainer.prepareElements(JRFillElementContainer.java:344) at net.sf.jasperreports.engine.fill.JRFillBand.fill(JRFillBand.java:346) at net.sf.jasperreports.engine.fill.JRFillBand.fill(JRFillBand.java:305) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillNoData(JRVerticalFiller.java:1540) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReport(JRVerticalFiller.java:192) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:891) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:814) 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:517) at it.businesslogic.ireport.IReportCompiler.run(IReportCompiler.java:970) at java.lang.Thread.run(Thread.java:595) Caused by: java.lang.NoSuchMethodError: org.jfree.data.time.TimeSeries.<init>(Ljava/lang/String;Ljava/lang/Class;«»)V at net.sf.jasperreports.charts.fill.JRFillTimeSeriesDataset.customIncrement(JRFillTimeSeriesDataset.java:138) 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.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:891) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:795) at net.sf.jasperreports.engine.fill.JRFillSubreport.fillSubreport(JRFillSubreport.java:519) at net.sf.jasperreports.engine.fill.JRSubreportRunnable.run(JRSubreportRunnable.java:63) at net.sf.jasperreports.engine.fill.JRThreadSubreportRunner.run(JRThreadSubreportRunner.java:209) ... 1 more Print was not filled. Try using an EmptyDataSource...

Hello, i use jasperreports-2.0.4 with jfreechart 1.0.9 anf jcommon-1.0.12. All reports that i build till now are category plot and pie charts reports. category plots because the 3d-bars. Now i try to create a simple time series plot an got the following error with iReport (2.0.4): Code:java.lang.NoSuchMethodError: org.jfree.data.time.TimeSeries.<init>(Ljava/lang/String;Ljava/lang/Class;«»)V If there a general problem with this version combination and the usage oh time series charts? Is it planed to distribute the actual version of jfreechart and jcommon with jasperreports and iReport? Regards, Henry

Hello, is it possible to use a multiline sql-querys in JR, like a sql-script? For some reports i need complex data that i can't "build" in one single sql-query. Regards, Henry Post edited by: Henry, at: 2008/01/24 09:14

Hello, i try to build a report with a moving average line. I found something about this in the jfree documentation. Is it possible to do this with JasperReport? Regards, Henry

Hello Teodor, It is now solved and part of the next release to be out in one or two weeks. thanks for your answer. :) Till the next release i use the 2.0.2 and its a good possibility for me to download the actual "svn-version"and try to compile it. Regards, Henry

Hello Theodor, i attached the jrxml file on the first post. This report has no sub reports but it is a sub report from another report. The other report don't have output elements. It's only a caller reports and defined some parameter for the sub report. Regards, Henry

Hello together, at the moment i use for my reports jr 2.0.2. The first test with jr 2.0.3 creates different pdf exports than 2.0.2 on some reports. In the image you can see first a pdf export with jr 2.0.2 and down the same report with jr 2.0.3. size=283]http://www.jasperforge.org/components/com_joomlaboard/uploaded/images/jr_2.jpg The headline (title) is not visible and the color from the table and background is mixed. regards, henry Post edited by: Henry, at: 2008/01/04 14:34 [file name=DurchschnittMonatTag.jrxml size=20135]http://www.jasperforge.org/components/com_joomlaboard/uploaded/files/DurchschnittMonatTag.jrxml[/file] Post edited by: Henry, at: 2008/01/05 09:43

Hello, i try to enable/disable the Label for different Series in a 3DBarchart but it doesn't work. I use a customizer class with this calls to do this. barrenderer.setBaseItemLabelsVisible(false,true); barrenderer.setSeriesItemLabelsVisible(0,true,true); barrenderer.setSeriesItemLabelsVisible(1,false,true); barrenderer.setSeriesItemLabelsVisible(2,false,true); barrenderer.setSeriesItemLabelsVisible(3,false,true); barrenderer.setSeriesItemLabelsVisible(4,false,true); barrenderer.setSeriesItemLabelsVisible(5,false,true); The labels for all series always visible or allways not visible depend on the settings "Chart Properties"/"Show labels". Is it possible to hide individual the item label for series in a 3DBar Chart? Regards, Henry

Hello Lucian, thanks for the fast answer. It works. :) Regards, Henry

Hello, i'am using jasperserver 2.1.0. When create a report via the web interface sometimes the last report page are not displayed. At the moment i think this happens only with 2 pages reports. I create a 2 pages report => 1 page is visible. I press the export to pdf button => 2 pages in the pdf document. If i create the same report in ireports then i have always 2 pages. if i do the same with reports that have 3 or more pages always all pages in the web page are visible. Regards, Henry

Hello together, i have a problem with some big reports (more then 1000 pages) when i use a customizer class. The report works perfect without a customizer class. By using a customizer class the memory usage increased dramatically during the report generation. This is one of my customizer class that i use in my reports. [file name=OVOActivityOverViewTimeChart2.txt size=2379]http://www.jasperforge.org/components/com_joomlaboard/uploaded/files/OVOActivityOverViewTimeChart2.txt[/file] I'm not a java specialists and I don't have an idea for the moment what is wrong with the customizer class. Can someone look on the class and give me a hint. Are ther any recommendations to build customizer classes? Whats “helpfull†and waths “vorbidden†in a customizer class? Regards, Henry Post edited by: Henry, at: 2007/12/05 14:17