[Concatenation with formatting]

Could the answer be as easy as this:

 "(+/- $" + $P{LCF} + (" Fut ~ +/- $") + $P{LCO} + " Opt)"

 

David

[No Disk Space Left Running JS-EXPORT]

Greetings,

 

Has anyone had the issue of running a js-export with the "everything" option and having it fail on a JAVA exception "No disk space left on Drive" even though there is plenty of space.  This is the first time this has happened and I'm totally confused.  My backup is usually only 10GB or so and I have 35GB left on the disk.  This is a Linux Centos bos.

Any ideas?

 

David

 

[Ireport 4.5.1 compatibility question...]

Currently running JasperReports Server 4.0.1...

Can I use Ireport 4.5.1 with this server version?

 

David in Ohio

[Cannot Export Reports to any Type]

This error came out of the blue!  When I try to export any report to PDF, XLS--all formats--I get an Apache 404 error that the requested resource is not available.  I'm on JasperReports Server 4.01.

 

Anyone have an idea why I'm getting this error?

 

David

[Help with Java Error]

(Bump)

[Help with Java Error]

Folks,

Several weeks ago, the power in our building went down and took the Jasper server 4.1 down as well.  The logs for MySQL indicated that the tables were repaired okay.  I didn't shutdown the server until today and now suddenly, I get this very large error:

 

2012-03-09 15:14:41,286 ERROR HibernateDaoImpl,main:58 - Hibernate DataAccessException
org.springframework.orm.hibernate3.HibernateSystemException: Cannot instantiate abstract class or interface: com.jaspersoft.jasperserver.api.metadata.common.service.impl.hibernate.persistent.RepoResource; nested exception is org.hibernate.InstantiationException: Cannot instantiate abstract class or interface: com.jaspersoft.jasperserver.api.metadata.common.service.impl.hibernate.persistent.RepoResource
    at org.springframework.orm.hibernate3.SessionFactoryUtils.convertHibernateAccessException(SessionFactoryUtils.java:676)
    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.findByCriteria(HibernateTemplate.java:1055)
    at org.springframework.orm.hibernate3.HibernateTemplate.findByCriteria(HibernateTemplate.java:1048)
    at com.jaspersoft.jasperserver.api.metadata.common.service.impl.hibernate.HibernateRepositoryServiceImpl.loadRepoResourceList(HibernateRepositoryServiceImpl.java:846)
    at com.jaspersoft.jasperserver.api.metadata.common.service.impl.hibernate.HibernateRepositoryServiceImpl.loadRepoResourceList(HibernateRepositoryServiceImpl.java:834)
    at com.jaspersoft.jasperserver.api.metadata.common.service.impl.hibernate.HibernateRepositoryServiceImpl.loadResourcesList(HibernateRepositoryServiceImpl.java:630)
    at com.jaspersoft.jasperserver.api.metadata.common.service.impl.hibernate.HibernateRepositoryServiceImpl.loadResources(HibernateRepositoryServiceImpl.java:814)
    at com.jaspersoft.jasperserver.api.metadata.common.service.impl.hibernate.HibernateRepositoryServiceImpl$14.execute(HibernateRepositoryServiceImpl.java:597)
    at com.jaspersoft.jasperserver.api.metadata.common.service.impl.HibernateDaoImpl.executeCallback(HibernateDaoImpl.java:55)
    at com.jaspersoft.jasperserver.api.metadata.common.service.impl.hibernate.HibernateRepositoryServiceImpl.findResource(HibernateRepositoryServiceImpl.java:595)
    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 $Proxy0.findResource(Unknown Source)
    at com.jaspersoft.ji.war.themes.MTThemePropagatorImpl.assembleDefaultTheme(MTThemePropagatorImpl.java:252)
    at com.jaspersoft.ji.war.themes.MTThemePropagatorImpl.propagateActiveThemeChange(MTThemePropagatorImpl.java:336)
    at com.jaspersoft.ji.war.themes.MTThemeOnStartPropagator.afterPropertiesSet(MTThemeOnStartPropagator.java:54)
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1369)
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1335)
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:473)
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory$1.run(AbstractAutowireCapableBeanFactory.java:409)
    at java.security.AccessController.doPrivileged(Native Method)
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:380)
    at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:264)
    at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:222)
    at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:261)
    at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:185)
    at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:164)
    at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:429)
    at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:728)
    at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:380)
    at org.springframework.web.context.ContextLoader.createWebApplicationContext(ContextLoader.java:255)
    at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:199)
    at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:45)
    at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3972)
    at org.apache.catalina.core.StandardContext.start(StandardContext.java:4467)
    at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:791)
    at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:771)
    at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:546)
    at org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:637)
    at org.apache.catalina.startup.HostConfig.deployDescriptors(HostConfig.java:563)
    at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:498)
    at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1277)
    at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:321)
    at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:119)
    at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1053)
    at org.apache.catalina.core.StandardHost.start(StandardHost.java:785)
    at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1045)
    at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:443)
    at org.apache.catalina.core.StandardService.start(StandardService.java:519)
    at org.apache.catalina.core.StandardServer.start(StandardServer.java:710)
    at org.apache.catalina.startup.Catalina.start(Catalina.java:581)
    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.apache.catalina.startup.Bootstrap.start(Bootstrap.java:289)
    at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:414)
