[Calendar]

Hi, 

Ho to show calendar vacation (week + day + time (half day))?

(Gantt Chart = only Day)

Thanks,

Jan

[How to change pdf file name dynamically (Export)]

Hi,

How can change the name of generated with JasperReports pdf file?

Thanks,

Jan

[Using MS SSAS as OLAP View in Jasperserver v.7]

Hi,

how to integrating MS SSAS as OLAP and Jasperserver v.7 ?

Thanks,

Jan

[Jasper and LDAP]

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]

 

[Dashboard and filter Date between]

Add second interval to Filter Group

[Dashboard and filter Date between]

Hi all,

How to set parameter (between start_date and end_date) with 2 and more reports?

Thanks in advance,

Jan

[JasperReports LDAP setting issue after upgrade 7.1 to 7.2]

I tried new installation, same problem :-(

[JasperReports LDAP setting issue after upgrade 7.1 to 7.2]

I have same problem. After upgrade I used "applicationContext-externalAuth-LDAP.xml" (v.7.2, same configuration).

Please help. 

Thanks in advance, 

Jan

 

[JasperServer Community Upgrade 7.1 to 7.2]

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

 

[Html5 Chart Show Time]

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

[Grouping table and chart]

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

Can I create this report ?

[How to send values from main report to other 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.

[How to send values from main report to other report?]

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>
 

 

 

[How to send values from main report to other report?]

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

[How to send values from main report to other report?]

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.
 

[Domain Designer]

Hi all,

I need to convert "Integer to Timestamp" in the Domain Designer.

How to configuration Expression?

Thanks

Jan

 

[Auto refresh (Confirmed on version 4.7 Community)]

I found the solution, Thanks all

[Auto refresh (Confirmed on version 4.7 Community)]

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

[Parameter Default Value Expresion]

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

 

[Auto refresh (Confirmed on version 4.7 Community)]

Did you try It with version 6.3?

I added button but refresh refresh does not work.

Thank you for help

Jan

[Null values - parameters, input controls]

I use parameter parameters ($X{In, column, parameter})

How to change "column value"? (null -> 0)

Thanks in advance for your help.

[How to change view format]

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 

[How to change view format]

Hi all,

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

Thanks

Jan

[Null values - parameters, input controls]

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.

[Null values - parameters, input controls]

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