trvpseudo

Hi All, please help i have jasperreport -pro 6.2.1 with profesional edition, https://www.jaspersoft.com/editions says profesional edition has add-on to enable audit feature. anyone know how to enable it? thanks in advance! regards, TV

try to count it, if result is same then its a matter of the data's order

Hi All, so i will migrate my jasperserver 6.2.1 from windows to linux. it is bundled jasperreport in the form of .exe for windows as well as i already get the .run for linux. i know i can export the windows configuration and import it after i install the linux version. the problem is, i have my windows version LDAP password encrypted in buildomatic. and to get it in the linux version will take a whole long procedure in my company. how to make the linux version have the same configuration like windows? for example : is it possible jst to replace the buildomatic and its done (i know that wont do since jasper generate the d/encryoption key randomly anywhere) any suggestion helps! thank you in advance Regards, TV

seems desperate after exploring through everything i guess? same buddy.. same XD

restart the service might release the memory maybe? theres a report that couldnt be generate and will take up your memory everytime u try to load it. the characteristic is the report wont load. in my case the cause is when the report try to load the template size / width of a box and is failing. the report wait to be load but the template never be ready. so i need to restart the service and make another report with another element. things be fine afterthat.

did you put it in detail band? if so try to put the table in the summary band.

closing this since i can setup for encrypted LDAP already XD please refer to https://community.jaspersoft.com/questions/1141656/encrypted-ldap-password regards, TV

If you somehow experience the same problem, here are steps i did from the start : 1. isntall jasperreport server (mine is 6.2.1 windows) 2. setup your LDAP path and uid in the xml, then put it in web-inf :: https://community.jaspersoft.com/documentation/tibco-jasperreports-server-authentication-cookbook/v601/setting-ldap-connection 3. input your plain text LDAP password in buildomaticdefault_master.properties, add "encrypt=true" and "propsToEncrypt=external.ldap.password" :: https://community.jaspersoft.com/documentation/tibco-jasperreports-server-security-guide/v62/encrypting-passwords-configuration-files 4. save file and open cmd, cd to buildomatic (or type cmd in buildomatic) 5. execute "js-ant refresh-config" 6. copy encrypted password in "default_master.properties" and paste it in "web-infjs.externalAuth.properties" 7. restart the application maybe following the steps cause : 1. "default_master.properties" cant be opened : use your pc admin user to open it or make a copy of it and delete the old one, then rename it to be the same as the one you delete. 2. "js-ant refresh-config" build failed : delete build_confdefault manually, then execute again 3. "js.externalAuth.properties" cant be opened : make a copy of it and delete the old one, then rename it to be the same as the one you delete. if you get error keystore init : 1. open "apache-tomcatbin" 2. run as admin "jasperreportTomcatw.exe" (or similar to it with, notice the "w") 3. open java tab and add your users :: https://community.jaspersoft.com/documentation/tibco-jasperreports-server-security-guide/v62/encrypting-passwords-configuration-files 4. restart jasper again it works for me after weeks of exploring and experiment and reinstall the app hopefully this will be complete guide for you and save you maany many hours :D regards, TV