Caused by: org.hibernate.InstantiationException: Cannot instantiate abstract class or interface: com.jaspersoft.jasperserver.api.metadata.common.service.impl.hibernate.persistent.RepoResource
    at org.hibernate.tuple.PojoInstantiator.instantiate(PojoInstantiator.java:101)
    at org.hibernate.tuple.PojoInstantiator.instantiate(PojoInstantiator.java:123)
    at org.hibernate.tuple.entity.AbstractEntityTuplizer.instantiate(AbstractEntityTuplizer.java:366)
    at org.hibernate.persister.entity.AbstractEntityPersister.instantiate(AbstractEntityPersister.java:3620)
    at org.hibernate.impl.SessionImpl.instantiate(SessionImpl.java:1303)
    at org.hibernate.impl.SessionImpl.instantiate(SessionImpl.java:1292)
    at org.hibernate.loader.Loader.instanceNotYetLoaded(Loader.java:1323)
    at org.hibernate.loader.Loader.getRow(Loader.java:1230)
    at org.hibernate.loader.Loader.getRowFromResultSet(Loader.java:603)
    at org.hibernate.loader.Loader.doQuery(Loader.java:724)
    at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:259)
    at org.hibernate.loader.Loader.doList(Loader.java:2232)
    at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2129)
    at org.hibernate.loader.Loader.list(Loader.java:2124)
    at org.hibernate.loader.criteria.CriteriaLoader.list(CriteriaLoader.java:118)
    at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1597)
    at org.hibernate.impl.CriteriaImpl.list(CriteriaImpl.java:306)
    at org.springframework.orm.hibernate3.HibernateTemplate$36.doInHibernate(HibernateTemplate.java:1065)
    at org.springframework.orm.hibernate3.HibernateTemplate.doExecute(HibernateTemplate.java:419)
    ... 65 more
