lovetide

this problem still exists in JS 2.0.0:huh:

be aware that there is a syntax error in upgrade-mysql-1.2.1-2.0.0.sql file (line 28): Code: 27 alter table JIReportUnit 28 controlslayout tinyint; -- should be 28 ADD controlslayout tinyint;

I'm a newbie for JasperServer. It seems JasperServer use JPivot to render the OLAP result, so we need to know the usage of tags of JPivot and WCFthen we need to modify the %JASPER_SERVER_WEBAPP_ROOT%/WEB-INF/jsp/olap/viewOlap.jsp file to change the macro UI layoutand it seems JPivot use some XSL to render it's own component (I called it micro UI), so we need to know XSL knowledge[/ul] I'm a newbie for JPivotã€Mondrianã€OLAPã€MDX too, I'm learning JPivot and Mondrian these days, we need advises from experts:lol: Post edited by: lovetide, at: 2007/05/25 02:19

I've upgraded JasperServer from 1.2.0 to 1.2.1 I do not use the .exe installer, I use the .zip version, and upgrade it manually. I only do the following 2 jobs, then it works for me: read 2.5.4 section of JasperServer-WarFile-Install-Guide.pdf, upgrade the database by executing 'mysql --user=user --password=password -D jasperserver < jasperserverPatch-1.2.0-1.2.1.ddl' shell commanddelete the old JasperServer web application, and install the new one[/ul]

similar problem, JS1.2.1, Tomcat 6.0.13, MySQL5.0.41 Code: java.lang.IllegalArgumentException: bean "${requestScope" not found at com.tonbeller.wcf.expr.ExprUtils.getModelReference(ExprUtils.java:89) at com.tonbeller.wcf.controller.RequestContextImpl.getModelReference(RequestContextImpl.java:106) at com.tonbeller.wcf.form.FormComponentTag.createComponent(FormComponentTag.java:61) at com.tonbeller.wcf.component.ComponentTag.doStartTag(ComponentTag.java:58) at org.apache.jsp.WEB_002dINF.jsp.olap.viewOlap_jsp._jspx_meth_wcf_005fform_005f1(viewOlap_jsp.java:525) at org.apache.jsp.WEB_002dINF.jsp.olap.viewOlap_jsp._jspService(viewOlap_jsp.java:192) at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70) at javax.servlet.http.HttpServlet.service(HttpServlet.java:803) at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:393) at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:320) at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:266) at javax.servlet.http.HttpServlet.service(HttpServlet.java:803) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.opensymphony.module.sitemesh.filter.PageFilter.parsePage(PageFilter.java:118) at com.opensymphony.module.sitemesh.filter.PageFilter.doFilter(PageFilter.java:52) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:654) at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:445) at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:379) at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:292) at org.springframework.web.servlet.view.InternalResourceView.renderMergedOutputModel(InternalResourceView.java:142) at org.springframework.web.servlet.view.AbstractView.render(AbstractView.java:247) at org.springframework.web.servlet.DispatcherServlet.render(DispatcherServlet.java:1105) at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:841) at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:755) at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:396) at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:350) at javax.servlet.http.HttpServlet.service(HttpServlet.java:690) at javax.servlet.http.HttpServlet.service(HttpServlet.java:803) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.tonbeller.wcf.controller.RequestFilter$MyHandler.normalRequest(RequestFilter.java:140) at com.tonbeller.wcf.controller.RequestSynchronizer.handleRequest(RequestSynchronizer.java:127) at com.tonbeller.wcf.controller.RequestFilter.doFilter(RequestFilter.java:272) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.jaspersoft.jasperserver.war.common.UploadMultipartFilter.doFilter(UploadMultipartFilter.java:86) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:264) at org.acegisecurity.intercept.web.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:107) at org.acegisecurity.intercept.web.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:72) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) at org.acegisecurity.ui.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:110) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) at org.acegisecurity.providers.anonymous.AnonymousProcessingFilter.doFilter(AnonymousProcessingFilter.java:125) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) at com.jaspersoft.jasperserver.api.metadata.user.service.impl.MetadataAuthenticationProcessingFilter.doFilter(MetadataAuthenticationProcessingFilter.java:136) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) at org.acegisecurity.ui.basicauth.BasicProcessingFilter.doFilter(BasicProcessingFilter.java:181) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) at org.acegisecurity.ui.AbstractProcessingFilter.doFilter(AbstractProcessingFilter.java:217) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) at com.jaspersoft.jasperserver.war.UserPreferencesFilter.doFilter(UserPreferencesFilter.java:83) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) at org.acegisecurity.context.HttpSessionContextIntegrationFilter.doFilter(HttpSessionContextIntegrationFilter.java:191) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) at org.acegisecurity.util.FilterChainProxy.doFilter(FilterChainProxy.java:148) at org.acegisecurity.util.FilterToBeanProxy.doFilter(FilterToBeanProxy.java:90) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.jaspersoft.jasperserver.war.util.CharacterEncodingFilter.doFilter(CharacterEncodingFilter.java:70) at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:138) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:230) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:104) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:261) at org.apache.coyote.http11.Http11AprProcessor.process(Http11AprProcessor.java:852) at org.apache.coyote.http11.Http11AprProtocol$Http11ConnectionHandler.process(Http11AprProtocol.java:584) at org.apache.tomcat.util.net.AprEndpoint$Worker.run(AprEndpoint.java:1508) at java.lang.Thread.run(Thread.java:619)

