rubedogg04

Hi Sherman, Does JasperServer or iReport provide the capability to have a form be able to update a table based on parameters that are entered. I noticed that with these tools you can automate reports, but how about being able to update the database the reports run off of? Is there anything like that in the japser suite. I am curious as i am not very familiar with Java but am a avid user of iReport and Jasperserver. Thanks Ruben

Thanks for answering my question. I have uninstalled jasperser and deleted the mysql directory. I am going to give the installation another try since the guide said it will prompt me for jasperserver and mysql login/pass information. It didn't happen the first time i did a fresh install. Can you please tell me why I wasn't prompted for the login/password information for jasperserver and mysql during the initial windows installation? I also attached the errors messages i received during installation for you to see. Is this a possible bug in the installation. rg

I installed it on my windows xp machine and i never once prompted me for my jasperadmin password, or my mysql password. Now i have a jasperserver installed but no way of loging in. How do i create a password after installation? Thanks!

I just installed jasperserver-3.5.0-windows-installer.exe on my Windows XP machine. Not once during the installation did it prompt me to create the jasperadmin password. Now i am stuck and don't know how to log into Jasperserver. Please help. I also got the following errors during the installation( VIEW IMAGES)

It's been awhile since i last used japser projects and am just installed the windows versions to play around with. When i used Linux versions, I remember there being a Jasper Intelligence report repository (if my memory serves me right), where i can upload all my jrxml files and schedule them to run. I also remember it being webbased. I used to be able to load all my jrxml files and schedule them to run, etc. Is it part of JasperServer? Or has that been integrated with iReport? Thanks, Ruben

Can someone provide me with an example of a Stacked Area Chart that does work. I could never for the life of me get it to work. The stacked bar chart works, but never the area chart. I get no errors when i compile it in iReport. When i try and run it in JasperServer, it renders a graph with no data and the Value Axis is completely wrong. Is this a bug in iReport or Jasperserver or the Stacked Area Chart itself.

My reports used to work in IR 2.0.4 with FIrefox 3.0.1 when i use the HTML Preview, wich is set to use /usr/bin/firefox (which is version 3.0.1) . Now they don't work with iReport 3.0.0. My settings are correct? Is this a bug?

Well, it depends on what you want. First off you will need to create a parameter first. Look under the Document structure. Right click on Parameters to add parameters. Then in your sql query you would use $P{your_value} in place of your field value that you are pulling. Hope this helps.

THe way you create a dashboard is to create one large title band. In the title band, you will add all your subreports.You can click on the subreport button, which is to the right of the graph button. It will take you through the wizard. I suggest you create all your subreports first before creating the dashboad.

Actually, I think it has something to do with Browser cookies because i open them both from two different computers and they both work fine without logging off. I do have different databases and different ports. How does one get around this browser cookie issue?

I am running both JasperServer 2.1 and JasperServer 3.0 on my Centos 5 linux system. I am using mysql databse. JS 2.1 = jasperadmin/jasperadmin JS 3.0 = admin/admin The issue i am experiencing: Logged into JasperServer 2.1 and everyting works fine. I Then log into JasperServer 3.0 and it logs me off of JasperServer 2.1. Does anyone know what is causing this? Is there a file i need to edit so that i can run both of these servers concurrently?

i changed my localhost and it worked.

was able to fix this problem by editing my <apache-tomcat>/webapps/jasperserver /WEB-INF/hibernate.properties Thanks

Hi Tony, I have attached the log files you requested.

I get the following error when trying to login into jasperserver and don't have the slightest clue as to why? Please help me. 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) 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:136) 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:131) 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:131) 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 org.springframework.webflow.util.RandomGuidUidGenerator.generateUid(RandomGuidUidGenerator.java:51) org.springframework.webflow.conversation.impl.SessionBindingConversationManager.beginConversation(SessionBindingConversationManager.java:97) org.springframework.webflow.execution.repository.support.AbstractConversationFlowExecutionRepository.generateKey(AbstractConversationFlowExecutionRepository.java:96) org.springframework.webflow.executor.FlowExecutorImpl.launch(FlowExecutorImpl.java:209) 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.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) $Proxy13.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) 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:136) 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:131) 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:131) 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.

Thanks Matt for replying. Please pardon me as I am just a report writer still learning the whole file structure. If i understand what you are saying, i should do an uninstall and reinstall jasperserver 3.0...and not mess around with jasperserver 2.1 (which is working fine right now). Why can't i just modify the exploded war file? Are you referring to modifying the database configuration files: <install-dir>/apache-tomcat/webapps/jasperserver/META-INF/context.xml or <tomcat-install-dir>conf/Catalina/localhost/jasperserver.xml <install-dir>/apache-tomcat/webapps/jasperserver/WEB-INF/hibernate.properties <install-dir>/apache-tomcat/webapps/jasperserver/WEB-INF/web.xml

i am experiencing the following problem when trying to start my jasperserver. Not sure what's causing this. All i did was change the jasper_init.sh that came with my jasperserver 3.0 distribution to use the "jasperserver2" mysql database instead of the "jasperserver" one type Status report message /jasperserver/login.html description The requested resource (/jasperserver/login.html) is not available. Apache Tomcat/5.5.20PLEASE..SOMEONE HELP. Been stuck on this for 2 days now.