2012-03-09 15:14:41,499 ERROR ContextLoader,main:215 - Context initialization failed
org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'proOnStartPropagator' defined in ServletContext resource [/WEB-INF/applicationContext-multiTenancy-web.xml]: Invocation of init method failed; nested exception is com.jaspersoft.jasperserver.api.JSExceptionWrapper: Cannot instantiate abstract class or interface: com.jaspersoft.jasperserver.api.metadata.common.service.impl.hibernate.persistent.RepoResource; nested exception is org.hibernate.InstantiationException: Cannot instantiate abstract class or interface: com.jaspersoft.jasperserver.api.metadata.common.service.impl.hibernate.persistent.RepoResource
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1338)
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:473)
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory$1.run(AbstractAutowireCapableBeanFactory.java:409)
    at java.security.AccessController.doPrivileged(Native Method)
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:380)
    at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:264)
    at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:222)
    at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:261)
    at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:185)
    at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:164)
    at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:429)
    at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:728)
    at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:380)
    at org.springframework.web.context.ContextLoader.createWebApplicationContext(ContextLoader.java:255)
    at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:199)
    at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:45)
    at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3972)
    at org.apache.catalina.core.StandardContext.start(StandardContext.java:4467)
    at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:791)
    at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:771)
    at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:546)
    at org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:637)
    at org.apache.catalina.startup.HostConfig.deployDescriptors(HostConfig.java:563)
    at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:498)
    at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1277)
    at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:321)
    at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:119)
    at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1053)
    at org.apache.catalina.core.StandardHost.start(StandardHost.java:785)
    at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1045)
    at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:443)
    at org.apache.catalina.core.StandardService.start(StandardService.java:519)
    at org.apache.catalina.core.StandardServer.start(StandardServer.java:710)
    at org.apache.catalina.startup.Catalina.start(Catalina.java:581)
    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.apache.catalina.startup.Bootstrap.start(Bootstrap.java:289)
    at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:414)
Caused by: com.jaspersoft.jasperserver.api.JSExceptionWrapper: Cannot instantiate abstract class or interface: com.jaspersoft.jasperserver.api.metadata.common.service.impl.hibernate.persistent.RepoResource; nested exception is org.hibernate.InstantiationException: Cannot instantiate abstract class or interface: com.jaspersoft.jasperserver.api.metadata.common.service.impl.hibernate.persistent.RepoResource
    at com.jaspersoft.jasperserver.api.metadata.common.service.impl.HibernateDaoImpl.executeCallback(HibernateDaoImpl.java:59)
    at com.jaspersoft.jasperserver.api.metadata.common.service.impl.hibernate.HibernateRepositoryServiceImpl.findResource(HibernateRepositoryServiceImpl.java:595)
    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 $Proxy0.findResource(Unknown Source)
    at com.jaspersoft.ji.war.themes.MTThemePropagatorImpl.assembleDefaultTheme(MTThemePropagatorImpl.java:252)
    at com.jaspersoft.ji.war.themes.MTThemePropagatorImpl.propagateActiveThemeChange(MTThemePropagatorImpl.java:336)
    at com.jaspersoft.ji.war.themes.MTThemeOnStartPropagator.afterPropertiesSet(MTThemeOnStartPropagator.java:54)
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1369)
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1335)
    ... 39 more
Caused by: org.springframework.orm.hibernate3.HibernateSystemException: Cannot instantiate abstract class or interface: com.jaspersoft.jasperserver.api.metadata.common.service.impl.hibernate.persistent.RepoResource; nested exception is org.hibernate.InstantiationException: Cannot instantiate abstract class or interface: com.jaspersoft.jasperserver.api.metadata.common.service.impl.hibernate.persistent.RepoResource
    at org.springframework.orm.hibernate3.SessionFactoryUtils.convertHibernateAccessException(SessionFactoryUtils.java:676)
    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.findByCriteria(HibernateTemplate.java:1055)
    at org.springframework.orm.hibernate3.HibernateTemplate.findByCriteria(HibernateTemplate.java:1048)
    at com.jaspersoft.jasperserver.api.metadata.common.service.impl.hibernate.HibernateRepositoryServiceImpl.loadRepoResourceList(HibernateRepositoryServiceImpl.java:846)
    at com.jaspersoft.jasperserver.api.metadata.common.service.impl.hibernate.HibernateRepositoryServiceImpl.loadRepoResourceList(HibernateRepositoryServiceImpl.java:834)
    at com.jaspersoft.jasperserver.api.metadata.common.service.impl.hibernate.HibernateRepositoryServiceImpl.loadResourcesList(HibernateRepositoryServiceImpl.java:630)
    at com.jaspersoft.jasperserver.api.metadata.common.service.impl.hibernate.HibernateRepositoryServiceImpl.loadResources(HibernateRepositoryServiceImpl.java:814)
    at com.jaspersoft.jasperserver.api.metadata.common.service.impl.hibernate.HibernateRepositoryServiceImpl$14.execute(HibernateRepositoryServiceImpl.java:597)
    at com.jaspersoft.jasperserver.api.metadata.common.service.impl.HibernateDaoImpl.executeCallback(HibernateDaoImpl.java:55)
    ... 56 more
