pokornyjan

Hi, Ho to show calendar vacation (week + day + time (half day))? (Gantt Chart = only Day) Thanks, Jan

Hi, How can change the name of generated with JasperReports pdf file? Thanks, Jan

Hi, how to integrating MS SSAS as OLAP and Jasperserver v.7 ? Thanks, Jan

Hi, I try configure LDAP but show me the error. Product Edition: Enterprise, Features: AUD ANA MT EXP Fusion AHD DB , Product Version: 7.1.1, Build: 20190405_0833, License Type: Commercial, Expiration: None Thank you for your help in advance Jan 2019-08-28 08:16:25,663 ERROR ContextLoader,localhost-startStop-1:331 - Context initialization failedorg.springframework.beans.factory.BeanCreationException: Error creating bean with name 'proxyAuthenticationProcessingFilter' defined in ServletContext resource [/WEB-INF/applicationContext-externalAuth-LDAP-mt.xml]: Cannot resolve reference to bean 'externalAuthSuccessHandler' while setting bean property 'authenticationSuccessHandler'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'externalAuthSuccessHandler' defined in ServletContext resource [/WEB-INF/applicationContext-externalAuth-LDAP-mt.xml]: Cannot resolve reference to bean 'externalDataSynchronizer' while setting bean property 'externalDataSynchronizer'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'externalDataSynchronizer' defined in ServletContext resource [/WEB-INF/applicationContext-externalAuth-LDAP-mt.xml]: Cannot resolve reference to bean 'mtExternalUserSetupProcessor' while setting bean property 'externalUserProcessors' with key [1]; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'mtExternalUserSetupProcessor' defined in ServletContext resource [/WEB-INF/applicationContext-externalAuth-LDAP-mt.xml]: Cannot resolve reference to bean 'ldapUserAttributesUtil' while setting bean property 'ldapUserAttributesUtillist' with key [0]; nested exception is org.springframework.beans.factory.NoSuchBeanDefinitionException: No bean named 'ldapUserAttributesUtil' is defined at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:334) at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:108) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyPropertyValues(AbstractAutowireCapableBeanFactory.java:1419) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1160) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:517) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:456) at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:293) at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:223) at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:290) at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:191) at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:638) at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:942) at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:482) 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:4776) at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5240) at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150) at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:754) at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:730) at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:734) at org.apache.catalina.startup.HostConfig.deployDirectory(HostConfig.java:1140) at org.apache.catalina.startup.HostConfig$DeployDirectory.run(HostConfig.java:1874) 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: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'externalAuthSuccessHandler' defined in ServletContext resource [/WEB-INF/applicationContext-externalAuth-LDAP-mt.xml]: Cannot resolve reference to bean 'externalDataSynchronizer' while setting bean property 'externalDataSynchronizer'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'externalDataSynchronizer' defined in ServletContext resource [/WEB-INF/applicationContext-externalAuth-LDAP-mt.xml]: Cannot resolve reference to bean 'mtExternalUserSetupProcessor' while setting bean property 'externalUserProcessors' with key [1]; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'mtExternalUserSetupProcessor' defined in ServletContext resource [/WEB-INF/applicationContext-externalAuth-LDAP-mt.xml]: Cannot resolve reference to bean 'ldapUserAttributesUtil' while setting bean property 'ldapUserAttributesUtillist' with key [0]; nested exception is org.springframework.beans.factory.NoSuchBeanDefinitionException: No bean named 'ldapUserAttributesUtil' is defined at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:334) at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:108) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyPropertyValues(AbstractAutowireCapableBeanFactory.java:1419) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1160) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:517) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:456) at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:293) at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:223) at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:290) at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:191) at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:328) ... 28 moreCaused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'externalDataSynchronizer' defined in ServletContext resource [/WEB-INF/applicationContext-externalAuth-LDAP-mt.xml]: Cannot resolve reference to bean 'mtExternalUserSetupProcessor' while setting bean property 'externalUserProcessors' with key [1]; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'mtExternalUserSetupProcessor' defined in ServletContext resource [/WEB-INF/applicationContext-externalAuth-LDAP-mt.xml]: Cannot resolve reference to bean 'ldapUserAttributesUtil' while setting bean property 'ldapUserAttributesUtillist' with key [0]; nested exception is org.springframework.beans.factory.NoSuchBeanDefinitionException: No bean named 'ldapUserAttributesUtil' is defined at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:334) at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:108) at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveManagedList(BeanDefinitionValueResolver.java:358) at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:157) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyPropertyValues(AbstractAutowireCapableBeanFactory.java:1419) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1160) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:517) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:456) at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:293) at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:223) at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:290) at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:191) at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:328) ... 38 moreCaused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'mtExternalUserSetupProcessor' defined in ServletContext resource [/WEB-INF/applicationContext-externalAuth-LDAP-mt.xml]: Cannot resolve reference to bean 'ldapUserAttributesUtil' while setting bean property 'ldapUserAttributesUtillist' with key [0]; nested exception is org.springframework.beans.factory.NoSuchBeanDefinitionException: No bean named 'ldapUserAttributesUtil' is defined at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:334) at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:108) at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveManagedList(BeanDefinitionValueResolver.java:358) at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:157) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyPropertyValues(AbstractAutowireCapableBeanFactory.java:1419) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1160) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:517) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:456) at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:293) at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:223) at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:290) at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:191) at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:328) ... 50 moreCaused by: org.springframework.beans.factory.NoSuchBeanDefinitionException: No bean named 'ldapUserAttributesUtil' is defined at org.springframework.beans.factory.support.DefaultListableBeanFactory.getBeanDefinition(DefaultListableBeanFactory.java:577) at org.springframework.beans.factory.support.AbstractBeanFactory.getMergedLocalBeanDefinition(AbstractBeanFactory.java:1111) at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:276) at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:191) at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:328) ... 62 more[/code]

