Clarity PPM

Expand all | Collapse all

How to integrate Jaspersoft reports/dashboard into Sharepoint sites?

Jump to Best Answer
  • 1.  How to integrate Jaspersoft reports/dashboard into Sharepoint sites?

    Posted 06-01-2017 08:57 AM

    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



  • 2.  Re: How to integrate Jaspersoft reports/dashboard into Sharepoint sites?
    Best Answer

    Posted 06-20-2017 01:33 AM

    Hello David,

     

    you can use the following link:

    Creating a dashboard in SharePoint using JasperServer reports 



  • 3.  Re: How to integrate Jaspersoft reports/dashboard into Sharepoint sites?

    Posted 09-03-2017 12:40 PM

    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.



  • 4.  Re: How to integrate Jaspersoft reports/dashboard into Sharepoint sites?

    Posted 09-11-2017 08:41 AM

    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.



  • 5.  Re: How to integrate Jaspersoft reports/dashboard into Sharepoint sites?

    Posted 10-05-2017 10:21 AM

    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