Caused by: org.hibernate.InstantiationException: Cannot instantiate abstract class or interface: com.jaspersoft.jasperserver.api.metadata.common.service.impl.hibernate.persistent.RepoResource
    at org.hibernate.tuple.PojoInstantiator.instantiate(PojoInstantiator.java:101)
    at org.hibernate.tuple.PojoInstantiator.instantiate(PojoInstantiator.java:123)
    at org.hibernate.tuple.entity.AbstractEntityTuplizer.instantiate(AbstractEntityTuplizer.java:366)
    at org.hibernate.persister.entity.AbstractEntityPersister.instantiate(AbstractEntityPersister.java:3620)
    at org.hibernate.impl.SessionImpl.instantiate(SessionImpl.java:1303)
    at org.hibernate.impl.SessionImpl.instantiate(SessionImpl.java:1292)
    at org.hibernate.loader.Loader.instanceNotYetLoaded(Loader.java:1323)
    at org.hibernate.loader.Loader.getRow(Loader.java:1230)
    at org.hibernate.loader.Loader.getRowFromResultSet(Loader.java:603)
    at org.hibernate.loader.Loader.doQuery(Loader.java:724)
    at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:259)
    at org.hibernate.loader.Loader.doList(Loader.java:2232)
    at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2129)
    at org.hibernate.loader.Loader.list(Loader.java:2124)
    at org.hibernate.loader.criteria.CriteriaLoader.list(CriteriaLoader.java:118)
    at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1597)
    at org.hibernate.impl.CriteriaImpl.list(CriteriaImpl.java:306)
    at org.springframework.orm.hibernate3.HibernateTemplate$36.doInHibernate(HibernateTemplate.java:1065)
    at org.springframework.orm.hibernate3.HibernateTemplate.doExecute(HibernateTemplate.java:419)
    ... 65 more
===============================================================================================

Does anyone have any idea what is going on here?

 

David

Post Edited by despec at 03/09/2012 20:58

[ORA-00933]

The code should be;

 

select

Cdate,

receipt

 

from

cash

 

where

Cdate >= $P{pFrom}

 

 

David

[Height = 0 when the value of a field is null or empty]

Try the "remove line when blank" property within the field element. Not certain, however, that this is going to work...

 

David

[Subtracting two fields]

Yep...The resulting variable should be set to bigDecimal....

 

David

[Subtracting two fields]

You would create a new Variable and put this within the expression field.

 

David

[Subtracting two fields]

Like so:

 

new java.Math.BigDecimal

(

$F{CAD}.doubleValue() - $F{CMD}.doubleValue()

)

 

 

David

[Can you sort using a variable?]

I often use a an Ireport variable in my SQL statements.  This gives my users the ability to sort on different fields of the report.  In this case, create a "Parameter" instead of a variable.  Here's a shor example:

I have a parameter called "user_choice" which I default to "city".  The user may change this by selecting from a list, say "City", "State" or "Zip"...The SQL qould look something like this:

select

  name,

  address.

  city,

  zip

from

  phone_book

order by

  $P!{user_choice}

 

Make sure to include the "!" point.

 

David

 

[Sum of months via Date]

Just off the top of my head, create variables for each month and within the expression field, set up a condition that tests for that date and if true, add the number of hours...

 

