luca.frisetti

Do you have any update regarding this issue?

Does anyone have suggestions to help me?

is there a way to exclude the creation of "ireport.jasperserver.url", when I publish a report in JasperReports Server from the Studio? file.jrxml<jasperReport>...<property name="ireport.jasperserver.url" value="https://localhost/jasperserver-pro/"/>...<jasperReport>

Thanks for your reply. I can assign a role that is the company name and publish this report in public folder. example: report1 (permission : ROLE_suborganization1) report2 (permission : ROLE_suborganization2) But my problem in this way is that in my application, organization1 user isn't able to assign report roles, because I don't want give him this functionality. So I can't solve my problem ...

I'm using the JasperServerProfessional 5.5 with the multi tenancy plugin, and I want ask you if in the Repository view, is there the possibility to share a report with all my sub organizations without put it in the public folder? example: organizations organization1 (report1) suborganization1 suborganization2 suborganization3 organization2 .... public so I want share my report1 with suborganization1,2 and 3 , but not with organization2 and I don't want to use the public folder because I didn't found a way to share by organization. Thanks Luca

I also have the same problem, does anyone have found a solution?

Thanks, but it isn't exactly what I want ... because I should write anyway code, and I can't do it directly to the Expression Editor. I found a way writing this expression DATE(YEAR(TODAY( )),MONTH(TODAY( )),DAY(TODAY( ))-1), but isn't there a concise way ? maybe similar to EDATE(TODAY( ),-1) that give the possibility to have the previous month.

How can I get the yesterday's date with Expression Editor in JSS 5.5, without write Java code ?

Does anyone have suggestions to help me?

Hi Massimo, I tried to edit my XMLA Data Adapter connection to point the SugarCRM Schema, one of the example of JasperServer 5.5, to test the "preview data" functionality in JasperStudio, and the problem persist, but now I think it is more easy to replicate the problem. I attached you my mdx query, fields definition and finally the error. Thanks, Luca

Hi Massimo, thanks for your reply, I understood that the read fields is disabled since there is not automatic retrieval (even is not so intuitive), and so I added manually my fields, now what I didn't understand is if I'm wrong the syntax in fields name/field type/description, because the exception don't give me a clear information. Regards, Luca

Hi, I have the following error during the data preview with a mdx query connected to a XMLA Data Adatper : net.sf.jasperreports.engine.JRRuntimeException: XML/A fault: XMLA MDX parse failed; Actor: Mondrian; Code: SOAP-ENV:Client.00HSBD01; at net.sf.jasperreports.olap.xmla.JRXmlaQueryExecuter.handleResultFault(JRXmlaQueryExecuter.java:494)at net.sf.jasperreports.olap.xmla.JRXmlaQueryExecuter.parseResult(JRXmlaQueryExecuter.java:335)at net.sf.jasperreports.olap.xmla.JRXmlaQueryExecuter.createDatasource(JRXmlaQueryExecuter.java:130)at net.sf.jasperreports.engine.fill.JRFillDataset.createQueryDatasource(JRFillDataset.java:1112)at net.sf.jasperreports.engine.fill.JRFillDataset.initDatasource(JRFillDataset.java:689)at net.sf.jasperreports.engine.fill.JRBaseFiller.setParameters(JRBaseFiller.java:1281)at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:900)at net.sf.jasperreports.engine.fill.JRFiller.fill(JRFiller.java:152)at net.sf.jasperreports.engine.JasperFillManager.fill(JasperFillManager.java:464)at com.jaspersoft.studio.data.reader.DatasetReader.start(DatasetReader.java:184)at com.jaspersoft.studio.property.dataset.dialog.DataPreviewTable$4.run(DataPreviewTable.java:250)at org.eclipse.core.internal.jobs.Worker.run(Worker.java:54) The mdx query is correct, and run into the ad hoc view, but when I put it to the JasperStudio, I have the "read fields" disabled and the data preview with the error described.Do you have any suggestion, please ? Thanks,Luca

I solved with a reboot of JasperReports Server