I have encountered the same error after upgrade 1.2.0 to 1.2.1, see here:http://www.jasperforge.org/index.php?option=com_joomlaboard&Itemid=215&func=view&id=23723&catid=10

This is a good idea. How about the 'average time-length costed' ? How about the 'top N reports' which measured in 'costed time-length' and/or 'report times/count' and/or 'total output file size stored in repository (which produced by scheduled report)' and/or ...:lol:

swood wrote: The access denied problem is related to the user the report is running as does not have the required access rights to the report. We have changed the default security model in 1.2.1 to be more restrictive - normal users have no access. Sherman JasperSoft Thank you for your reply swood. I use 'jasperadmin' account to operate it, and, I can successfully make the report manually(I mean, by click the report name), but when I try to schedule it or 'run in background', it will failed with the previous error log. Does 'run in background' use a different account do it? Post edited by: lovetide, at: 2007/04/13 03:22

I upgraded JI1.2.0 to JI1.2.1 yesterday, then I encoutnered some problems. 1. The scheduled report does work after upgrade. the following is an exception log from jasperserver.log file: Code: 00:01:46,158 ERROR ReportExecutionJob,JasperServerScheduler_Worker-1:186 - org.acegisecurity.AccessDeniedException: Access is denied org.acegisecurity.AccessDeniedException: Access is denied at org.acegisecurity.vote.AffirmativeBased.decide(AffirmativeBased.java:68) at org.acegisecurity.intercept.AbstractSecurityInterceptor.beforeInvocation(AbstractSecurityInterceptor.java:275) at org.acegisecurity.intercept.method.aopalliance.MethodSecurityInterceptor.invoke(MethodSecurityInterceptor.java:63) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:176) at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:107) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:176) at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:107) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:176) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:210) at $Proxy3.getResource(Unknown Source) at com.jaspersoft.jasperserver.api.engine.scheduling.quartz.ReportExecutionJob.saveToRepository(ReportExecutionJob.java:441) at com.jaspersoft.jasperserver.api.engine.scheduling.quartz.ReportExecutionJob.sendToDestinations(ReportExecutionJob.java:295) at com.jaspersoft.jasperserver.api.engine.scheduling.quartz.ReportExecutionJob.execute(ReportExecutionJob.java:138) at org.quartz.core.JobRunShell.run(JobRunShell.java:195) at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:520) :( 2. Another little problem is about the default value of 'visible' field of 'JIInputControl' table. I use 'jasperserverPatch-1.2.0-1.2.1.ddl' file to upgrade database(I have some InputControls before upgrade). The problem is that when I try to report, I will got an exception: Code:[code] Error Message: org.springframework.webflow.engine.ActionExecutionException: Exception thrown executing [AnnotatedAction@18787c9 targetAction = com.jaspersoft.jasperserver.war.action.RepoAdminAction@11775bc, attributes = map[[empty]]] in state 'initAction' of flow 'repoAdminFlow' -- action execution attributes were 'map[[empty]]'; nested exception is org.hibernate.PropertyAccessException: Null value was assigned to a property of primitive type setter of com.jaspersoft.jasperserver.api.metadata.common.service.impl.hibernate.persistent.RepoInputControl.visible Error Trace: org.springframework.webflow.engine.ActionExecutionException: Exception thrown executing [AnnotatedAction@18787c9 targetAction = com.jaspersoft.jasperserver.war.action.RepoAdminAction@11775bc, attributes = map[[empty]]] in state 'initAction' of flow 'repoAdminFlow' -- action execution attributes were 'map[[empty]]'; nested exception is org.hibernate.PropertyAccessException: Null value was assigned to a property of primitive type setter of com.jaspersoft.jasperserver.api.metadata.common.service.impl.hibernate.persistent.RepoInputControl.visible org.springframework.webflow.engine.ActionExecutionException: Exception thrown executing [AnnotatedAction@18787c9 targetAction = com.jaspersoft.jasperserver.war.action.RepoAdminAction@11775bc, attributes = map[[empty]]] in state 'initAction' of flow 'repoAdminFlow' -- action execution attributes were 'map[[empty]]'; nested exception is org.hibernate.PropertyAccessException: Null value was assigned to a property of primitive type setter of com.jaspersoft.jasperserver.api.metadata.common.service.impl.hibernate.persistent.RepoInputControl.visible Caused by: org.hibernate.PropertyAccessException: Null value was assigned to a property of primitive type setter of com.jaspersoft.jasperserver.api.metadata.common.service.impl.hibernate.persistent.RepoInputControl.visible at ....... I have resolved this problem by updating 'visible' field of all records to TRUE(original value is NULL value) after upgrade.

This problem is still exists. If the file path or file name contains multibytes characters on a Windows system, the recent file menu will not shown the recent file list.

try to replace $R(vars1) with new String($R{vars1}.getBytes("ISO-8859-1"),"UTF-8"):laugh:

If you use iReport to design your report, you can type/input or copy/paste Chinese characters directly. But if you use resource bundle to store Chinese characters, I have a experience like the following: 1. type/input or copy/paste Chinese characters directly in your .properties file #example: chinese_surname.king=金 chinese_surname.liu=刘 2. save .properties file in UTF-8 or GB18030/GBK/GB2312 or BIG5 encoding as you need 3. after you readed from .properties file, convert the encoding of result string from "ISO-8859-1" to the encoding you choosed at step 2, then, you'll get what you want I think... :laugh:

jmurray wrote: I had this problem with an earlier release of iReport. It turned out to be an incompatible version of Sun's SDK. If you are still using version 1.4 then get on over to Sun and grab version 5: http://java.sun.com/javaee/downloads/index.jsp Once you've installed it, make sure you copy the new tools.jar file to iReport's lib directory Thanks for your reply jmurray. In fact, I installed both jdk1.5.0_10(with public JRE installed) and jdk1.6.0(without public JRE installed), because iReport auto detect and select the newest jvm to startup, so I'm actually using 1.6.0 now (this can be confirmed from the Help-->About iReport-->System properties). I've also copied the tools.jar to %IREPORT_HOME%lib directory, then restart ireport 1.3.0, then reopen that file, but the problem still exist. Some other simple jrxmls will not cause this problem, I don't know what's wrong with this one. Post edited by: lovetide, at: 2006/12/27 16:20

I have a jrxml file which is created by older version iReport, the file is last saved from iReport 1.2.6 When I opened this file by iReport v1.3.0, the usage of CPU keeps 100% even if I closed this file from iReport, I must close the whole iReport application to get a normal CPU usage. The attachment is that CPU usage murderer... [file name=CallAmount_100865x_Daily_Report.jrxml size=21639]http://www.jasperforge.org/components/com_joomlaboard/uploaded/files/CallAmount_100865x_Daily_Report.jrxml[/file]

Due to the chinese translation is not completed, I'd like to use english as the GUI language, but it seems the 'english' selection is missing in iReport 1.3.0, so I can't configure the GUI language to english. size=400]http://www.jasperforge.org/components/com_joomlaboard/uploaded/images/iReport1.png Post edited by: lovetide, at: 2006/12/26 01:46

