[Open JRXML from JS gives "nested exception"]

I think I have found what is wrong.

Now it works since I have upgraded tomcat 5 to tomcat 6.

With JasperServer 3.7.1 and iReport 3.7.5, it works fine.

Please tell me  if it's ok for you after upgrading tomcat.

 

Regards,

--

Laurent.

 

 

[iReport and JasperServer via SSL]

Hi Tom,

You have to migrate from JasperServer 3.7.0 to JasperServer 3.7.1 (i'm not sure)

But I'm sure you have to migrate iReport 3.7.1 to iReport 3.7.5

I have the same configuration,

when I use direct link : https://myserver:8443/jasperserver/services/repository/, it works (iReport tells me to accept an auto-signed certificate which I have previously generated)

but if I use

"http://myserver:8080/jasperserver/services/repository"

I have this error : Error: (302)Moved Temporarily (the redirection seems to be not understood by iReport)

 

Regards,

--

Laurent.

 

[Mix average / count calculation in crosstabs]

Hi everybody,

I have a simple cross tab, which you just have an example below,

the measure is of type "count" (it shows the count of number of failure by month)

/uploads/projects/ireport/cross_count.png

As you can see, the last line is the "total".

But I'd like to have the "average" instead of "total". I'd just like the last line to be the average of the upper lines (average by month).

Do you think it is possible ? I'm not sure ?

Thanks for help !

 

--

Laurent.

[Open JRXML from JS gives "nested exception"]

Any idea ? I think the problem is well-known ?

 

Please help !

 

Thanks,

[js-import failed with SQLGrammarException]

Ok that's ok now with this parameter

metadata.hibernate.dialect=com.jaspersoft.hibernate.dialect.PostgresqlNoBlobDialect

instead of

metadata.hibernate.dialect=org.hibernate.dialect.PostgresqlDialect

 

That's all Folks !!

Post Edited by ldevigne at 06/11/2010 14:57

[js-import failed with SQLGrammarException]

I'm using JasperServer 3.7.1 with a Postgres 8.2 database.

I tryed to import a simple "Report Unit" with a single paramter (which I beforehand successfully exported)

So I use this script :

./js-import.sh --input-dir /tmp/LDE/try/

This directory contains

resources/datasources/datasource.xml

resources/datatypes/id.xml (input contrrol) based on resources/datatypes/integer.xml (datatype)

resources/reports/try/simple_try.xml and resources/reports/simple_try_files

 

When I import, the datasource and datatypes are stored onto JasperServer database, no problem !

But there is a problem with the importation of the report.

Here are the logs, it seems to be a problem with the "data" colum of JIFileResource, which is of type "bytea" and I think the JRXML file is not converted or something like that in this Postgres table.

Please Help,

 

Here is the output errors :

 

Created repository folder /reports/try
Imported resource /datasources/datasource
Imported resource /datatypes/Integer
Imported resource /datatypes/id
2010-06-11 11:07:59,091  WARN JDBCExceptionReporter:100 - SQL Error: 0, SQLState: 42804
2010-06-11 11:07:59,095 ERROR JDBCExceptionReporter:101 - ERREUR: la colonne « data » est de type bytea mais l'expression est de type integer
2010-06-11 11:07:59,097 ERROR AbstractFlushingEventListener:325 - Could not synchronize database state with session
org.hibernate.exception.SQLGrammarException: could not insert: [com.jaspersoft.jasperserver.api.metadata.common.service.impl.hibernate.persistent.RepoFileResource]
        at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:90)
        at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
        at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2285)
        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:424)
        at com.jaspersoft.jasperserver.api.metadata.common.service.impl.hibernate.HibernateRepositoryServiceImpl.saveResource(HibernateRepositoryServiceImpl.java:417)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
        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 $Proxy1.saveResource(Unknown Source)
        at com.jaspersoft.jasperserver.export.modules.repository.ResourceImporter.importResource(ResourceImporter.java:352)
        at com.jaspersoft.jasperserver.export.modules.repository.ResourceImporter.process(ResourceImporter.java:124)
        at com.jaspersoft.jasperserver.export.ImporterImpl.process(ImporterImpl.java:146)
        at com.jaspersoft.jasperserver.export.ImporterImpl.performImport(ImporterImpl.java:95)
        at com.jaspersoft.jasperserver.export.ImportCommandImpl.process(ImportCommandImpl.java:57)
        at com.jaspersoft.jasperserver.export.BaseExportImportCommand.process(BaseExportImportCommand.java:87)
        at com.jaspersoft.jasperserver.export.ImportCommand.main(ImportCommand.java:43)