Does anyone know if i can run two different versions of Jasperserver with one MySQL binary? The default mysql database that is created when Jasperserver is installed is "jasperserver". What should i do if i want to run two different versions of Jasperserver? Are there files that need to be edited so that there is no inter-version interference? Please advise.

I am running both Jasperserver 2.1 and 3.0 on the same linux system. They are both useing their own bundled tomcat disturbions. As for the mysql binary, they are both using the same one. And i am trying to have one use jasperserver database and the other use jasperserver2 database. I have jasperserver 2.1 running fine and is currently using the mysql db called jasperserver. As for jasperserver 3.0, I edited the jasper_init.sh script to to use the jasperserver2 mysql database. I edited the jasper_init.sh script to point to jasperserver2 instead of jasperserver thinking this would allow it to use it's own mysql database and not overwrite the other one. Well, i now try and start the application and get a apache tomcat 404 The requested resource (/jasperserver/login.html) is not available. error. here is a copy of my jasper_init.sh. Is there another file i should be editing to get this to work? Can it even be done? #!/bin/bash /usr/bin/mysqladmin drop jasperserver2 -u root --password="montycristo" -h 127.0.0.1 -P 3306 --force /usr/bin/mysql -u root --password="montycristo" -h 127.0.0.1 -P 3306 --force -e "UPDATE mysql.user SET Password=PASSWORD('password') WHERE User='jasperdb';" /usr/bin/mysql -u root --password="montycristo" -h 127.0.0.1 -P 3306 --force -e "FLUSH PRIVILEGES;" /usr/bin/mysql -u root --password="montycristo" -h 127.0.0.1 -P 3306 --force -e "grant all on jasperserver2.* to 'jasperdb'@'%' identified by 'password';" /usr/bin/mysql -u root --password="montycristo" -h 127.0.0.1 -P 3306 --force -e "grant all on jasperserver2.* to 'jasperdb'@'localhost' identified by 'password';" /usr/bin/mysql -u root --password="montycristo" -h 127.0.0.1 -P 3306 --force -e "FLUSH PRIVILEGES;" /usr/bin/mysql -u root --password="montycristo" -h 127.0.0.1 -P 3306 --force -e "create database jasperserver2 character set utf8" /usr/bin/mysql -u root --password="montycristo" -h 127.0.0.1 -P 3306 --force jasperserver2 < /home/rgouveia/apps/jasperserver-3.0/scripts/mysql/jasperserverCreate-mysql.ddl /usr/bin/mysql -u root --password="montycristo" -h 127.0.0.1 -P 3306 --force jasperserver2 -e "source /home/rgouveia/apps/jasperserver-3.0/scripts/mysql/jasperserverCreateDefaultSecurity-mysql.sql" /usr/bin/mysql -u root --password="montycristo" -h 127.0.0.1 -P 3306 --force -e "FLUSH PRIVILEGES;"

I just downloaded the lastest jasperserver 3x and iReport 3x and installed both on my linux machine. I was running 2.0.4 version of iReport prior to installing the 3.0. I am running both parallel. When i go into my iReport3x directory and run the iReport.sh file. It loads up 2.0.4....how in the heck is that happen????? anyone have an explanation for this? please help. thanks

Hi, I am using jasper server and ireport. I like the charts kava provides. how did you get it to work with iReport? iReport uses JFREE Charts and they are outdated looking if you ask me. I would very much like to use the kava charts if possible. i am not very java savvy, but am a long time user of jasper server and iReport. your reply is greatly anticipated. thanks -r

I have 1 report with 2 charts. One chart is on top of the other chart. I want one chart to display if the condition of the print when expression is met and the other if the other condition is met. I have a parameter that is passed 1,2,or 3 into it. If 1 is passed into the parameter give me a chart, if 2 or 3 is passed give me the other chart. here are my print when expressions: Code:$P{p_tab}!="1" $P{p_tab}="1" Theoretically this should work? I keep getting the following errors when i try and compile. ! The left-hand side of an assignment must be a variable ! Cannot cast from a boolean to Boolean.[/ol] Is there something i am doing wrong here? Is this even possible to accomplish? Post edited by: rubedogg04, at: 2008/07/08 20:53

Has anyone created a stacked bar chart before. I can't get mine to render. Does someone have a sample one i can see for reference? Can't find a good example on the samples provided with iReport. I have two companies, and i want to show on a stacked chart downloads vs purchases. please help. thanks

so i gave this a shot. I did this $P!{p_tab} instead of $P{p_tab} and it now works...go figure that all it was was a !. thanks!

no man. i am not doing that . the group by works when i hardcode the value in. It doesn't work when i use the parameter $P{p_tab}. I simply don't think that group bys work with parameters in iReport. here's an example: group by decode($P{p_tab},1,2, 2,2, 2,3) when i run it hardcoded with let's say , 1, i get back the result of 1. When i pass 1 using the parameter, i get the "not a group by function error" I have tested the sql and it works. Just not in iReport.