Okay, I try to resolve it by myself. Here is my solution: I use MySQL-5.0.24a for windows, and installed Tomcat 5.5.17, Apache 2.0.59, phpMyAdmin 2.9.0 1. use phpMyAdmin to clone a new database from the old database of JI-1.0.1. my old database name: JasperServer my new database name: JServerMeta1 2. use phpMyAdmin, select JServerMeta1 database, then execute the following SQL statements. Code: ALTER TABLE BeanDatasource RENAME TO JIBeanDatasource; ALTER TABLE DataType RENAME TO JIDataType; ALTER TABLE content_resource RENAME TO JIContentResource; ALTER TABLE file_resource RENAME TO JIFileResource; ALTER TABLE InputControl RENAME TO JIInputControl; ALTER TABLE InputControlQueryColumn RENAME TO JIInputControlQueryColumn; ALTER TABLE JNDIJdbcDatasource RENAME TO JIJNDIJdbcDatasource; ALTER TABLE JdbcDatasource RENAME TO JIJdbcDatasource; ALTER TABLE ListOfValues RENAME TO JIListOfValues; ALTER TABLE ListOfValuesItem RENAME TO JIListOfValuesItem; ALTER TABLE log_event RENAME TO JILogEvent; ALTER TABLE MondrianConnection RENAME TO JIMondrianConnection; ALTER TABLE MondrianXMLADefinition RENAME TO JIMondrianXMLADefinition; ALTER TABLE ObjectPermission RENAME TO JIObjectPermission; ALTER TABLE OlapClientConnection RENAME TO JIOlapClientConnection; ALTER TABLE OlapUnit RENAME TO JIOlapUnit; ALTER TABLE JSQuery RENAME TO JIQuery; ALTER TABLE ReportDataSource RENAME TO JIReportDataSource; ALTER TABLE report_job RENAME TO JIReportJob; ALTER TABLE report_job_calendar_trigger RENAME TO JIReportJobCalendarTrigger; ALTER TABLE report_job_mail RENAME TO JIReportJobMail; ALTER TABLE report_job_mail_recipient RENAME TO JIReportJobMailRecipient; ALTER TABLE report_job_output_format RENAME TO JIReportJobOutputFormat; ALTER TABLE report_job_parameter RENAME TO JIReportJobParameter; ALTER TABLE report_job_repository_destination RENAME TO JIReportJobRepoDest; ALTER TABLE report_job_simple_trigger RENAME TO JIReportJobSimpleTrigger; ALTER TABLE report_job_trigger RENAME TO JIReportJobTrigger; ALTER TABLE ReportUnit RENAME TO JIReportUnit; ALTER TABLE ReportUnitInputControl RENAME TO JIReportUnitInputControl; ALTER TABLE Report_Unit_Resource RENAME TO JIReportUnitResource; ALTER TABLE repository_cache RENAME TO JIRepositoryCache; ALTER TABLE Resource RENAME TO JIResource; ALTER TABLE resource_folder RENAME TO JIResourceFolder; ALTER TABLE Role RENAME TO JIRole; ALTER TABLE JSUser RENAME TO JIUser; ALTER TABLE UserRole RENAME TO JIUserRole; ALTER TABLE XMLAConnection RENAME TO JIXMLAConnection; ALTER TABLE JIQuery ADD COLUMN dataSource BIGINT(20) DEFAULT NULL AFTER id, ADD COLUMN query_language VARCHAR(40) NOT NULL AFTER dataSource; ALTER TABLE JIReportUnit ADD COLUMN controlrenderer VARCHAR(100) DEFAULT NULL AFTER mainReport, ADD COLUMN reportrenderer VARCHAR(100) DEFAULT NULL AFTER controlrenderer; ALTER TABLE JIResourceFolder MODIFY COLUMN uri VARCHAR(250) NOT NULL, MODIFY COLUMN description VARCHAR(250) DEFAULT NULL; and now it works. Although it "works" now, but I have not a fully test, so take it carefully.

