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.

Hi all, I need to convert "Integer to Timestamp" in the Domain Designer. How to configuration Expression? Thanks Jan

I found the solution, Thanks all

Hi omer.etrog, your code is working. (works permanently and over all reports). How do I set the code for only one report? Thank you for help Jan

Hi all, I use "( $P{cal}.set($P{runDate}.getYear()+1900, $P{runDate}.getMonth(), $P{runDate}.getDate()) || $P{cal}.add(Calendar.MONTH, -1) || $P{cal}.set(Calendar.DAY_OF_MONTH, 1) ) ? null : $P{cal}.getTime()" in Parameter - Default Value Expression. Jasper Studio is OK, parameter shows value "5/1/18 11:35:48 AM" Jasper Server show error "Specify a valid value for type Timestamp." Input Controls show value "2018-05-01" without time? Thank you very much in advance, Jan

Did you try It with version 6.3? I added button but refresh refresh does not work. Thank you for help Jan

I use parameter parameters ($X{In, column, parameter}) How to change "column value"? (null -> 0) Thanks in advance for your help.

Hi hozawa, 1) in Jasper Studio I set Java (format view), report is show correctly (with border, alignment) 2) I publish report to jasperserver 3) in Jasper Server, Report is show incorrectly (without border, alignment, . . . ) "There's an "Export" pull down to choose different formats." How to set default "format view" in JasperServer? Thanks in advance, Jan

Hi all, how to change "view format" from HTML to others (Java, PDF, . . . ) in Jasper Server? Thanks Jan

Hi mlopez_1, thank you for your reply. I changed set Class Parameter from java.util.Collection to java.util.List but still doesnt work. (Value "1" or "0" are OK.) Thanks in advance for your help.

Hi, how to configure "Input controls, parameters ($X{In, column, parameter})" when - Parameters has values (0,1) - Column has values "null,0,1" (Null=0) Thanks Jan