zhangweiwu

The download link doesn't work for me. I've tried http://www.jasperforge.org/index.php?option=com_docman&task=doc_download&gid=166&Itemid=248 It opens a blank (white background) page in Firefox from China. It opens a blank (black background) page in lynx from Germany (which I login through ssh).

You can try to delete de ^M chars this way: This should be possible to be done directly by the person who packages the software, right? He could have removed the carrier returns before and save the trouble.

I just happen to see the release of JasperAnalysis Workbench. That might be the tool I need. I'll check it.

Hello. I've been evaluating jasper server professtional edition for fitness of our business. In our business we need ad-hoc reporting possibility only on aggregated data, where the user should be able to define how data gets aggregated (min? max? average?). I finshed walk-through ad-hoc editor and analysis tool of 3.0-pro following evaluation guide. Dispite some parts doesn't work (see the other post I made) generally I think the software is fast and very easy to use. Although I couldn't see options to allow us solve our own business problem, I think probably the feature I need are offered in a different packages or features not revealed in evaluation guide. One example: The ad-hoc editor as I can tell is a tool for flexible grouping data, make charts and format report. While in our case we usualy do not care about data itself but only aggregated data, but I didn't see different aggregation optioins. e.g. How do I get a report of the average of age for people buying different category of our products though the recent 10 years? Code: Year Product_Category Average_buyer_age 2006 Postal_Cards 27 Gifts 30 ... 2007 28 ... I can understand aggregation rules probably does not have to be configurable on ad-hoc editor because more or less many data fields should have fixed aggregation rules (e.g. we always are interested in the average of age never the sum of age) and can be defined by database administrator somewhere else in this product. But where? Can I have a look at the capacity? I also looked into Data Analysis feature (the one that use jPivot and let me drill data on the web). Very nice and easy to use tool! Again I didn't find options to define measurements and the way they are aggrigated. Speak of a raw DB table, a db table column sometimes is a measurement, sometimes is a filter, and sometimes can be dimension. E.g. "income of household", when used for dividing poor household, difficult ones, rich ones, is a dimension; when used as judgement of poverty level in a region it is measurement; and when we only working on only poor household, it is a filter. We will need all these kinds of flexibility, they must be defined somewhere and controlable. Thank you very much and sorry for stupid questions:) Post edited by: zhangweiwu, at: 2008/07/13 03:04

