How to integrate Jaspersoft reports/dashboard into Sharepoint sites?

[David Spreitzer]

Hello community,

 

what are the possibilities to embed Jaspersoft reports/dashboard into Sharepoint sites? Who has experiences to share?
The value would be not to share/distribute documents only, but to show actual reporting content, e.g. portfolio overview, project status,...

According to the Jaspersoft community (Embedding using HTTP API | Jaspersoft Community ), there are (at least) two possibilities:
- Webservices
- HTTP API and Viewer webpart

 

Thanks David

[Kritika Rana]

Hello David,

 

you can use the following link:

Creating a dashboard in SharePoint using JasperServer reports 

[David Spreitzer]

The solution for integrating a Jaspersoft Report in an HTML Portlet should work for Sharepoint as well:

https://communities.ca.com/thread/241750563?et=watches.email.thread#comment-241871782

 

The only difficulty is to replace the Clarity login with URL-parameters.

[Georg Schmid]

The best solution would be to use the reportservice within CA PPM if it is acceptable to have to login to CA PPM -> This allows to use personalized reports rights, either the OOTB security views for adhoc reporting or your own rights queries for pixel perfect reporting.

Alternatively, you have to use a global user whose name and password are set in clear text in the URL via j_username and j_password.

[David Spreitzer]

Hello,

the workaround to the CA PPM reportservice login was to create a 'dashboard' user with access to all project data and add the URLs-parameters you mentioned to the URLs calling the reports in a Sharepoint iFrame.

BR David