jabrown

This can be accomplished using the REST API for Jaspersoft Server. The logout event/click in your embedding application can issue a logout call to Jaspersoft Server using the Authentication Service. Please see the authentication chapter in the following REST API Guide for Jaspersoft Server 7.8. The logout call is documented there. This logout call will require re-using or passing the JSESSIONID that is issued upon a successful login for the user.

Hi Alberto, It will be helpful to see the error being logged. Can you please reproduce the error, and paste or attach the log that is generated? You can check the Jaspersoft Studio log by following these instructions.

This involves two separate steps. Please see Postman HTTP examples below. A resource search on the repository fot all reportUnit type objects. GET /jasperserver-pro79/rest_v2/resources?type=reportUnit HTTP/1.1Host: localhost:8080Authorization: Basic c3VwZXJ1c2VyOnN1cGVydXNlcg==Cookie: userLocale=en_US; JSESSIONID=7B875C70FBC6DA4A13CA03C921DCD9A5[/code]A resource details search on the reportUnit resources returned from step 1. GET /jasperserver-pro79/rest_v2/resources/public/Samples/Reports/01._Geographic_Results_by_Segment_Report HTTP/1.1Host: localhost:8080Authorization: Basic c3VwZXJ1c2VyOnN1cGVydXNlcg==Cookie: userLocale=en_US; JSESSIONID=7B875C70FBC6DA4A13CA03C921DCD9A5[/code]

Yes, Jaspersoft Server's REST API allows for report execution with POST using the reportExecutions service. I've attached the following HTTP request sample of this using Postman. The first request is a synchronous request to execute the report. It returns the necessary request and export information. The second request retrieves the report output from the previous execution. You can choose to run an asynchronous request for longer running reports if preferred. POST /jasperserver-pro79/rest_v2/reportExecutions HTTP/1.1Host: localhost:8080Authorization: Basic c3VwZXJ1c2VyOnN1cGVydXNlcg==Content-Type: application/xmlCookie: userLocale=en_US; JSESSIONID=9E0BBE880F49C7987CAE6C4E43252641Content-Length: 509<reportExecutionRequest> <reportUnitUri>/public/Samples/Reports/01._Geographic_Results_by_Segment_Report</reportUnitUri> <async>false</async> <freshData>false</freshData> <saveDataSnapshot>false</saveDataSnapshot> <outputFormat>html</outputFormat> <interactive>true</interactive> <ignorePagination>true</ignorePagination> <parameters> <reportParameter name="Country"> <value>USA</value> </reportParameter> </parameters></reportExecutionRequest>[/code]GET /jasperserver-pro79/rest_v2/reportExecutions/ad0edbf2-abd2-4ebe-8344-b2e453eab496/exports/79662286-aa90-4e98-a732-337ab5ee0504/outputResource HTTP/1.1Host: localhost:8080Authorization: Basic c3VwZXJ1c2VyOnN1cGVydXNlcg==Cookie: userLocale=en_US; JSESSIONID=9E0BBE880F49C7987CAE6C4E43252641[/code]

Hi Mostafa, Per TIBCO's Jaspersoft Server Platform Support document for version 7.8. IBM Websphere 9.0.0.11 & 9.0.5.1 are certified.

You need to configure the SQL validator on Jaspersoft Server to accept WITH as valid syntax. TIBCO's default installation of Jaspersoft Server does not accept the WITH syntax to help prevent against SQL injection. More on SQL injection from the Jaspersoft Server Security Guide. You can add WITH to the valid SQL syntax by doing the following. Open jasperserver-pro/WEB-INF/classes/esapi/validation.properties Append the following to the ValidSQL rule: Validator.ValidSQL=(?is)^\s*(select|with)\s+^;+$ Close the file and restart the server. The ValidSQL rule will now allow for the words "select" or "with" to be at the beginning of a query.

Hello, You should be able achieve this by using the following expression for your text field. I belive the Java function you'll want to use is replace rather than split. You will replace your defined character with a new line. "AB/CD/E/F/".replace("/","rn") Your JRXML for the text field value will be as follows. <textFieldExpression><![CDATA["AB/CD/E/F/".replace("/","rn")]]></textFieldExpression> I hope this helps solve your challenege!

Hello, You can pass parameters, fields, and variables from the master report to a parameter defined in the sub report. Add a parameter in the sub report to accept the value from the master report.Add the sub report component to your master report. Point it to your sub report to be used.You can map the variable from the master report to the sub report's parameter through the UI wizard in Jaspersoft Studio when you create a new sub report. You could also modify your existing sub report component XML in the source view by adding the mapping with the below example.<subreportParameter name="SubReportSampleParameter"> <subreportParameterExpression><![CDATA[$V{MasterReportVariable}]]></subreportParameterExpression> </subreportParameter>