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
you can use the following link:
Creating a dashboard in SharePoint using JasperServer reports
The solution for integrating a Jaspersoft Report in an HTML Portlet should work for Sharepoint as well:
The only difficulty is to replace the Clarity login with URL-parameters.
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.
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.