[Scriptlets in Adhoc reports]

have this feature implemented in new 5.6?

[encrypt password at applicationContext-externalAuth-LDAP.xml]

 <bean id="ldapContextSource" class="com.jaspersoft.jasperserver.api.security.externalAuth.ldap.JSLdapContextSource">

        <constructor-arg value="ldap://192.168.187.128:389/"/>

        <!-- manager user name and password (may not be needed)  -->

       <!-- <property name="userDn" value="*** LDAP manager RDN. E.g. cn=Manager,o=Jaspersoft ***"/>

        <property name="password" value="***LDAP manager password***"/> -->

 

<property name="userDn" value="cn=admin,dc=localdomain"/>

        <property name="password" value="admin"/>

    </bean>

 

can we use encrypted value in password property?

 

thank you

[jrxml topic security]

Hi, I created topic using jrxml because i want to use 2 parameters in the columns.

However, i found difficulty to set the column-level security in this topic.

is there any way we can create column-level security in jrxml topic?

 

[Error trying to access tomcat for the first time (5.2, linux)]

please refer to this http://community.jaspersoft.com/questions/533698/problem-jasperserver-pro-370-integration

[jasperserver add extra column from different database table]

Hi,

I have 1 set of domain which pull user account data.

the Idea is to let user to create adhoc view using this domain and create their own filter. After they had completed the user list, i want them to select the job_id that they want to assign to all of this user list.

this job_id is from other database table which does not have relationship with user account data.

I know if i use iReport, i can use the parameter, but user will not able to create their own filter. Hence, i need to use adhoc view screen.

please advise and give some pointer.

Regards

KH

[how to edit export as excel to save file to server side certain directory?]

thanks, i edited the abstractclass to copy the outputstream to file

[how to edit export as excel to save file to server side certain directory?]

Hi,

I would like to add the function in export as excel jasperserver 5.2 to save the file into server side.

please advise and give some pointer.

 

thank you

[Jasperserver Excel Output file]

thanks, but we do not use ireport to create the report.. we are using adhoc.. so it seems adhoc report is not able to do that..

[Jasperserver Excel Output file]

HI Ankur,

 

I am using Jasperserver 5.0.1 and create Adhoc View / Adhoc Report

[Jasperserver Excel Output file]

Hi, 

Is there a setting to change the excel worksheet name from default "test" to just standard worksheet name like sheet 1?

Thank you

[Jasperservre 4.5.1 64bits version for CUSTOM FIELD FILTERING]

 bump anyone can help??

[Jasperservre 4.5.1 64bits version for CUSTOM FIELD FILTERING]

I have created a custom field from 6 fields;

then i created the filter;

However, when I ran the report it encounters below errors

Code:

2012-07-04 15:29:39,423 ERROR JDBCExceptionReporter,http-8181-4:101 - Batch entry 0 insert into JIResourceFolder (version, uri, hidden, name, label, description, parent_folder, creation_date, update_date, id) values ('0', '/organizations/organization_1/temp/aru1341386426814_files/field_3_1_files', '1', 'field_3_1_files', 'QTY_ON_HAND + QTY_ON_ORDER + QTY_BACK_ORDER + PJ_QTY_BACK_ORDER + MIN_HOLDING_QTY + MAX_HOLDING_QTY is between', NULL, '18722', '2012-07-04 15:29:39.381000 +08:00:00', '2012-07-04 15:29:39.381000 +08:00:00', '18729') was aborted.  Call getNextException to see the cause.2012-07-04 15:29:39,426 ERROR JDBCExceptionReporter,http-8181-4:101 - ERROR: value too long for type character varying(100)2012-07-04 15:29:39,427 ERROR AbstractFlushingEventListener,http-8181-4:325 - Could not synchronize database state with sessionorg.hibernate.exception.DataException: Could not execute JDBC batch update	at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:100)	at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)	at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:275)	at org.hibernate.jdbc.AbstractBatcher.prepareStatement(AbstractBatcher.java:114)	at org.hibernate.jdbc.AbstractBatcher.prepareStatement(AbstractBatcher.java:109)	at org.hibernate.jdbc.AbstractBatcher.prepareBatchStatement(AbstractBatcher.java:244)	at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2242)	at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2678)	at org.hibernate.action.EntityInsertAction.execute(EntityInsertAction.java:79)	at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:279)	at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:263)	at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:167)	at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:322)	at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:50)	at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1028)	at org.springframework.orm.hibernate3.HibernateTemplate$28.doInHibernate(HibernateTemplate.java:892)	at org.springframework.orm.hibernate3.HibernateTemplate.doExecute(HibernateTemplate.java:419)	at org.springframework.orm.hibernate3.HibernateTemplate.executeWithNativeSession(HibernateTemplate.java:374)	at org.springframework.orm.hibernate3.HibernateTemplate.flush(HibernateTemplate.java:890)	at com.jaspersoft.jasperserver.api.metadata.common.service.impl.HibernateDaoImpl.executeWriteCallback(HibernateDaoImpl.java:75)	at com.jaspersoft.jasperserver.api.metadata.common.service.impl.HibernateDaoImpl.executeWriteCallback(HibernateDaoImpl.java:64)	at com.jaspersoft.jasperserver.api.metadata.common.service.impl.hibernate.HibernateRepositoryServiceImpl.saveResource(HibernateRepositoryServiceImpl.java:430)	at sun.reflect.GeneratedMethodAccessor702.invoke(Unknown Source)	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)	at java.lang.reflect.Method.invoke(Method.java:597)	at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:307)	at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182)	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149)	at com.jaspersoft.jasperserver.api.metadata.user.service.impl.PermissionsPrefetcher.invoke(PermissionsPrefetcher.java:78)	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)	at org.springframework.security.intercept.method.aopalliance.MethodSecurityInterceptor.invoke(MethodSecurityInterceptor.java:66)	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)	at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)	at $Proxy15.saveResource(Unknown Source)	at com.jaspersoft.jasperserver.multipleTenancy.PathTransformationRepositoryService.saveResource(PathTransformationRepositoryService.java:483)	at sun.reflect.GeneratedMethodAccessor702.invoke(Unknown Source)	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)	at java.lang.reflect.Method.invoke(Method.java:597)	at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:307)	at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182)	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149)	at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:106)	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)	at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)	at $Proxy15.saveResource(Unknown Source)	at sun.reflect.GeneratedMethodAccessor702.invoke(Unknown Source)	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)	at java.lang.reflect.Method.invoke(Method.java:597)	at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:307)	at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182)	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149)	at com.jaspersoft.ji.adhoc.service.EasyXMLizer.invoke(EasyXMLizer.java:42)	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)	at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)	at $Proxy34.saveResource(Unknown Source)	at com.jaspersoft.ji.adhoc.service.AdhocEngineServiceImpl.saveARU(AdhocEngineServiceImpl.java:946)	at com.jaspersoft.ji.adhoc.action.AdhocAjaxController.saveTemp(AdhocAjaxController.java:523)	at sun.reflect.GeneratedMethodAccessor995.invoke(Unknown Source)	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:187)	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 org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:399)	at com.jaspersoft.jasperserver.api.security.IPadSupportFilter.doFilter(IPadSupportFilter.java:67)	at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:411)	at com.jaspersoft.jasperserver.api.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:411)	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:411)	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:411)	at com.jaspersoft.ji.license.LicenseCheckFilter.doFilter(LicenseCheckFilter.java:108)	at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:411)	at com.jaspersoft.ji.license.JILicenseFilter.doFilter(JILicenseFilter.java:96)	at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:411)	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:411)	at com.jaspersoft.jasperserver.api.metadata.user.service.impl.MetadataAuthenticationProcessingFilter.doFilter(MetadataAuthenticationProcessingFilter.java:139)	at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:411)	at com.jaspersoft.jasperserver.war.util.RequestParameterAuthenticationFilter.doFilter(RequestParameterAuthenticationFilter.java:97)	at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:411)	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:411)	at com.jaspersoft.jasperserver.war.UserPreferencesFilter.doFilter(UserPreferencesFilter.java:184)	at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:411)	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:411)	at com.jaspersoft.jasperserver.war.UserPreferencesFilter.doFilter(UserPreferencesFilter.java:184)	at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:411)	at com.jaspersoft.jasperserver.api.logging.filter.BasicLoggingFilter.doFilter(BasicLoggingFilter.java:53)	at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:411)	at com.jaspersoft.jasperserver.api.security.JSCsrfGuardFilter.doFilter(JSCsrfGuardFilter.java:81)	at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:411)	at com.jaspersoft.jasperserver.api.security.WebAppSecurityFilter.doFilter(WebAppSecurityFilter.java:83)	at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:411)	at com.jaspersoft.jasperserver.war.MultipartRequestWrapperFilter.doFilter(MultipartRequestWrapperFilter.java:90)	at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:411)	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:411)	at org.springframework.security.util.FilterChainProxy.doFilter(FilterChainProxy.java:188)	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)Caused by: java.sql.BatchUpdateException: Batch entry 0 insert into JIResourceFolder (version, uri, hidden, name, label, description, parent_folder, creation_date, update_date, id) values ('0', '/organizations/organization_1/temp/aru1341386426814_files/field_3_1_files', '1', 'field_3_1_files', 'QTY_ON_HAND + QTY_ON_ORDER + QTY_BACK_ORDER + PJ_QTY_BACK_ORDER + MIN_HOLDING_QTY + MAX_HOLDING_QTY is between', NULL, '18722', '2012-07-04 15:29:39.381000 +08:00:00', '2012-07-04 15:29:39.381000 +08:00:00', '18729') was aborted.  Call getNextException to see the cause.	at org.postgresql.jdbc2.AbstractJdbc2Statement$BatchResultHandler.handleError(AbstractJdbc2Statement.java:2598)	at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1836)	at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:407)	at org.postgresql.jdbc2.AbstractJdbc2Statement.executeBatch(AbstractJdbc2Statement.java:2737)	at org.apache.tomcat.dbcp.dbcp.DelegatingStatement.executeBatch(DelegatingStatement.java:297)	at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:70)	at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:268)	... 134 more

[Jasperserver Pro - scheduler to auto default 1st day of the month to last day of the month]

 

Hi All,   Currently we have filter to filter out the invoice date between certain date; we created a scheduler to automatically send the pdf to our email, but the problem is we have to enter the invoice date range.   Is there anyway we can default it automatically everymonth to pull the 1st day of the month to the last day of the month?   Thank you

[Jasperserver Pro - scheduler to auto default 1st day of the month to last day of the month]

 Hi All,

 

Currently we have filter to filter out the invoice date between certain date;

we created a scheduler to automatically send the pdf to our email, but the problem is we have to enter the invoice date range.

 

Is there anyway we can default it automatically everymonth to pull the 1st day of the month to the last day of the month?

 

Thank you

[how to migrate adhoc report from 1 server to another server jasperserver 4.0.1]

Hi,

 

Please help, try to search and google it; but no way to explain how to export adhoc report and import it back to other server.

 

thank you

Sucipto