David

[Problems setting a Default Date]

Might be helpful is you post your JRXML file as well. You shouldn't be getting a NULL value for the assignments in your SQL query...

 

David

[if else textfield expressions]

At this point, it might be best to post your JRXML file...Quite honestly, I'm as confused as you.

 

David

[if else textfield expressions]

A lot of it depends on where you are placing the variable object. If you're summing, you'll want to put the variables in the Summary band. If you're putting them in the detail band, you'll end up seeing just the current record value...What kind of value is in $F{COUNT_APPS}?

[if else textfield expressions]

Two things...You need to create a "variable" to count...That is, create a variable called "MONDAY_CNT", set the Calculation to "Count" and the evaluation time to "Report"...

 

Try a boolean expression in variable expression field:

 

Boolean.valueOf ($F{DOW}.equals("TUESDAY"))

 

Not sure, though, this is going to work, but give it a shot.

 

David

 

[switch statement in a variable]

Don't forget to enclose in parentheses:

 

( $F{FIELDV}.equals("ab") ? "aaaa" :

( $F{FIELDV}.equals("bc") ? "bbbb" :

( $F{FIELDV}.equals("de") ? "cccc" : "" )))

[How to change default day language in timestamp?]

Could it be as simple as you forgot to enclose the entire statement with parentheses?

( DateFormatUtils.format($F{TGL_IN},"EEEEE").equals("Wednesday")? "Rabu":"Bukan Rabu" )

Post Edited by despec at 08/03/2011 20:44

[Text field pattern is working?]

Create a new string parameter and within the expression editor, type this:

$F{IP_NUM}.toString().substring(1, 2) + '.' + $F{IP_NUM}.toString().substring(3, 2) + '/' + $F{IP_NUM}.toString().substring(5, 4)

 

David

[if else textfield expressions]

I'm not sure if this will work, but try something like this.  Setup 5 variable fields (say Monday_Count to Friday_Count, and set them to evaluate at "Report Time".  In the expression editor, add this:

( $P{dotw}.equals{"Monday"} ? $F{CountAppt} : (else statment) )  for each variable.  Then place these variable fields in the summary band.  I believe this will get you your counts.

David

 

[basic tutorial on Modrian/OLAP in JasperAnalytics - somewhere?]

Find the Mondrian documentation. Although not the most perfect of documentation manuals, it should help in getting you started. Also check out your JasperAnalysis documentation.

 

David

[passing parameters to an Olap Analysis View]

Most definitely...I've embedded parameters within Ireport using Hyperlinks.  Here's an example:

$P{analysis_hyperlink} + "with member [Period.Period].[Period Total] as aggregate({(" + $F{ANALYSIS_DATES} + ")},    [Measures].CurrentMember) select {[Measures].[Activations], [Measures].[PortIns], [Measures].[Returns], [Measures].[FirstBill NonPays], [Measures].[GrossAdds]} ON COLUMNS, crossjoin({" + $F{ANALYSIS_DATES} + ", [Period.Period].[Period Total]}, {(" + $P{analysis_market_list} + ", " + $P{analysis_channel_list} + ")}) ON ROWS from [substats] where [isRevenue.Revenue].[Revenue]"

Not only am I passing parameters, but fields as well.  The $P{analysis_hyperlink} is the HTTP link:

"http://dashboards-dev02.revol.com:8080/jasperserver-pro/olap/viewOlap.html?=/analysis/views/Sales_Dashboard/sales_dashboard_gross_adds_view&mdx="

 

Hope this helps,

David

[Issue with the table in summary tab]

Matt,

 

My bad...Haven't used that object yet :-)

 

David

[if else textfield expressions]

Use this function in Ireport:

 

( <condition> ? exp1 : exp2 )

 

For example:

( $P{day_of_week}.equals("Monday") ? (do something) : (do something else) )

The question mark is the "true" condition, while the colon is the "false" condition.

 

David