pentaho

Hi, I have published the Report in Jasper Server 3.1 ( Designed Using iReport 3.1.2), i'm passing Parameters in URL................ I'm displaying the EmployeesList & the Parameter passed in the URL are Age=50&output=pdf. Report Parameters Age=50&output=pdf. Output Type is PDF If I Run the below URL in Mozilla Mozilla/5.0 (Windows; U; Windows NT 5.0; en-US; rv:1.8.1.20) Gecko/20081217 Firefox/2.0.0.20 URL displays the Output in pdf file........... I can save output as pdf file........... http://localhost:8080/jasperserver/flow.html?_flowId=viewReportFlow&reportUnit=/reports/EmployeesList&standAlone=true&ParentFolderUri=/reports&Age=50&output=pdf If I Run the Same URL in Internet Explorer It Shows The Below Error.............. I Have attached the Error Messages pop-up windows ........... Error List(pop-up window)..... some files can harm your computer. if this file information below looks suspicious, or you donot fully trust the source, do not open or save the file. File name: ...&age=50&output=pdf File type: Adobe Acrobat Control for ActiveX From: localhost This type of file could harm your computer if it contains malicious code. Would you like to open the file or save it your computer? Open save Cancel More Info After clicking Open or Save Button the error in the pop-up window is Internet Explorere cannot Download........&age=50&output=pdf from localhost. Internet Explorer was not able to open this Internet site. The requested site is either unavailable or cannot be found. please try agin late. Thanks in advance for any suggestion. Post Edited by pentaho pentaho at 02/03/09 07:35 Post Edited by pentaho pentaho at 02/03/09 08:41

Hi, Thanks for the Quick reply....... It works without problem.............. Thanks...........

Hi, My master Report subreport expression <subreportExpression class="java.lang.String"><![CDATA["repo:\D\IStatus2\report20_subreport1.jasper"]]></subreportExpression> If i give this path , in the next step i'll get ainfo as suggested resources in the report wizard-Resource list............. I have attached the info in jpg & added master & subreport JRXML files......... if you click add new in suggested resources, it shows an error. Error is Here: java.lang.NullPointerExceptionjava.lang.NullPointerException at com.jaspersoft.jasperserver.war.action.FileResourceAction.initAction(FileResourceAction.java:82) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:585) at org.springframework.webflow.util.DispatchMethodInvoker.invoke(DispatchMethodInvoker.java:103) at org.springframework.webflow.action.MultiAction.doExecute(MultiAction.java:136) at org.springframework.webflow.action.AbstractAction.execute(AbstractAction.java:203) at org.springframework.webflow.engine.AnnotatedAction.execute(AnnotatedAction.java:142) at org.springframework.webflow.engine.ActionExecutor.execute(ActionExecutor.java:61) at org.springframework.webflow.engine.ActionState.doEnter(ActionState.java:180) at org.springframework.webflow.engine.State.enter(State.java:200) at org.springframework.webflow.engine.Flow.start(Flow.java:557) at org.springframework.webflow.engine.impl.RequestControlContextImpl.start(RequestControlContextImpl.java:195) at org.springframework.webflow.engine.SubflowState.doEnter(SubflowState.java:120) at org.springframework.webflow.engine.State.enter(State.java:200) at org.springframework.webflow.engine.Transition.execute(Transition.java:229) at org.springframework.webflow.engine.TransitionableState.onEvent(TransitionableState.java:112) at org.springframework.webflow.engine.Flow.onEvent(Flow.java:572) at org.springframework.webflow.engine.impl.RequestControlContextImpl.signalEvent(RequestControlContextImpl.java:207) at org.springframework.webflow.engine.ActionState.doEnter(ActionState.java:185) at org.springframework.webflow.engine.State.enter(State.java:200) at org.springframework.webflow.engine.Transition.execute(Transition.java:229) at org.springframework.webflow.engine.TransitionableState.onEvent(TransitionableState.java:112) at org.springframework.webflow.engine.Flow.onEvent(Flow.java:572) at org.springframework.webflow.engine.impl.RequestControlContextImpl.signalEvent(RequestControlContextImpl.java:207) at org.springframework.webflow.engine.impl.FlowExecutionImpl.signalEvent(FlowExecutionImpl.java:214) at org.springframework.webflow.executor.FlowExecutorImpl.resume(FlowExecutorImpl.java:238) at sun.reflect.GeneratedMethodAccessor179.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:585) at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:281) at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:187) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:154) at org.acegisecurity.intercept.method.aopalliance.MethodSecurityInterceptor.invoke(MethodSecurityInterceptor.java:66) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:176) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:210) at $Proxy13.resume(Unknown Source) at org.springframework.webflow.executor.support.FlowRequestHandler.handleFlowRequest(FlowRequestHandler.java:115) at org.springframework.webflow.executor.mvc.FlowController.handleRequestInternal(FlowController.java:170) at org.springframework.web.servlet.mvc.AbstractController.handleRequest(AbstractController.java:153) at org.springframework.web.servlet.mvc.SimpleControllerHandlerAdapter.handle(SimpleControllerHandlerAdapter.java:45) at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:820) 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.doPost(FrameworkServlet.java:360) at javax.servlet.http.HttpServlet.service(HttpServlet.java:709) at javax.servlet.http.HttpServlet.service(HttpServlet.java:802) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at com.jaspersoft.jasperserver.war.common.UploadMultipartFilter.doFilter(UploadMultipartFilter.java:86) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:264) at org.acegisecurity.ui.switchuser.SwitchUserProcessingFilter.doFilter(SwitchUserProcessingFilter.java:335) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) 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:141) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) at com.jaspersoft.jasperserver.war.util.RequestParameterAuthenticationFilter.doFilter(RequestParameterAuthenticationFilter.java:97) 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 com.jaspersoft.jasperserver.war.UserPreferencesFilter.doFilter(UserPreferencesFilter.java:165) 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:165) 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:202) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) 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:202) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869) at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:664) at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527) at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80) at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684) at java.lang.Thread.run(Thread.java:595) Please check my JRXML files and tell me any thing wrong in subreport expression.......