Hi All, so i need to encrypt my LDAP password. i follow this https://community.jaspersoft.com/documentation/tibco-jasperreports-server-security-guide/v720/encrypting-passwords-configuration step i did : 1. install jasperreport 2. add modified ldap-mt.xml 3. edit default_master.properties, add LDAP url, dn and password 4. add encrypted=true to the file 5. run 'js-install minimal' (i dnt want sample files) 6. stop service and start again then i got error in log 2019-08-13 13:17:18,873 ERROR ContextLoader,localhost-startStop-2:331 - Context initialization failed org.springframework.beans.factory.BeanDefinitionStoreException: Invalid bean definition with name 'ldapContextSource' defined in ServletContext resource [/WEB-INF/applicationContext-externalAuth-LDAP-mt.xml]: Could not resolve placeholder 'external.ldapDn' in string value "${external.ldapDn}"; nested exception is java.lang.IllegalArgumentException: Could not resolve placeholder 'external.ldapDn' in string value "${external.ldapDn}" at org.springframework.beans.factory.config.PlaceholderConfigurerSupport.doProcessProperties(PlaceholderConfigurerSupport.java:209) at org.springframework.beans.factory.config.PropertyPlaceholderConfigurer.processProperties(PropertyPlaceholderConfigurer.java:223) at org.springframework.beans.factory.config.PropertyResourceConfigurer.postProcessBeanFactory(PropertyResourceConfigurer.java:84) at org.springframework.context.support.AbstractApplicationContext.invokeBeanFactoryPostProcessors(AbstractApplicationContext.java:696) at org.springframework.context.support.AbstractApplicationContext.invokeBeanFactoryPostProcessors(AbstractApplicationContext.java:671) at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:461) at org.springframework.web.context.ContextLoader.configureAndRefreshWebApplicationContext(ContextLoader.java:410) at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:306) at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:112) at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4797) at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5221) at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150) at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:724) at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:700) at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:714) at org.apache.catalina.startup.HostConfig.deployDirectory(HostConfig.java:1071) at org.apache.catalina.startup.HostConfig$DeployDirectory.run(HostConfig.java:1721) at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source) at java.util.concurrent.FutureTask.run(Unknown Source) at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) at java.lang.Thread.run(Unknown Source) Caused by: java.lang.IllegalArgumentException: Could not resolve placeholder 'external.ldapDn' in string value "${external.ldapDn}" at org.springframework.util.PropertyPlaceholderHelper.parseStringValue(PropertyPlaceholderHelper.java:173) at org.springframework.util.PropertyPlaceholderHelper.parseStringValue(PropertyPlaceholderHelper.java:161) at org.springframework.util.PropertyPlaceholderHelper.replacePlaceholders(PropertyPlaceholderHelper.java:125) at org.springframework.beans.factory.config.PropertyPlaceholderConfigurer$PlaceholderResolvingStringValueResolver.resolveStringValue(PropertyPlaceholderConfigurer.java:258) at org.springframework.beans.factory.config.BeanDefinitionVisitor.resolveStringValue(BeanDefinitionVisitor.java:282) at org.springframework.beans.factory.config.BeanDefinitionVisitor.resolveValue(BeanDefinitionVisitor.java:204) at org.springframework.beans.factory.config.BeanDefinitionVisitor.visitPropertyValues(BeanDefinitionVisitor.java:141) at org.springframework.beans.factory.config.BeanDefinitionVisitor.visitBeanDefinition(BeanDefinitionVisitor.java:82) at org.springframework.beans.factory.config.PlaceholderConfigurerSupport.doProcessProperties(PlaceholderConfigurerSupport.java:206) ... 21 more tried to move password and other ldap setting to 'js.externalAuth.properties' from 'default_master.properties' then this error show up 2019-08-13 17:22:15,425 ERROR ContextLoader,localhost-startStop-2:331 - Context initialization failed java.lang.RuntimeException: KeystoreManager.init was never called or there are errors instantiating an instance. at com.jaspersoft.jasperserver.crypto.KeystoreManager.getInstance(KeystoreManager.java:186) at com.jaspersoft.jasperserver.api.common.properties.DecryptingPropertyPlaceholderConfigurer.convertPropertyValue(DecryptingPropertyPlaceholderConfigurer.java:65) at org.springframework.beans.factory.config.PropertyResourceConfigurer.convertProperty(PropertyResourceConfigurer.java:121) at org.springframework.beans.factory.config.PropertyResourceConfigurer.convertProperties(PropertyResourceConfigurer.java:104) at com.jaspersoft.jasperserver.api.common.properties.DecryptingPropertyPlaceholderConfigurer.convertProperties(DecryptingPropertyPlaceholderConfigurer.java:38) at org.springframework.beans.factory.config.PropertyResourceConfigurer.postProcessBeanFactory(PropertyResourceConfigurer.java:81) at org.springframework.context.support.AbstractApplicationContext.invokeBeanFactoryPostProcessors(AbstractApplicationContext.java:696) at org.springframework.context.support.AbstractApplicationContext.invokeBeanFactoryPostProcessors(AbstractApplicationContext.java:671) at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:461) at org.springframework.web.context.ContextLoader.configureAndRefreshWebApplicationContext(ContextLoader.java:410) at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:306) at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:112) at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4797) at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5221) at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150) at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:724) at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:700) at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:714) at org.apache.catalina.startup.HostConfig.deployDirectory(HostConfig.java:1071) at org.apache.catalina.startup.HostConfig$DeployDirectory.run(HostConfig.java:1721) at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source) at java.util.concurrent.FutureTask.run(Unknown Source) at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) at java.lang.Thread.run(Unknown Source) tried to edit the start service to add -Duser.home=c:Users<TomcatUser>but cant add it in the service properties not smooth as the documentation says, pls anyone have any idea to fix this? info : -using windows 10 -jasperserver-pro 6.2.1 -installer bundled with tomcat etc regards, TV

Hi, Can we apply our own login authentication? intend to create our own login class then use it for jasperreport. info : jasperserver-pro 6.2.1 Thanks! TV

perhaps more detail? as far as i know you can connect the same DB SAP Hana use to jasperstudio, use it to query the data you need then make a custom report out of it. have not tried to make a report from jasperstudio without exporting it tho. hope that helps, cheers! TV

you can use table in basic element. in the table style setup, remove all header and footer (if u dont need it). you can differ the odd row color by checking "use alternated detail rows background" this one help me when i havent found the table element https://community.jaspersoft.com/questions/542320/different-colour-alternate-rows hope that helps, cheers! TV

please help. how to remove create button (not mutton) for report and dashboard in jasperreport 6.2.1, will be better if using the same method for other menu as well. (cant attach image here?) user only have view list option and cant create anything no matter how. thanks in advance! DS