Add second interval to Filter Group

Hi all, How to set parameter (between start_date and end_date) with 2 and more reports? Thanks in advance, Jan

I tried new installation, same problem :-(

I have same problem. After upgrade I used "applicationContext-externalAuth-LDAP.xml" (v.7.2, same configuration). Please help. Thanks in advance, Jan

Hi, I try to upgrade JasperServer Community 7.1 to 7.2. Show me the errors: upgrade-7.1-7.2-ce: [echo] [echo] currentSqlDir = c:/Jaspersoft 7_2/buildomatic/install_resources/sql/postgresql [echo] dbType = postgresql [echo] [echo] run script: c:/Jaspersoft 7_2/buildomatic/install_resources/sql/postgresql/upgrade-postgresql-7.1.0-7.2.0-ce.sql [echo] For JDBC driver the artifactId and version properties are set: [echo] maven.jdbc.artifactId=postgresql [echo] maven.jdbc.version=9.4-1210.jdbc41 [echo] Specified JDBC driver jar exists [advanced-sql] Executing resource: c:Jaspersoft 7_2buildomaticinstall_resourcessqlpostgresqlupgrade-postgresql-7.1.0-7.2.0-ce.sql [advanced-sql] Failed to execute: ALTER TABLE qrtz_fired_triggers ADD COLUMN sched_time BIGINT [advanced-sql] org.postgresql.util.PSQLException: ERROR: must be owner of relation qrtz_fired_triggers [advanced-sql] Failed to execute: UPDATE qrtz_fired_triggers SET sched_time = fired_time [advanced-sql] org.postgresql.util.PSQLException: ERROR: column "sched_time" of relation "qrtz_fired_triggers" does not exist [advanced-sql] Position: 33 [advanced-sql] Failed to execute: ALTER TABLE qrtz_fired_triggers ALTER COLUMN sched_time SET NOT NULL [advanced-sql] org.postgresql.util.PSQLException: ERROR: must be owner of relation qrtz_fired_triggers [advanced-sql] 0 of 3 SQL statements executed successfully and deploy-jdbc-jar: [echo] Copy JDBC drivers to the app-server [echo] First copy jars [echo] FROM the conf_source/db/app-srv-jdbc-drivers folder [echo] TO the folder C:/Jaspersoft/jasperreports-server-cp-6.4.0/apache-tomcat/lib [copy] Copying 1 file to C:Jaspersoftjasperreports-server-cp-6.4.0apache-tomcatlib Attempt to copy c:Jaspersoft 7_2buildomaticconf_sourcedbapp-srv-jdbc-driverspostgresql-9.4-1210.jdbc41.jar to C:Jaspersoftjasperreports-server-cp-6.4.0apache-tomcatlibpostgresql-9.4-1210.jdbc41.jar using NIO Channels failed due to 'C:Jaspersoftjasperreports-server-cp-6.4.0apache-tomcatlibpostgresql-9.4-1210.jdbc41.jar (Access is denied)'. Falling back to streams. BUILD FAILED c:Jaspersoft 7_2buildomaticbinapp-server.xml:1034: Failed to copy c:Jaspersoft 7_2buildomaticconf_sourcedbapp-srv-jdbc-driverspostgresql-9.4-1210.jdbc41.jar to C:Jaspersoftjasperreports-server-cp-6.4.0apache-tomcatlibpostgresql-9.4-1210.jdbc41.jar due to java.io.FileNotFoundException C:Jaspersoftjasperreports-server-cp-6.4.0apache-tomcatlibpostgresql-9.4-1210.jdbc41.jar (Access is denied) and I couldn't delete the corrupt C:Jaspersoftjasperreports-server-cp-6.4.0apache-tomcatlibpostgresql-9.4-1210.jdbc41.jar Can You help me? Jan

Hi, I use HTML5 Chart (Line) in report. I show seconds on Y Axis and on datalabels. How to convert seconds to "hh:mm:ss" and show on datalabels? Thanks in advance, Jan

Hi, I would like to ask you How to create report: - with group; - chart and next to tables. Can I create this report ?

Similar problem is with ReportBook. How to passing values to report "Detail" (in "Content")? Report "Detail" has Table ("Basic Components" ). When I create table as fields, passing is OK. Single value is OK.

Hi Ale42, thank you for your answer. How configure (how passing id from main report to subreport?)? Main Report: <?xml version="1.0" encoding="UTF-8"?> <!-- Created with Jaspersoft Studio version 7.2.1.final using JasperReports Library version 6.6.0 --> <jasperReport xmlns="http://jasperreports.sourceforge.net/jasperreports" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://jasperreports.sourceforge.net/jasperreports http://jasperreports.sourceforge.net/xsd/jasperreport.xsd" name="Test_parameter_id" pageWidth="595" pageHeight="842" columnWidth="555" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20" uuid="6d480b82-0505-4eed-adb6-b09c4618ab87"> <property name="com.jaspersoft.studio.data.sql.tables" value=""/> <property name="com.jaspersoft.studio.data.defaultdataadapter" value="SDM SQL"/> <queryString language="SQL"> <![CDATA[select id, ref_num from call_req where id in (441673, 441674)]]> </queryString> <field name="id" class="java.lang.Integer"> <property name="com.jaspersoft.studio.field.label" value="id"/> </field> <field name="ref_num" class="java.lang.String"> <property name="com.jaspersoft.studio.field.label" value="ref_num"/> </field> <variable name="Variable_1" class="java.util.ArrayList" calculation="System"> <variableExpression><![CDATA[$F{id}]]></variableExpression> <initialValueExpression><![CDATA[new ArrayList()]]></initialValueExpression> </variable> <background> <band splitType="Stretch"/> </background> <summary> <band height="31"> <subreport> <reportElement x="0" y="5" width="528" height="25" uuid="aa870034-2312-4e13-b997-6e7216c55246"/> <subreportParameter name="id"> <subreportParameterExpression><![CDATA[$V{Variable_1}]]></subreportParameterExpression> </subreportParameter> <connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression> <subreportExpression><![CDATA["Blank_A4.jasper"]]></subreportExpression> </subreport> </band> </summary> </jasperReport> Subreport: <?xml version="1.0" encoding="UTF-8"?> <!-- Created with Jaspersoft Studio version 7.2.1.final using JasperReports Library version 6.6.0 --> <jasperReport xmlns="http://jasperreports.sourceforge.net/jasperreports" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://jasperreports.sourceforge.net/jasperreports http://jasperreports.sourceforge.net/xsd/jasperreport.xsd" name="Blank_A4" pageWidth="595" pageHeight="842" columnWidth="555" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20" uuid="a3dc58dc-90e6-4e2e-9457-d0434143dd60"> <parameter name="id" class="java.util.ArrayList"/> <queryString language="SQL"> <![CDATA[select id, ref_num from call_req where $X{IN, id, id}]]> </queryString> <field name="id" class="java.lang.Integer"> <property name="com.jaspersoft.studio.field.label" value="id"/> </field> <field name="ref_num" class="java.lang.String"> <property name="com.jaspersoft.studio.field.label" value="ref_num"/> </field> <background> <band splitType="Stretch"/> </background> <pageHeader> <band height="50"> <textField> <reportElement x="142" y="16" width="100" height="30" uuid="9f8dceef-077c-4048-8de6-4e3330b039a8"/> <textFieldExpression><![CDATA[$P{id}]]></textFieldExpression> </textField> </band> </pageHeader> <detail> <band height="75" splitType="Stretch"> <textField> <reportElement x="20" y="40" width="100" height="30" uuid="4532c2b0-a210-4b72-89ea-69b33f5587bf"/> <textFieldExpression><![CDATA[$F{id}]]></textFieldExpression> </textField> <staticText> <reportElement x="20" y="10" width="100" height="30" uuid="a461cf14-cd5f-4cea-bac6-d1e15cb06df0"/> <text><![CDATA[id]]></text> </staticText> <textField> <reportElement x="120" y="40" width="100" height="30" uuid="6939f996-37b8-4741-9299-021d03a28aa4"/> <textFieldExpression><![CDATA[$F{ref_num}]]></textFieldExpression> </textField> <staticText> <reportElement x="120" y="10" width="100" height="30" uuid="ce3e2ec3-c11b-4c3a-937b-d3ae6bdc06f6"/> <text><![CDATA[ref_num]]></text> </staticText> </band> </detail> </jasperReport>

When - the main query select only one value - set java.lang.Integer in the Content report parameter - set EQUAL in the Content report Query report is OK. When - the main query select more values - set java.util.Collection in the Content report parameter - set IN in the Content report Query Caused by: java.lang.ClassCastException: java.lang.Integer cannot be cast to java.util.Collection

Hi, I have "report book" - main query (Select id (Int) from cr) and I woud like pass "id" to the Content report - query (Select name from alg where $X{IN, alg.CR_ID, id}). How configure report? Thanks for any help.