Hi, In Master file Subreport expression <subreportExpression class="java.lang.String"><![CDATA["D:\IStatus1\sub_BarAssignedEngineerLandscape.jasper"]]></subreportExpression> I have saved al files , jrxml, subreports, images in D:status1 Uploaded two .jrxml subreports by clicking Add Resource button

Hi, I have published a master report(contains two subreports) in jasperserver, I get the below errors............. net.sf.jasperreports.engine.JRRuntimeException: Parameter "DATABASE_TIMEZONE" does not exist.net.sf.jasperreports.engine.JRRuntimeException: Parameter "DATABASE_TIMEZONE" does not exist. at net.sf.jasperreports.engine.query.JRAbstractQueryExecuter.getValueParameter(JRAbstractQueryExecuter.java:495) at net.sf.jasperreports.engine.query.JRAbstractQueryExecuter.getValueParameter(JRAbstractQueryExecuter.java:510) at com.jaspersoft.jasperserver.api.engine.jasperreports.util.JRTimezoneJdbcQueryExecuter.getValueParameter(JRTimezoneJdbcQueryExecuter.java:114) at com.jaspersoft.jasperserver.api.engine.jasperreports.util.JRTimezoneJdbcQueryExecuter.<init>(JRTimezoneJdbcQueryExecuter.java:101) at com.jaspersoft.jasperserver.api.engine.jasperreports.util.JRTimezoneJdbcQueryExecuterFactory.createQueryExecuter(JRTimezoneJdbcQueryExecuterFactory.java:53) at net.sf.jasperreports.engine.fill.JRFillDataset.createQueryDatasource(JRFillDataset.java:665) at net.sf.jasperreports.engine.fill.JRFillDataset.initDatasource(JRFillDataset.java:588) at net.sf.jasperreports.engine.fill.JRBaseFiller.setParameters(JRBaseFiller.java:1212) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:842) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:791) at net.sf.jasperreports.engine.fill.JRFillSubreport.fillSubreport(JRFillSubreport.java:540) at net.sf.jasperreports.engine.fill.JRSubreportRunnable.run(JRSubreportRunnable.java:63) at net.sf.jasperreports.engine.fill.JRThreadSubreportRunner.run(JRThreadSubreportRunner.java:209) at java.lang.Thread.run(Thread.java:595)

Hi, I'm using CRM tool to develop an application, i'm using jasper server to display the reports....... Instead of passing parametrs & jrxml file at jasper server side, can i pass parametrs & jrxml files from my application. whether the jasperserver will accept parametrs from my application.