Caused by: org.postgresql.util.PSQLException: ERREUR: la colonne « data » est de type bytea mais l'expression est de type integer
        at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1525)
        at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1309)
        at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:188)
        at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:452)
        at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:354)
        at org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:308)
        at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:101)
        at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2268)
        ... 34 more
2010-06-11 11:07:59,098 ERROR HibernateDaoImpl:79 - Hibernate DataAccessException
org.springframework.dao.InvalidDataAccessResourceUsageException: could not insert: [com.jaspersoft.jasperserver.api.metadata.common.service.impl.hibernate.persistent.RepoFileResource]; nested exception is org.hibernate.exception.SQLGrammarException: could not insert: [com.jaspersoft.jasperserver.api.metadata.common.service.impl.hibernate.persistent.RepoFileResource]
        at org.springframework.orm.hibernate3.SessionFactoryUtils.convertHibernateAccessException(SessionFactoryUtils.java:630)
        at org.springframework.orm.hibernate3.HibernateAccessor.convertHibernateAccessException(HibernateAccessor.java:412)
        at org.springframework.orm.hibernate3.HibernateTemplate.doExecute(HibernateTemplate.java:424)
        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:424)
        at com.jaspersoft.jasperserver.api.metadata.common.service.impl.hibernate.HibernateRepositoryServiceImpl.saveResource(HibernateRepositoryServiceImpl.java:417)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
        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 $Proxy1.saveResource(Unknown Source)
        at com.jaspersoft.jasperserver.export.modules.repository.ResourceImporter.importResource(ResourceImporter.java:352)
        at com.jaspersoft.jasperserver.export.modules.repository.ResourceImporter.process(ResourceImporter.java:124)
        at com.jaspersoft.jasperserver.export.ImporterImpl.process(ImporterImpl.java:146)
        at com.jaspersoft.jasperserver.export.ImporterImpl.performImport(ImporterImpl.java:95)
        at com.jaspersoft.jasperserver.export.ImportCommandImpl.process(ImportCommandImpl.java:57)
        at com.jaspersoft.jasperserver.export.BaseExportImportCommand.process(BaseExportImportCommand.java:87)
        at com.jaspersoft.jasperserver.export.ImportCommand.main(ImportCommand.java:43)
Caused by: org.hibernate.exception.SQLGrammarException: could not insert: [com.jaspersoft.jasperserver.api.metadata.common.service.impl.hibernate.persistent.RepoFileResource]
        at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:90)
        at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
        at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2285)
        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)
        ... 24 more
Caused by: org.postgresql.util.PSQLException: ERREUR: la colonne « data » est de type bytea mais l'expression est de type integer
        at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1525)
        at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1309)
        at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:188)
        at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:452)
        at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:354)
        at org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:308)
        at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:101)
        at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2268)
        ... 34 more