I installed jasperintelligence 1.1 now, and I have configured the database setting of JasperServer webapp as the same as 1.0.1, but when I try to login, I got an error like this: Code: Invalid credentials supplied. Could not login to JasperServer. I checked the log of tomcat, I found the following message: Code:[code] 15:13:51,125 ERROR JDBCExceptionReporter,http-8080-Processor22:72 - Table 'jasperserver.jiuser' doesn't exist It seems that JI1.1 use a new database schema than JI1.0.1, so how can I upgrade it ? Must I install a fresh JI1.1 ? by the way, I can't start both JI1.1 and JI1.0.1 at the same time, see the following exception: Code:[code] java.lang.IllegalStateException: Web app root system property already set to different value: 'jasperserver.root' = [C:WebApplicationsjasperserver] instead of [C:WebApplicationsjasperserver1.0.1] - Choose unique values for the 'webAppRootKey' context-param in your web.xml files!

I use a Simplified Chinese Windows Professional 2000 operating system, jdk1.5.0_08 installed, the default charset encoding is GBK. # Directory which I used to save my reports may contain Chinese characters, each time i start iReport, the "recent file" menu is empty. I opened recentFiles.xml and I found it's not encoded as it declared: UTF-8. # I checked the source code of iReport 1.2.6, in "it.businesslogic.ireport.gui.MainFrame", Line 8265, I found that when writing to XML file, string does not do some charset encoding conversion. # And, maybe there are some others case like this when writing other xml. # # by the way: I edited "it.businesslogic.ireport.gui.MainFrame.java", Line 8265, change 'file' to 'new String(file.getBytes(), "UTF-8")'. I want to rebuild it, I got an exception: -------------------------------- Code: BUILD FAILED C:Program FilesJasperSoftiReport-1.2.6build.xml:146: Error building the jsmooth wrapper at net.charabia.jsmoothgen.ant.JSmoothGen.execute(JSmoothGen.java:97) at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:275) at org.apache.tools.ant.Task.perform(Task.java:364) at org.apache.tools.ant.Target.execute(Target.java:341) at org.apache.tools.ant.Target.performTasks(Target.java:369) at org.apache.tools.ant.Project.executeSortedTargets(Project.java:1216) at org.apache.tools.ant.Project.executeTarget(Project.java:1185) at org.apache.tools.ant.helper.DefaultExecutor.executeTargets(DefaultExecutor.java:40) at org.apache.tools.ant.Project.executeTargets(Project.java:1068) at org.apache.tools.ant.Main.runBuild(Main.java:668) at org.apache.tools.ant.Main.startAnt(Main.java:187) at org.apache.tools.ant.launch.Launcher.run(Launcher.java:246) at org.apache.tools.ant.launch.Launcher.main(Launcher.java:67) Caused by: java.lang.NullPointerException at java.util.Hashtable.get(Hashtable.java:336) at net.charabia.jsmoothgen.skeleton.SkeletonList.getDirectory(SkeletonList.java:107) at net.charabia.jsmoothgen.ant.JSmoothGen.execute(JSmoothGen.java:76) ... 12 more --- Nested Exception --- java.lang.NullPointerException at java.util.Hashtable.get(Hashtable.java:336) at net.charabia.jsmoothgen.skeleton.SkeletonList.getDirectory(SkeletonList.java:107) at net.charabia.jsmoothgen.ant.JSmoothGen.execute(JSmoothGen.java:76) at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:275) at org.apache.tools.ant.Task.perform(Task.java:364) at org.apache.tools.ant.Target.execute(Target.java:341) at org.apache.tools.ant.Target.performTasks(Target.java:369) at org.apache.tools.ant.Project.executeSortedTargets(Project.java:1216) at org.apache.tools.ant.Project.executeTarget(Project.java:1185) at org.apache.tools.ant.helper.DefaultExecutor.executeTargets(DefaultExecutor.java:40) at org.apache.tools.ant.Project.executeTargets(Project.java:1068) at org.apache.tools.ant.Main.runBuild(Main.java:668) at org.apache.tools.ant.Main.startAnt(Main.java:187) at org.apache.tools.ant.launch.Launcher.run(Launcher.java:246) at org.apache.tools.ant.launch.Launcher.main(Launcher.java:67) Total time: 7 seconds C:Program FilesJasperSoftiReport-1.2.6>