Hi, Export the Report to PDF I have created one report in Jasper server 3.1(using .jrxml file) jasper server is displaying the output, Internet Explorer if i click pdf button (Export the Report to PDF), the below link will be opened in new Internet explorer and it will not show any output(pdf), just a blank page ....... http://localhost:8080/jasperserver/flow.html;jsessionid=2BAD83C374DF0EE3595EEF7382BAB61E I tried the below link without jsessionid , still i'm getting same balnk page(no pdf output).......... http://localhost:8080/jasperserver/flow.html It shows the below error in jasper server org.springframework.webflow.executor.support.FlowExecutorArgumentExtractionException:Unable to extract the flow definition id parameter:make sure the client provides the '_flowId' parameter as input or set the 'defaultFlowId' property;the parameters provided in this request are: map[[empty]] Mozilla I'm using mozilla Firefox version 2.0.0.20 It shows PDF output without any Errors............... It uses the below link if i click Export the Report to PDF http://localhost:8080/jasperserver/flow.html

Hi, where exactly import/export tool is available in JasperServer

Hi, I have created 10 reports in jasper server(parameterised reports), designed using iReports........ All these reports are created in my local system. Now i need to move all my Reports to client system, how can move or copy all the reports which are working in my local system to remote or client system. Thanks.....

Hi, I got the solution.......

Hi, If any one has implemented how to get the records between two dates, .......... simple sql queryIireport) this is parameterised report select a,b,c from table1 where date1 >= $P{StartDate} and date2 <= $P{EndDate} Values entered through calendar(iReport) $P{StartDate} , $P{EndDate} please send me the query(iReport) and steps involved in the jasperserver(Date parameter creation)........... Thanks

Hi, My MS SQL Query in iReport......... select Title, dateadd(second, Create_Date,'01-01-1970') Create_Date FROM Service_Request where CONVERT(datetime, dateadd(second, Create_Date,'01-01-1970')) >=$P{StartDate} i'm using datadd function to convert integer value to datetime data type........ The date is stored in a longint format or in a simple way my query will be like this.. select Title, Create_Date FROM Service_Request where Create_Date >=$P{StartDate} output.......... Titles Create_Date abc 2009-01-20 05:08:07.000 xyz 2009-01-20 05:15:41.000 dd 2009-01-20 05:31:38.000 I have created one parameter $P{StartDate} in ireport of date type and i''m getting output in iReport.... I'm not getting output in JasperServer............. Create_Date value is 01-20-2009 through calendar , (parameter passing in jasper server) I have added a date control variable in jasper server( it shows Empty report).............. tell me any thing wrong in my query or wrong in parameter passing in jasper server......... Thanks

Hi, No need to pass any parameters.......... without parameters it works........

Hi, Got a solution from the previous post Post Name & Date Direct url access to reports with no auth. 10/15/2008 10:22 Login as jasperadmin/jasperadmin(password) Created a new folder inside Report folder(MyReports). created simple reports inside Myreport folder. Right click the MyReport folder & Assign ROLE_ANONYMOUS read only permission. Edit the applicationContent-security.xml as followsEdit 1: <bean id="filterInvocationInterceptor" class="org.acegisecurity.intercept.web.FilterSecurityInterceptor"> ....... ....... /flow.html=ROLE_USER,ROLE_ANONYMOUS /fillparams.html=ROLE_USER,ROLE_ANONYMOUS /fileview/**=ROLE_USER,ROLE_ANONYMOUS /reportimage/**=ROLE_USER,ROLE_ADMINISTRATOR Edit 2: <bean id="anonymousProcessingFilter" class="org.acegisecurity.providers.anonymous.AnonymousProcessingFilter"> <property name="key"><value>foobar</value></property> <!-- <property name="userAttribute"><value>anonymousUser,ROLE_ANONYMOUS</value></property> --> // comment this line & add the below line <property name="userAttribute"><value>anonymousUser,ROLE_USER</value></property> </bean> Edit 3: <bean id="flowVoter" class="com.jaspersoft.jasperserver.war.security.FlowRoleAccessVoter"> <property name="flowAccessAttribute" value="FLOW_ACCESS"/> <property name="flowDefinitionSource"> <value> *=ROLE_USER,ROLE_ADMINISTRATOR,ROLE_ANONYMOUS // Changes(Add ROLE_ANONYMOUS ) </value> Restart JasperServer. Try to access the Report URL Post Edited by pentaho pentaho at 01/16/09 05:21

Hi, I have created a report in jasper server using .jrxml file(created using ireport). http://localhost:8001/jasperserver/flow.html?_flowId=viewReportFlow&reportUnit=/reports/MyReports/TopTenRequests&standAlone=true&ParentFolderUri=/reports/MyReports The above link will shows the created report, before accessing this page i need to enter login name & password for jasperserver (see the below URL)........ http://localhost:8080/jasperserver/login.html Is there any way can i by pass the login page(login name & password) and directly acces the above url ... I would appreciate any help..... Thanks pentaho