2010-06-11 11:07:59,145 ERROR BaseExportImportCommand:45 - com.jaspersoft.jasperserver.api.JSExceptionWrapper: could not insert: [com.jaspersoft.jasperserver.api.metadata.common.service.impl.hibernate.persistent.RepoFileResource]; nested exception is org.hibernate.exception.SQLGrammarException: could not insert: [com.jaspersoft.jasperserver.api.metadata.common.service.impl.hibernate.persistent.RepoFileResource]
com.jaspersoft.jasperserver.api.JSExceptionWrapper: org.springframework.dao.InvalidDataAccessResourceUsageException: could not insert: [com.jaspersoft.jasperserver.api.metadata.common.service.impl.hibernate.persistent.RepoFileResource]; nested exception is org.hibernate.exception.SQLGrammarException: could not insert: [com.jaspersoft.jasperserver.api.metadata.common.service.impl.hibernate.persistent.RepoFileResource]
        at org.springframework.orm.hibernate3.SessionFactoryUtils.convertHibernateAccessException(SessionFactoryUtils.java:630)
        at org.springframework.orm.hibernate3.HibernateAccessor.convertHibernateAccessException(HibernateAccessor.java:412)
        at org.springframework.orm.hibernate3.HibernateTemplate.doExecute(HibernateTemplate.java:424)
        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:424)
        at com.jaspersoft.jasperserver.api.metadata.common.service.impl.hibernate.HibernateRepositoryServiceImpl.saveResource(HibernateRepositoryServiceImpl.java:417)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
        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 $Proxy1.saveResource(Unknown Source)
        at com.jaspersoft.jasperserver.export.modules.repository.ResourceImporter.importResource(ResourceImporter.java:352)
        at com.jaspersoft.jasperserver.export.modules.repository.ResourceImporter.process(ResourceImporter.java:124)
        at com.jaspersoft.jasperserver.export.ImporterImpl.process(ImporterImpl.java:146)
        at com.jaspersoft.jasperserver.export.ImporterImpl.performImport(ImporterImpl.java:95)
        at com.jaspersoft.jasperserver.export.ImportCommandImpl.process(ImportCommandImpl.java:57)
        at com.jaspersoft.jasperserver.export.BaseExportImportCommand.process(BaseExportImportCommand.java:87)
        at com.jaspersoft.jasperserver.export.ImportCommand.main(ImportCommand.java:43)
Caused by: org.hibernate.exception.SQLGrammarException: could not insert: [com.jaspersoft.jasperserver.api.metadata.common.service.impl.hibernate.persistent.RepoFileResource]
        at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:90)
        at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
        at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2285)
        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)
        ... 24 more
Caused by: org.postgresql.util.PSQLException: ERREUR: la colonne « data » est de type bytea mais l'expression est de type integer
        at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1525)
        at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1309)
        at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:188)
        at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:452)
        at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:354)
        at org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:308)
        at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:101)
        at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2268)
 

Post Edited by ldevigne at 06/11/2010 14:59

Post Edited by ldevigne at 06/11/2010 15:00

[Crosstab Cell Rotation does not work]

No idea ?

[Open JRXML from JS gives "nested exception"]

Any idea ?

It would help so much...

[Summary band too small]

I have many crosstabs and information to display in my summary band

With "Page break", I manage the display of many crosstabs of which I can reduce the height in the designer.

But I can't do this with the charts

I have change the "Page Height" master paramter, so I can grow my Summary band height, but it's not good when I want to print the report (a lot of bank page)

Any idea to workaround this problem ?

 

Thanks a lot !

A screenshot of the design :

 

 

 

[Crosstab Cell Rotation does not work]

It's just a simple problem but disturbing in the look and feel of my reports

So I designed a report in iReport with crosstabs with cell rotation just like this :

 /uploads/projects/jasperserver/crosstab(1).png

But when I upload the report onto JasperServer, the result is :

/uploads/projects/jasperserver/crosstab1(2).png

Any idea about this problem which seems to be "minor" ?

 

Thanks,

Post Edited by ldevigne at 06/04/2010 08:17

[I want to "grey" an input control]

Hi everybody,

I have 2 input controls in my JS report.

The first one "param1" is a boolean. I'd like to "deactiavte" the second parameter (becomes grey for example), if param1 is true

 

Is it possible ?