lucianc wrote: What I think you misunderstand is the chart dataset increment logic. If you set incrementType="Group" and incrementGroup="DirectionGroup" for a chart dataset, the dataset will only get incremented when the direction group breaks. This is usefull in the chart should display group totals, which is not your case. You need to increment (i.e., feed data to) the chart on each row. With the first data set, the direction group breaks at each row (the direction changes at each step), therefore using group increment is equivalent to using row increment. In the second case, the group breaks only two times (when the direction changes and when the data ends), and only the last value is fed to the chart dataset. Change incrementType to "None" (which is the default, and maybe poorly named) and the charts will be fed data at each row. HTH, Lucian:laugh: Exactly ! I really misunderstood the chart dataset increment logic, your expert conclusion makes me understand the usage and the mechanism of it very clearly now. Thank you very very much Lucian !

After I tried many times, I found lucianc's sulution is ok and may be the simplest and the best solution. I don't know seriesExpression can produced moret than 1 series before. My data set is a little different to the supposing data set, and maybe I misunderstanding the usage of Group, so I can't get what I wanted in chart. See the following two data sets: Data set 1: [code:1] This data set is supposed as the previous post mysql> SELECT Direction, Date(CallBeginTime) AS Date, COUNT(*) AS Count -> FROM CallLog -> WHERE Extract(YEAR_MONTH FROM CallBeginTime)=Extract(YEAR_MONTH FROM '2006-07-19') AND DNI S='186053#' -> GROUP BY Date, Direction; +-----------+------------+-------+ | Direction | Date | Count | +-----------+------------+-------+ | 1 | 2006-07-02 | 20822 | | 2 | 2006-07-02 | 8133 | | 1 | 2006-07-03 | 17582 | | 2 | 2006-07-03 | 6413 | | 1 | 2006-07-04 | 16585 | | 2 | 2006-07-04 | 5845 | | 1 | 2006-07-05 | 16218 | | 2 | 2006-07-05 | 5897 | | 1 | 2006-07-06 | 16201 | | 2 | 2006-07-06 | 5791 | | 1 | 2006-07-07 | 16586 | | 2 | 2006-07-07 | 6317 | | 1 | 2006-07-08 | 15779 | | 2 | 2006-07-08 | 6065 | | 1 | 2006-07-09 | 16333 | | 2 | 2006-07-09 | 6019 | | 1 | 2006-07-10 | 14623 | | 2 | 2006-07-10 | 5812 | | 1 | 2006-07-11 | 5208 | | 2 | 2006-07-11 | 2246 | | 1 | 2006-07-12 | 3755 | | 2 | 2006-07-12 | 1570 | | 1 | 2006-07-13 | 3324 | | 2 | 2006-07-13 | 1456 | | 1 | 2006-07-14 | 3236 | | 2 | 2006-07-14 | 1437 | | 1 | 2006-07-15 | 3623 | | 2 | 2006-07-15 | 1662 | | 1 | 2006-07-16 | 3917 | | 2 | 2006-07-16 | 1787 | | 1 | 2006-07-17 | 3789 | | 2 | 2006-07-17 | 1666 | | 1 | 2006-07-18 | 3482 | | 2 | 2006-07-18 | 1562 | | 1 | 2006-07-19 | 3866 | | 2 | 2006-07-19 | 1801 | | 1 | 2006-07-20 | 1958 | | 2 | 2006-07-20 | 792 | +-----------+------------+-------+ 38 rows in set (18.97 sec) [/code:1] Data set 2: [code:1] This data set is what I actually using mysql> SELECT Direction, Date(CallBeginTime) AS Date, COUNT(*) AS Count -> FROM CallLog -> WHERE Extract(YEAR_MONTH FROM CallBeginTime)=Extract(YEAR_MONTH FROM '2006-07-19') AND DNI S='186053#' -> GROUP BY Direction, Date; +-----------+------------+-------+ | Direction | Date | Count | +-----------+------------+-------+ | 1 | 2006-07-02 | 20822 | | 1 | 2006-07-03 | 17582 | | 1 | 2006-07-04 | 16585 | | 1 | 2006-07-05 | 16218 | | 1 | 2006-07-06 | 16201 | | 1 | 2006-07-07 | 16586 | | 1 | 2006-07-08 | 15779 | | 1 | 2006-07-09 | 16333 | | 1 | 2006-07-10 | 14623 | | 1 | 2006-07-11 | 5208 | | 1 | 2006-07-12 | 3755 | | 1 | 2006-07-13 | 3324 | | 1 | 2006-07-14 | 3236 | | 1 | 2006-07-15 | 3623 | | 1 | 2006-07-16 | 3917 | | 1 | 2006-07-17 | 3789 | | 1 | 2006-07-18 | 3482 | | 1 | 2006-07-19 | 3866 | | 1 | 2006-07-20 | 1961 | | 2 | 2006-07-02 | 8133 | | 2 | 2006-07-03 | 6413 | | 2 | 2006-07-04 | 5845 | | 2 | 2006-07-05 | 5897 | | 2 | 2006-07-06 | 5791 | | 2 | 2006-07-07 | 6317 | | 2 | 2006-07-08 | 6065 | | 2 | 2006-07-09 | 6019 | | 2 | 2006-07-10 | 5812 | | 2 | 2006-07-11 | 2246 | | 2 | 2006-07-12 | 1570 | | 2 | 2006-07-13 | 1456 | | 2 | 2006-07-14 | 1437 | | 2 | 2006-07-15 | 1662 | | 2 | 2006-07-16 | 1787 | | 2 | 2006-07-17 | 1666 | | 2 | 2006-07-18 | 1562 | | 2 | 2006-07-19 | 1801 | | 2 | 2006-07-20 | 792 | +-----------+------------+-------+ 38 rows in set (1.89 sec) [/code:1] For data set 2, I created a DirectionGroup in reports, the expression of DirectionGroup is $F{Direction}. I want a TimeSeriesChart, the TimeSeriesChart will contains two series according different Direction, so I set the SeriesExpression of chart to $F{Direction}, set PeriodExpression to $F{Date}, set ValueExpression to $F{Count}, set IncrementType to Group, set IncrementGroup to DirectionGroup... Although it can generate two series, but only the value of the last date (2006-07-20) displayed, two series becomes two dots. If i changed data set to data set 1, the result is ok. See data set 2, the green group(direction=1) and the blue group(direction=2) are grouped via "GROUP BY" SQL syntax, so I create a DirectionGroup in report, and got a wrong result, Am I misunderstanding the usage of Group ?

