I am creating a report using JasperSoft Studio that uses a domain. I have a calculated field in that domain that strips the first 2 characters from another field using the following command: substr(SPRINTS.SPRINT_NAME,1,2). This works fine. What I really want is for this field to show the first 2 words of that field, but when I replace the command above with the following command: substr(SPRINTS.SPRINT_NAME,1,INSTR(SPRINTS.SPRINT_NAME,' ',1,2)) I get the following error message below when I try and preview the report in Jaspersoft Studio: If I use this syntax directly using a SQL command against the Oracle db, it works just fine. Can anyone tell me how to write an expression in the domain calculated fields to give me the first 2 words of another field? ERROR MESSAGE: net.sf.jasperreports.engine.JRException: net.sf.jasperreports.engine.JRException: javax.ws.rs.ProcessingException: Error reading entity from input stream.at com.jaspersoft.studio.editor.preview.view.control.ReportControler.fillReport(ReportControler.java:530)at com.jaspersoft.studio.editor.preview.view.control.ReportControler.access$20(ReportControler.java:505)at com.jaspersoft.studio.editor.preview.view.control.ReportControler$5.run(ReportControler.java:386)at org.eclipse.core.internal.jobs.Worker.run(Worker.java:55)Caused by: net.sf.jasperreports.engine.JRException: javax.ws.rs.ProcessingException: Error reading entity from input stream.at com.jaspersoft.studio.server.domain.conn.DomainQueryExecuter.createDatasource(DomainQueryExecuter.java:229)at net.sf.jasperreports.engine.fill.JRFillDataset.createQueryDatasource(JRFillDataset.java:1129)at net.sf.jasperreports.engine.fill.JRFillDataset.initDatasource(JRFillDataset.java:696)at net.sf.jasperreports.engine.fill.BaseReportFiller.setParameters(BaseReportFiller.java:437)at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:526)at net.sf.jasperreports.engine.fill.BaseFillHandle$ReportFill.run(BaseFillHandle.java:119)at java.lang.Thread.run(Thread.java:745)Caused by: javax.ws.rs.ProcessingException: Error reading entity from input stream.at org.glassfish.jersey.message.internal.InboundMessageContext.readEntity(InboundMessageContext.java:866)at org.glassfish.jersey.message.internal.InboundMessageContext.readEntity(InboundMessageContext.java:810)at org.glassfish.jersey.client.ClientResponse.readEntity(ClientResponse.java:368)at org.glassfish.jersey.client.InboundJaxrsResponse$2.call(InboundJaxrsResponse.java:122)at org.glassfish.jersey.internal.Errors.process(Errors.java:315)at org.glassfish.jersey.internal.Errors.process(Errors.java:297)at org.glassfish.jersey.internal.Errors.process(Errors.java:228)at org.glassfish.jersey.process.internal.RequestScope.runInScope(RequestScope.java:399)at org.glassfish.jersey.client.InboundJaxrsResponse.readEntity(InboundJaxrsResponse.java:119)at com.jaspersoft.studio.server.protocol.restv2.RESTv2ExceptionHandler.handleErrorDescriptorList(RESTv2ExceptionHandler.java:84)at com.jaspersoft.studio.server.protocol.restv2.RESTv2ExceptionHandler.handleErrorDescriptor(RESTv2ExceptionHandler.java:108)at com.jaspersoft.studio.server.protocol.restv2.RESTv2ExceptionHandler.handleException(RESTv2ExceptionHandler.java:58)at com.jaspersoft.studio.server.protocol.restv2.ARestV2ConnectionJersey.toObj(ARestV2ConnectionJersey.java:55)at com.jaspersoft.studio.server.domain.protocol.RestV2.executeQuery(RestV2.java:147)at com.jaspersoft.studio.server.domain.protocol.DomainProxy.executeQuery(DomainProxy.java:41)at com.jaspersoft.studio.server.domain.DomainManager.executeQuery(DomainManager.java:85)at com.jaspersoft.studio.server.domain.conn.DomainQueryExecuter.createDatasource(DomainQueryExecuter.java:226)... 6 moreCaused by: com.fasterxml.jackson.databind.JsonMappingException: Can not deserialize instance of java.util.ArrayList out of START_OBJECT token at [source: org.glassfish.jersey.message.internal.ReaderInterceptorExecutor$UnCloseableInputStream@6b34e798; line: 1, column: 1]at com.fasterxml.jackson.databind.JsonMappingException.from(JsonMappingException.java:148)at com.fasterxml.jackson.databind.DeserializationContext.mappingException(DeserializationContext.java:749)at com.fasterxml.jackson.databind.DeserializationContext.mappingException(DeserializationContext.java:745)at com.fasterxml.jackson.databind.deser.std.CollectionDeserializer.handleNonArray(CollectionDeserializer.java:275)at com.fasterxml.jackson.databind.deser.std.CollectionDeserializer.deserialize(CollectionDeserializer.java:216)at com.fasterxml.jackson.databind.deser.std.CollectionDeserializer.deserialize(CollectionDeserializer.java:206)at com.fasterxml.jackson.databind.deser.std.CollectionDeserializer.deserialize(CollectionDeserializer.java:25)at com.fasterxml.jackson.databind.ObjectReader._bind(ObjectReader.java:1232)at com.fasterxml.jackson.databind.ObjectReader.readValue(ObjectReader.java:676)at com.fasterxml.jackson.jaxrs.base.ProviderBase.readFrom(ProviderBase.java:808)at org.glassfish.jersey.message.internal.ReaderInterceptorExecutor$TerminalReaderInterceptor.invokeReadFrom(ReaderInterceptorExecutor.java:264)at org.glassfish.jersey.message.internal.ReaderInterceptorExecutor$TerminalReaderInterceptor.aroundReadFrom(ReaderInterceptorExecutor.java:234)at org.glassfish.jersey.message.internal.ReaderInterceptorExecutor.proceed(ReaderInterceptorExecutor.java:154)at org.glassfish.jersey.message.internal.MessageBodyFactory.readFrom(MessageBodyFactory.java:1124)at org.glassfish.jersey.message.internal.InboundMessageContext.readEntity(InboundMessageContext.java:851)... 22 more