In fact, the second parameter is optionnal and has sense only if param1 is false.

 

Thanks for help !

 

--

Laurent.

[Open JRXML from JS gives "nested exception"]

Any idea ?

It's really disturbing me.

Post Edited by ldevigne at 05/28/2010 08:23

[Bad Value Type from Main Report in Crosstab]

Any idea ?

[Dynamic calculation of dates from a date range?]

When I had to manipulate dates in iReport, I used the scriptlet class to write some Java functions, which I called in derived parameters...

[Open JRXML from JS gives "nested exception"]

Hi everybody,

I'd like to open my templates from JasperServer in iReport with the context menu "Open in Editor", but everytime I get a Java Exeption

/uploads/projects/ireport/exception.png

So after reading this post,

http://jasperforge.org/plugins/espforum/view.php?group_id=83&forumid=101&topicid=55948

I confirm that I do  use a Sun JDK on both the sides (iReport and JasperServer)

The releases are : iReport 3.7.1 and JasperServer 3.7.0 and Sun JDK 1.6.0_16

 

I had a look to "catalina.out" log file and there seems to be a problem with the RU which is null :

 

2010-05-25 17:11:56,423  WARN LoggerListener,http-8080-Processor18:60 - Authentication event AuthenticationSuccessEvent: jasperadmin; details: org.springframework.security.ui.WebAuthenticationDetails@0: RemoteIpAddress: 172.25.250.128; SessionId: 68A65DF99BC9216F52E078DA79B68057
2010-05-25 17:11:56,426  WARN ManagementService,http-8080-Processor18:805 - Loading uri: /reports/Vigilo/vigilo_dispo_hote
2010-05-25 17:11:56,471  WARN ManagementService,http-8080-Processor18:813 - Loaded RU null
2010-05-25 17:11:56,486  WARN ManagementService,http-8080-Processor18:820 - Loaded resource /reports/Vigilo/vigilo_dispo_hote_files/vigilo_dispo_hote_jrxml com.jaspersoft.jasperserver.api.metadata.common.domain.client.FileResourceImpl@1c436fe

 

Thanks so much for you help
 

Post Edited by ldevigne at 05/25/2010 15:02

[Bad Value Type from Main Report in Crosstab]

Hi Everybody,

I just have a simple problem in my "Ireport 3.7.1" Report designer.

I want to hyperlink a cell of my crosstab with a parameter (Integer) called "Param1" from the Main Report.

This will allow to launch a new report from the value of my cell with this parameter.

To do so (after reading many tutorials), I have put in the field "Parameters Map Expression" of my crosstab the value :

new HashMap($P{REPORT_PARAMETERS_MAP})

 

This allows to create a Link Parameter in the HyperLink option and to get the value of "Param1" with this expression :

$P{REPORT_PARAMETERS_MAP}.get("Param1") and it works fine.

I specify this Link Parameter as an Integer.

The problem is in fact that iReport (after report generation) will transform automatically the type of the link parameter as a String

I think it is a bug ?

Thanks for your help

Post Edited by ldevigne at 05/21/2010 16:04

[Bad URL in the drill down hyperlink (localhost)]

Il works fine,

 

Thanks a lot !

 

../../../themes/jasper/images//tools/forum/smile.gif

[Bad URL in the drill down hyperlink (localhost)]

Any one has an idea ?

Thanks.

[Bad URL in the drill down hyperlink (localhost)]

Hi,

when I export my report in HTML, the drill-down URL on my charts starts with "localhost:8080/...."

I wish I had "server1:8080/..." as the master report is on JasperServer with this URL.

localhost is my laptop and JasperServer is installed on "server1"

 

With JasperViewer, the URLs are OK !

 

Any Idea ? Is it about Tomcat configuration ? or JasperServer Parameter ?

Thanks,

 

--

Laurent.

Post Edited by ldevigne at 05/11/2010 15:56

Post Edited by ldevigne at 05/17/2010 14:24