Hi, I'm trying to connect my Studio 5.5.0 to the local JasperReports Server 5.5 in my Ubuntu OS, but when I test the connection, I receive the following exception: AxisFault faultCode: {http://schemas.xmlsoap.org/soap/envelope/}Server.userException faultSubcode: faultString: java.lang.NullPointerException faultActor: faultNode: faultDetail: {http://xml.apache.org/axis/}stackTrace:java.lang.NullPointerExceptionat org.apache.axis.transport.http.CommonsHTTPSender.invoke(CommonsHTTPSender.java:193)at org.apache.axis.strategies.InvocationStrategy.visit(InvocationStrategy.java:32)at org.apache.axis.SimpleChain.doVisiting(SimpleChain.java:118)at org.apache.axis.SimpleChain.invoke(SimpleChain.java:83)at org.apache.axis.client.AxisClient.invoke(AxisClient.java:165)at org.apache.axis.client.Call.invokeEngine(Call.java:2784)at org.apache.axis.client.Call.invoke(Call.java:2767)at org.apache.axis.client.Call.invoke(Call.java:2443)at org.apache.axis.client.Call.invoke(Call.java:2366)at org.apache.axis.client.Call.invoke(Call.java:1812)at com.jaspersoft.ireport.jasperserver.ws.RepositorySoapBindingStub.list(RepositorySoapBindingStub.java:339)at com.jaspersoft.ireport.jasperserver.ws.WSClient.getVersion(WSClient.java:155)at com.jaspersoft.studio.server.protocol.soap.SoapConnection.getServerInfo(SoapConnection.java:29)at com.jaspersoft.studio.server.protocol.soap.SoapConnection.connect(SoapConnection.java:39)at com.jaspersoft.studio.server.protocol.ProxyConnection.connect(ProxyConnection.java:24)at com.jaspersoft.studio.server.WSClientHelper.checkConnection(WSClientHelper.java:77)at com.jaspersoft.studio.server.wizard.ServerProfileWizard.connect(ServerProfileWizard.java:106)at com.jaspersoft.studio.server.wizard.ServerProfileWizard.access$1(ServerProfileWizard.java:100)at com.jaspersoft.studio.server.wizard.ServerProfileWizard$2.run(ServerProfileWizard.java:80)at org.eclipse.jface.operation.ModalContext$ModalContextThread.run(ModalContext.java:121) {http://xml.apache.org/axis/}hostname:mypc java.lang.NullPointerExceptionat org.apache.axis.AxisFault.makeFault(AxisFault.java:101)at org.apache.axis.transport.http.CommonsHTTPSender.invoke(CommonsHTTPSender.java:315)at org.apache.axis.strategies.InvocationStrategy.visit(InvocationStrategy.java:32)at org.apache.axis.SimpleChain.doVisiting(SimpleChain.java:118)at org.apache.axis.SimpleChain.invoke(SimpleChain.java:83)at org.apache.axis.client.AxisClient.invoke(AxisClient.java:165)at org.apache.axis.client.Call.invokeEngine(Call.java:2784)at org.apache.axis.client.Call.invoke(Call.java:2767)at org.apache.axis.client.Call.invoke(Call.java:2443)at org.apache.axis.client.Call.invoke(Call.java:2366)at org.apache.axis.client.Call.invoke(Call.java:1812)at com.jaspersoft.ireport.jasperserver.ws.RepositorySoapBindingStub.list(RepositorySoapBindingStub.java:339)at com.jaspersoft.ireport.jasperserver.ws.WSClient.getVersion(WSClient.java:155)at com.jaspersoft.studio.server.protocol.soap.SoapConnection.getServerInfo(SoapConnection.java:29)at com.jaspersoft.studio.server.protocol.soap.SoapConnection.connect(SoapConnection.java:39)at com.jaspersoft.studio.server.protocol.ProxyConnection.connect(ProxyConnection.java:24)at com.jaspersoft.studio.server.WSClientHelper.checkConnection(WSClientHelper.java:77)at com.jaspersoft.studio.server.wizard.ServerProfileWizard.connect(ServerProfileWizard.java:106)at com.jaspersoft.studio.server.wizard.ServerProfileWizard.access$1(ServerProfileWizard.java:100)at com.jaspersoft.studio.server.wizard.ServerProfileWizard$2.run(ServerProfileWizard.java:80)at org.eclipse.jface.operation.ModalContext$ModalContextThread.run(ModalContext.java:121)Caused by: java.lang.NullPointerExceptionat org.apache.axis.transport.http.CommonsHTTPSender.invoke(CommonsHTTPSender.java:193)... 19 more I checked other posts and tried some solutions but without any lucky. Do you have any suggestion, please? Thanks,Luca