And more error messages when I click "show chart". Only this time I could not copy & paste the error message (because it's not selectable) so here is the screenshot: http://img503.imageshack.us/img503/1394/jasperserveradhoteditorkv7.th.png

Hello. I am evaluating the newly released jasper-server pro 3.0 and working in evaluating ad-hoc report. following the evaluation guide I had been fine until I click "Run Report" and get the following error. I could not read Java error messages so I don't know which of the full-screenful of error message is the keyword to search for solution in google, so here I ask the forum. Platform: Ubuntu 7.10 -x86 (32-bit). Accessing: http://localhost:8080/jasperserver-pro/flow.html?_flowId=viewAdhocReportFlow&runTempARU=true Code: HTTP Status 500 - type Exception report message description The server encountered an internal error () that prevented it from fulfilling this request. exception org.springframework.web.util.NestedServletException: Handler processing failed; nested exception is java.lang.NoClassDefFoundError org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:860) org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:755) org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:396) org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:350) javax.servlet.http.HttpServlet.service(HttpServlet.java:689) javax.servlet.http.HttpServlet.service(HttpServlet.java:802) com.jaspersoft.jasperserver.war.common.UploadMultipartFilter.doFilter(UploadMultipartFilter.java:86) org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:264) org.acegisecurity.ui.switchuser.SwitchUserProcessingFilter.doFilter(SwitchUserProcessingFilter.java:335) org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) org.acegisecurity.intercept.web.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:107) org.acegisecurity.intercept.web.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:72) org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) org.acegisecurity.ui.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:110) org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) com.jaspersoft.ji.license.JILicenseFilter.doFilter(JILicenseFilter.java:107) org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) org.acegisecurity.providers.anonymous.AnonymousProcessingFilter.doFilter(AnonymousProcessingFilter.java:125) org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) com.jaspersoft.jasperserver.api.metadata.user.service.impl.MetadataAuthenticationProcessingFilter.doFilter(MetadataAuthenticationProcessingFilter.java:141) org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) com.jaspersoft.jasperserver.war.util.RequestParameterAuthenticationFilter.doFilter(RequestParameterAuthenticationFilter.java:97) org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) org.acegisecurity.ui.basicauth.BasicProcessingFilter.doFilter(BasicProcessingFilter.java:181) org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) com.jaspersoft.jasperserver.war.UserPreferencesFilter.doFilter(UserPreferencesFilter.java:165) org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) org.acegisecurity.ui.AbstractProcessingFilter.doFilter(AbstractProcessingFilter.java:217) org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) com.jaspersoft.jasperserver.war.UserPreferencesFilter.doFilter(UserPreferencesFilter.java:165) org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) org.acegisecurity.context.HttpSessionContextIntegrationFilter.doFilter(HttpSessionContextIntegrationFilter.java:191) org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) org.acegisecurity.util.FilterChainProxy.doFilter(FilterChainProxy.java:148) org.acegisecurity.util.FilterToBeanProxy.doFilter(FilterToBeanProxy.java:90) com.jaspersoft.jasperserver.war.util.CharacterEncodingFilter.doFilter(CharacterEncodingFilter.java:70) org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:138) root cause java.lang.NoClassDefFoundError java.lang.Class.forName0(Native Method) java.lang.Class.forName(Class.java:164) java.awt.GraphicsEnvironment.getLocalGraphicsEnvironment(GraphicsEnvironment.java:68) net.sf.jasperreports.engine.util.JRGraphEnvInitializer.initializeGraphEnv(JRGraphEnvInitializer.java:58) net.sf.jasperreports.engine.fill.JRBaseFiller.<init>(JRBaseFiller.java:363) net.sf.jasperreports.engine.fill.JRVerticalFiller.<init>(JRVerticalFiller.java:77) net.sf.jasperreports.engine.fill.JRVerticalFiller.<init>(JRVerticalFiller.java:59) net.sf.jasperreports.engine.fill.JRFiller.createFiller(JRFiller.java:147) net.sf.jasperreports.engine.fill.JRFiller.fillReport(JRFiller.java:83) net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:601) com.jaspersoft.ji.adhoc.service.AdhocEngineServiceImpl.fillReport(AdhocEngineServiceImpl.java:536) com.jaspersoft.ji.adhoc.action.ViewAdhocReportAction.verifyData(ViewAdhocReportAction.java:165) sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) java.lang.reflect.Method.invoke(Method.java:585) org.springframework.webflow.util.DispatchMethodInvoker.invoke(DispatchMethodInvoker.java:103) org.springframework.webflow.action.MultiAction.doExecute(MultiAction.java:136) org.springframework.webflow.action.AbstractAction.execute(AbstractAction.java:203) org.springframework.webflow.engine.AnnotatedAction.execute(AnnotatedAction.java:142) org.springframework.webflow.engine.ActionExecutor.execute(ActionExecutor.java:61) org.springframework.webflow.engine.ActionState.doEnter(ActionState.java:180) org.springframework.webflow.engine.State.enter(State.java:200) org.springframework.webflow.engine.Transition.execute(Transition.java:229) org.springframework.webflow.engine.TransitionableState.onEvent(TransitionableState.java:112) org.springframework.webflow.engine.Flow.onEvent(Flow.java:572) org.springframework.webflow.engine.impl.RequestControlContextImpl.signalEvent(RequestControlContextImpl.java:207) org.springframework.webflow.engine.ActionState.doEnter(ActionState.java:185) org.springframework.webflow.engine.State.enter(State.java:200) org.springframework.webflow.engine.Flow.start(Flow.java:557) org.springframework.webflow.engine.impl.RequestControlContextImpl.start(RequestControlContextImpl.java:195) org.springframework.webflow.engine.impl.FlowExecutionImpl.start(FlowExecutionImpl.java:189) org.springframework.webflow.executor.FlowExecutorImpl.launch(FlowExecutorImpl.java:206) sun.reflect.GeneratedMethodAccessor247.invoke(Unknown Source) sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) java.lang.reflect.Method.invoke(Method.java:585) org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:281) org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:187) org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:154) org.acegisecurity.intercept.method.aopalliance.MethodSecurityInterceptor.invoke(MethodSecurityInterceptor.java:66) org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:176) org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:210) $Proxy17.launch(Unknown Source) org.springframework.webflow.executor.support.FlowRequestHandler.handleFlowRequest(FlowRequestHandler.java:131) org.springframework.webflow.executor.mvc.FlowController.handleRequestInternal(FlowController.java:170) org.springframework.web.servlet.mvc.AbstractController.handleRequest(AbstractController.java:153) org.springframework.web.servlet.mvc.SimpleControllerHandlerAdapter.handle(SimpleControllerHandlerAdapter.java:45) org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:820) org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:755) org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:396) org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:350) javax.servlet.http.HttpServlet.service(HttpServlet.java:689) javax.servlet.http.HttpServlet.service(HttpServlet.java:802) com.jaspersoft.jasperserver.war.common.UploadMultipartFilter.doFilter(UploadMultipartFilter.java:86) org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:264) org.acegisecurity.ui.switchuser.SwitchUserProcessingFilter.doFilter(SwitchUserProcessingFilter.java:335) org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) org.acegisecurity.intercept.web.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:107) org.acegisecurity.intercept.web.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:72) org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) org.acegisecurity.ui.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:110) org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) com.jaspersoft.ji.license.JILicenseFilter.doFilter(JILicenseFilter.java:107) org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) org.acegisecurity.providers.anonymous.AnonymousProcessingFilter.doFilter(AnonymousProcessingFilter.java:125) org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) com.jaspersoft.jasperserver.api.metadata.user.service.impl.MetadataAuthenticationProcessingFilter.doFilter(MetadataAuthenticationProcessingFilter.java:141) org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) com.jaspersoft.jasperserver.war.util.RequestParameterAuthenticationFilter.doFilter(RequestParameterAuthenticationFilter.java:97) org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) org.acegisecurity.ui.basicauth.BasicProcessingFilter.doFilter(BasicProcessingFilter.java:181) org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) com.jaspersoft.jasperserver.war.UserPreferencesFilter.doFilter(UserPreferencesFilter.java:165) org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) org.acegisecurity.ui.AbstractProcessingFilter.doFilter(AbstractProcessingFilter.java:217) org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) com.jaspersoft.jasperserver.war.UserPreferencesFilter.doFilter(UserPreferencesFilter.java:165) org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) org.acegisecurity.context.HttpSessionContextIntegrationFilter.doFilter(HttpSessionContextIntegrationFilter.java:191) org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) org.acegisecurity.util.FilterChainProxy.doFilter(FilterChainProxy.java:148) org.acegisecurity.util.FilterToBeanProxy.doFilter(FilterToBeanProxy.java:90) com.jaspersoft.jasperserver.war.util.CharacterEncodingFilter.doFilter(CharacterEncodingFilter.java:70) org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:138) note The full stack trace of the root cause is available in the Apache Tomcat/5.5.20 logs. Apache Tomcat/5.5.20

I've checked the BI stuff there on jaspersoft including the ad-hoc report design. I'd like to say it's impressingly simple to create a report with that tool, but I don't see enough options and mechanism in the live demo that can make reports we need here. E.g. having able to let developer create meta-data layer and set up domain looks powerful, but the developer drags and drops, I don't see how I can let power user make reports like CASE_2 where it involve comparing data aggridated by selected records (in costal and not in costal area) in one report row. In order to know a product I should follow evaluation guide, documentation, manual, do experiments etc. I'm not going to be lazy on that but at time constraint I wish to first to know if it's possible to solve the 3 typical our cases with ad-hoc designer. Currently I could not manage to get iReport to solve the 3 cases (without using SQL knowledge) so I really need to know if a even simpler software (ad-hoc report) can do that (provide we prepared good meta-layer). By the way, what is the purpose of Report Wizard? The Report Wizard in Pentaho, as said in documents, serve as an intermedia tool to help power user to make report without using the complex-looking report designer (and thus offered as a standalone product too). Is the Report Wizard in iReport serve the same group of user? Or is it also targeted at developers just to make them kick-start design of a report? It's a bit confusing because Pentaho Report Wizard looks alike iReports (except provided more features and controls, e.g. like providing adding a chart). Also I do not see such thing like ad-hoc report designer in Pentaho, so I am guessing they are trying to use Report Wizard to serve this purpose (more or less). Sorry to mention Pentaho so many times. This is because I just evaluated their solution (without meta-data layer yet, because Pentaho seems to have too poor document for this, or I am too stupid to do it). Now I run out of time but still want to evaluate more solutions before I purchase one.

Hello I've been working on a project with the goal to train non-geek power users, users who do not know and find it difficult to learn SQL and Java, but can manage Excel formulars, to be able to design reports. My question is how far can these users go without knowledge on both SQL and Java (with only groovy knowlege we train them), provide they have the data set we (geeks) carefully designed that give them most flexibility? I'll split my question into several case studies and consult the group here. If we give power users a very general data-set, like this (just an example, we are not really a global business^_^): Code: FIELDS RECORD_1 RECORD_2 RECORD_3 ... Subsiduary_name Office 1 Office 2 Office 3 ... Year 2000 2000 2000 .... City City 1 City 2 City 3 ... Country US Canada Canada Sales_by_revenue 30 20 35 ... Sales_by_item 50 60 65 ... Is_In_Costal_City True True False Sales_of_industrial_products ....... Sales_of_consumer_goods ....... Let's say we have 100 subsiduaries and 5 year's data, so we end up with 500 records. Suppose the data-set is pre-ordered by Year, Country, City and then Subsiduary. REPORT CASE 1: Can they make reports like this, with only GUI and groovy? For ALL subsiduraies, growth of sales in total: Code:[code] Year Sales Growth (compare with last year) 2000 500 n.a. 2001 530 6% 2002 560 5.66% 2003 600 7.14% ... REPORT CASE 2: Can they make reports like this, with only GUI and groovy? For ALL subsiduraies, comparision of costal and non-costal: Code:[code] Year Revenue_in_Costal_subsiduraies Revenue_in_total Percentage_by_costal_subsiduraies 2000 300 500 60% 2001 350 530 66% 2002 560 360 64.3% ... REPORT CASE 3: Total Sales of: Code:[code] Year Industrial_Products Consumder_Goods Percentage 2002 340 140 71% 2003 350 150 70% I have other cases, but if iReport can handle these 3 examples that give me some confidence in general. People would say, if you want flexibility you learn SQL or hire someone who does. This is practically difficult due to the nature of this project. For me I want to give user data-set as general as possible (with limited dimentions) and check how many cases user can handle. It's a real need at the moment. Or do I need some kind of full BI suit like Pentaho, besides the reporting sofeware? Thank you very much. Sorry if I asked stupid questions, I only started evaluating iReport. P. S. the cases are invented for easier understanding of our requirements. In fact we are not doing sales at all. The example is just an analogue. Our real business is too difficult to explain here as it require a lot of special business knowledge to understand.

Actually I am a bit surprised to have downloaded iReport 3.0.0 and fail to run it. It is Java app so it should run everywhere right? As soon as it turns out it's a jar file missing... Please be more careful packaging it and please fix this problem asap to avoid small packaging mistake japerdize reputation of iReport.