alberto.hernandez

Hi there, could you help me kindly with this error "missing EOF at $P!{valArticle} ", I get this error in the sql editor with the following query: SELECT * FROM View1 WHERE Date BETWEEN $P{date1} AND $P{date2} $P!{valArticle} $P!{valOt} $P!{valCed} The value expression for $P!{valArticle} is the following: ($P{article}.isEmpty()==true ? "" : " AND ArtCode='" + $P{article} +"'" ) The value expression for $P!{valOt} is the following: ($P{ot}.isEmpty()==true ? "" : " AND Ord_OT='" + $P{ot} +"'" ) The value expression for $P!{valCedula} is the below: ($P{cedula}.isEmpty()==true ? "" : " AND EmployeeIDReceives='" + $P{cedula} +"'" ) thanks for your help

I get a error when publish a report and run report unit but when I run the report in preview windows in jasper studio run fine. the message error is the below: org.apache.http.client.HttpResponseException: generic.error.message There was an error on the server. Try again or contact site administrators. (Error UID: 17fc65d2-9771-4815-9fdc-dc34cb336f54) at com.jaspersoft.studio.server.protocol.restv2.RESTv2ExceptionHandler.handleErrorDescriptor(RESTv2ExceptionHandler.java:106) at com.jaspersoft.studio.server.protocol.restv2.RESTv2ExceptionHandler.handleException(RESTv2ExceptionHandler.java:66) at com.jaspersoft.studio.server.protocol.restv2.ARestV2ConnectionJersey.toObj(ARestV2ConnectionJersey.java:52) at com.jaspersoft.studio.server.protocol.restv2.RestV2ConnectionJersey.initInputControls(RestV2ConnectionJersey.java:972) at com.jaspersoft.studio.server.protocol.ProxyConnection.initInputControls(ProxyConnection.java:507) at com.jaspersoft.studio.server.editor.ReportRunControler$1.run(ReportRunControler.java:100) at org.eclipse.jface.operation.ModalContext$ModalContextThread.run(ModalContext.java:121)