Passing Project ID to JasperSoft

[Roland Parrotte]

In previous versions of Clarity, which used Business Objects, we were able to configure the Project and automatically run a Business Object report, from the Project Details (see screen shot).

 

Is there a suggestion to run JasperSoft report in the same way.  Happy for this to be in the Project List View, are users are used to having easy access, and want to retain this functionaly when we migrate to JasperSoft.

[Legacy User]

Sure. you can just do a web call. it opens in a new window.  You can modify the url parameters to have it only run in pdf for example.

 

Create an external action using a similar URL with your info.

 

https://url.com/reportservice/flow.html?_flowId=viewReportFlow&reportUnit=/Reporting/Embedded/REPORT&standAlone=false&decorate=no

(You can copy most of this link by right clicking the report in jasper and 'open in new tab' then copy the relevant bits from the url)

 

Create your arguments.

investment_code

and/or others

 

presto.

 

Reference:

Embedding using HTTP API | Jaspersoft Community 

[Roland Parrotte]

Thanks Austin, that should do it.  I haven't had a chance to implement in Clarity, but reading the provided document link for JasperSoft, looks very promising.

[Roland Parrotte]

I packaged this up today as a Portlet (NSQL attached), which is working well.  We use a code constant for the server URL, so the code can be used on our DEV/TEST/PROD environments.

 

This is attached to our Project Dashboard, so staff can then run two (at this time) JasperSoft reports, passing in the Project ID.

 

Working well except that it doesn't automatically run the report, it waits for the user to press the 'apply' button.  Will raise additional question on this one next.

Attachment(s)

jaspersoft_portlet.txt.zip   552 B 1 version

[Legacy User]

Might need another report if this one is used elsewhere.  But you can remove the linked input controls and keep the parameters.  This will remove any filtering options.