prasad23

Finally i resolved the issue. i added the document which contain information about how to resolve the issue,

Hi to all, I am facing one issue with Passing parameters from one report to another report. Actually i created two reports using Jasper server Domain design.i Created two derived table and from this i created two reports.i With ireport i added one hyperlink to the second report in first report.But both reports having same filters.If i want to pass parameters from first report to the hyperlinked report.i am not getting the filters from first report to the second report. Jasper server taking filter as "Der_Mapping_List.Mapping_Name" .i.e first report derived talbe name and the column name and also it is considering the resource id name for each filter.For the second report the filter resource id's are different. Can anybody help me.

Hi to all, I am facing one issue with Passing parameters from one report to another report. Actually i created two reports using Jasper server Domain design.i Created two derived table and from this i created two reports.i With ireport i added one hyperlink to the second report in first report.But both reports having same filters.If i want to pass parameters from first report to the hyperlinked report.i am not getting the filters from first report to the second report. Jasper server taking filter as "Der_Mapping_List.Mapping_Name" .i.e first report derived talbe name and the column name and also it is considering the resource id name for each filter.For the second report the filter resource id's are different.Can anybody help me.

Hi, I am recently having a problems with the jasper server ad-hoc report designer. I am using mssql server 2005 as database.I created a domain besing on datasource,from this i want to create ad-hoc report.i had two input controls for that report.If i created an ad-hoc report without the input conmtrol,i am able to get the report but if given two filters in the designer, I am unable to create the ad-hoc report.which giving an error that java.lang.RuntimeException: Exception in createJSONObject: java.lang.RuntimeException: Exception in createJSONObject: java.lang.NullPointerException at com.jaspersoft.commons.dataset.expr.ExpressionJSONConverter.createJSONObject(ExpressionJSONConverter.java:309) at com.jaspersoft.ji.adhoc.InteractiveDataLayoutEngine.translateSubFilter(InteractiveDataLayoutEngine.java:407) at com.jaspersoft.ji.adhoc.InteractiveDataLayoutEngine.getExistingFilters(InteractiveDataLayoutEngine.java:370) at com.jaspersoft.ji.adhoc.InteractiveDataLayoutEngine.commonViewModelInit(InteractiveDataLayoutEngine.java:98) at com.jaspersoft.ji.adhoc.InteractiveTableEngine.populateViewModel(InteractiveTableEngine.java:81) at com.jaspersoft.ji.adhoc.InteractiveTableEngine.generateViewModel(InteractiveTableEngine.java:366) at com.jaspersoft.ji.adhoc.InteractiveEngine.getInteractiveReport(InteractiveEngine.java:123) at com.jaspersoft.ji.adhoc.action.AdhocAjaxController.generateReport(AdhocAjaxController.java:1360) at com.jaspersoft.ji.adhoc.action.AdhocAjaxController.save(AdhocAjaxController.java:612) 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:597) at org.springframework.web.servlet.mvc.multiaction.MultiActionController.invokeNamedMethod(MultiActionController.java:473) at org.springframework.web.servlet.mvc.multiaction.MultiActionController.handleRequestInternal(MultiActionController.java:410) at org.springframework.web.servlet.mvc.AbstractController.handleRequest(AbstractController.java:153) at com.jaspersoft.ji.adhoc.action.AdhocAjaxController.handleRequest(AdhocAjaxController.java:143) at org.springframework.web.servlet.mvc.SimpleControllerHandlerAdapter.handle(SimpleControllerHandlerAdapter.java:48) at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:875) at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:807) at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:571) at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:501) at javax.servlet.http.HttpServlet.service(HttpServlet.java:617) at javax.servlet.http.HttpServlet.service(HttpServlet.java:717) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.jaspersoft.jasperserver.war.common.UploadMultipartFilter.doFilter(UploadMultipartFilter.java:83) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:394) at com.jaspersoft.jasperserver.war.security.JSSwitchUserProcessingFilter.doFilterHttp(JSSwitchUserProcessingFilter.java:154) at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:406) at org.springframework.security.intercept.web.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:109) at org.springframework.security.intercept.web.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:83) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:406) at org.springframework.security.ui.ExceptionTranslationFilter.doFilterHttp(ExceptionTranslationFilter.java:101) at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:406) at com.jaspersoft.ji.license.LicenseCheckFilter.doFilter(LicenseCheckFilter.java:110) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:406) at com.jaspersoft.ji.license.JILicenseFilter.doFilter(JILicenseFilter.java:96) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:406) at org.springframework.security.providers.anonymous.AnonymousProcessingFilter.doFilterHttp(AnonymousProcessingFilter.java:105) at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:406) at com.jaspersoft.jasperserver.api.metadata.user.service.impl.MetadataAuthenticationProcessingFilter.doFilter(MetadataAuthenticationProcessingFilter.java:139) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:406) at com.jaspersoft.jasperserver.war.util.RequestParameterAuthenticationFilter.doFilter(RequestParameterAuthenticationFilter.java:97) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:406) at com.jaspersoft.jasperserver.multipleTenancy.MTBasicProcessingFilter.doFilterHttp(MTBasicProcessingFilter.java:180) at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:406) at com.jaspersoft.jasperserver.war.UserPreferencesFilter.doFilter(UserPreferencesFilter.java:184) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:406) at org.springframework.security.ui.AbstractProcessingFilter.doFilterHttp(AbstractProcessingFilter.java:278) at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:406) at com.jaspersoft.jasperserver.war.UserPreferencesFilter.doFilter(UserPreferencesFilter.java:184) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:406) at com.jaspersoft.jasperserver.api.logging.filter.BasicLoggingFilter.doFilter(BasicLoggingFilter.java:53) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:406) at org.springframework.security.context.HttpSessionContextIntegrationFilter.doFilterHttp(HttpSessionContextIntegrationFilter.java:235) at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:406) at org.springframework.security.util.FilterChainProxy.doFilter(FilterChainProxy.java:185) at org.springframework.security.util.FilterToBeanProxy.doFilter(FilterToBeanProxy.java:99) 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:67) at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:236) at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:167) 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:233) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:558) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298) at org.apache.coyote.http11.Http11AprProcessor.process(Http11AprProcessor.java:859) at org.apache.coyote.http11.Http11AprProtocol$Http11ConnectionHandler.process(Http11AprProtocol.java:579) at org.apache.tomcat.util.net.AprEndpoint$Worker.run(AprEndpoint.java:1555) at java.lang.Thread.run(Thread.java:619) Can anybody help me to solve my problem,,,,, Thanks in advance...