gtoffoli wrote: Hi liu, attached there is the solution to your problem solved using a chart (absolutly unuseful) and a crosstab (that is what I think you need). ... Thanks a lot Giulio :laugh: , it seems your solution meet my requirements, I will learn it tomorrow(i mean today, it's 01:00am now here). lucianc wrote: What kind of chart do you want to obtain? Generating distinct series based on the direction can be achieved by simply setting the direction as the series expression: Code: HTH, Lucian I want to obtain a TimeSeriesChart, like the image shows(I use a LineChart instead), my original solution is put TimeSeriesChart in DirectionGroupHeader/DirectionGroupFooter, the Group is group by diretion like your suggestion (see the .zip attachment), see the report sample in the attachment: I can only get one series separately in each group. I will learn Giulio's solution which put chart in SUMMARY band, and use TimeGroup instead of DirectionGroup. by the way: please delete my previous duplicate post, that's post is generated by my mistake refresh operation from browser. [file name=CallCount_100865x_Hourly_Report.zip size=39446] comment of edit: I make a PNG snapshot, it exceed the pixel limitation, after I resized it, the file size even more larger then the original one :ohmy: size=400]http://www.jasperforge.org/components/com_joomlaboard/uploaded/images/sample_chart.png Post edited by: lovetide, at: 2006/07/18 17:24

I've installed jdk1.5.0_07 to C:jdk1.5.0_07, and installed public JRE of it, and then set JAVA_HOME =C:jdk1.5.0_07, and then add %JAVA_HOME%bin to PATH environment variable. Then I installed jdk1.6.0 to C:jdk1.6.0, no public JRE installed of it. Open any DOS console and type java -version, it report the right version I wanted: java version "1.5.0_07". But when I started iReport from iReport.exe, click "Help"->"About iReport" -> "System properties", it shows me that all properties related JRE/JDK is 1.6.0, not 1.5.0_07, how can iReport so "intelligent" and how to manual choose JRE to startup it ? By the way: If i startup iReport from %IREPORT_HOME%binstartup.bat, the JRE/JDK information is 1.5.0_07, that's what I wanted. Thanks !

First, congratulations on the new home of JasperReports & iReport & JasperIntelligence ! (This question is original posted at sf.net) Suppose the following data set: Code: I want the following result/goal: (1). Code: (2). A chart contains two series: 1st is DialIn_Count series, 2nd is DialOut_Count series. Before I use crosstab, I can use report group to group out DialIn and DialOut separately, and each group contains a chart which contains 1 series. So, none of them meet my requirements. After I used crosstab, I achieved the first result/goal, but I still can't get 2 series in ONE chart, so, is there a way to achieve it ? Thanks !

First, congratulations on the new home of JasperReports & iReport & JasperIntelligence ! (This question is original posted at sf.net) Suppose the following data set: Code: I want the following result/goal: (1). Code: (2). A chart contains two series: 1st is DialIn_Count series, 2nd is DialOut_Count series. Before I use crosstab, I can use report group to group out DialIn and DialOut separately, and each group contains a chart which contains 1 series. So, none of them meet my requirements. After I used crosstab, I achieved the first result/goal, but I still can't get 2 series in ONE chart, so, is there a way to achieve it ? Thanks !