Hi, I am facing problem with date as input control in Jasper Server ad-hoc report creation. In my report i have 3 input controls.second input control is based on the first inout control and third input control is based upon the first input control and second input control.And also the date input control had between clause. When i select the first inout control,then second and third input control must reflect and if select second input control,third input control must reflect basing on the second input control. I am able to get the first two input controls properly by cascading multiselect. for example: folder name : ram workflow name : workflow1 start time between 071811 5:28:11pm and 071811 5:28:15 pm I am able get this three input control other than the date like folder name : ram worklfow name : workflow1 task name : task_work1 when i select the folder name,the two other input controls are reflecting based on the folder name,after i select the second input control,third one reflecting basing second one, But i am facing proble with that date as input control Code: Post Edited by prasad23 at 07/18/2011 12:03 Post Edited by prasad23 at 07/19/2011 03:46

Hi, I am new to the jasper server,can anybody help me regarding the following error I am using jasper server for cereating adhoc report with domain as datasource.In this adhoc report i am having two filters.if i am using the only one filter there is now problem for saving the reprot,if i am using two filters ,i am getting the filters but i am unable to save the report. it giving the following error Illegal XML character: 0x1f org.apache.xmlbeans.impl.piccolo.io.IllegalCharException: Illegal XML character: 0x1f May i know what is the wxact problem for this error.please help me it is very urgent

Hi, i am new to tyhe jasper server,can anybody help me ragarding this error while saving adhoc report using domain i am getting the following error Illegal XML character: 0x1f org.apache.xmlbeans.impl.piccolo.io.IllegalCharException: Illegal XML character: 0x1f Is there anybody help me to solve the problem,very urgent Thanks in advance.

Hi to all, I want to Dovelop subreporpts from Adhoc Report without using any external jrxml file ,Is it possible to to do using JasperServer. If we can,give me an example which is very helpfull for me ,if we can't what are the Other ways to do that Thank you very much...

Hi, I am NEWBEE to Jasper serever I have a problem with WHERE and AND conditionS of sql in Domain creation. Actually what i want to do is ,i don't want to use SQL WHEREand AND conditions in my query in while getting derived tables. I want to use it in either calculated field or frefilters,Let me know wherther we have that option or not,if it is give me some example,

Use Datasource as EmptyDatasource then it will definately works.

How can i use scriptlets in Adhoc Report using Domain

Steps to use Scriptlets in Jasper Server: ----------------------------------------- 1.Fist create scriptlet for which you want to use. 2.create a jar file for that scriptlet 3.create a report set the class path of jar file 4.use that scriptlet in your iReport report like:{SCRIPTLET}.functionname(); 5.put that Scriptlet class in scriptletClass="test.TestScriptlet" 6.add this iReport to the JasperServer and place this jar file in add input contrtoller in the jasperserver