Clarity

 View Only
Expand all | Collapse all

How to integrate Jaspersoft reports in portlets

  • 1.  How to integrate Jaspersoft reports in portlets

    Posted Mar 27, 2015 09:18 AM

    Hi all,

     

    with CA PPM 14.2, the PMO Accelerator ships all reports formerly available in CABI also in Jaspersoft.

    Using the Advanced Reporting page, I can schedule these reports and store the results.


    Trying to integrate the reports in portlets using link fields, I can only find the old CABI reports in the action drop-down of the link. This corresponds with the fact that also the "Reports and Job" page only allows to schedule the old reports.


    Is there a way to use Jaspersoft without having to navigate to the Advanced Reporting page? The only option I see at the moment is to write a HTML portlet with an iframe which has the path to the ad hoc report as source.



  • 2.  Re: How to integrate Jaspersoft reports in portlets

    Broadcom Employee
    Posted Mar 27, 2015 09:30 AM

    Hi GeorgSchmid2014,

     

    Yes you are correct, the Reports and job links are only for CABI users for Jaspersoft its stored in Advance report. I don't see any linking yet. Probably an enhancement  under ideas could be opened.

     

    Reards

    Suman Pramanik



  • 3.  Re: How to integrate Jaspersoft reports in portlets

    Posted Apr 01, 2015 10:20 AM

    Here goes the idea:

    https://communities.ca.com/ideas/235720205

     

    Please vote



  • 4.  Re: How to integrate Jaspersoft reports in portlets

    Posted Mar 27, 2015 10:02 AM

    George, Suman,

     

    Would you please clarify something for me, as both portlets and Actions are mentioned.  I'm specifically concerned about running JasperSoft from object Actions links.

     

    We have a scenario where on our Issue Edit view, we have a "8D Format Report" available as a  link in the Actions pull-down menu.  This allows the contents of the Issue Edit view to be reported out in a special format that our company and customers require.  The report is in Crystal and we are on 13.1, planning to go to 14.2 ASAP.  When the user clicks on the "8D Format Report" link, the ID of the issue in the view is passed to Crystal, the report runs, happy-happy.

     

    If I understand this correctly, my scenario  will still run in 14.2 and as long as Crystal is supported in future versions.  But, if Crystal support is removed before an equivalent JasperSoft solution is available, I will lose the ability to run reports from object Action links.

     

    Do I understand this correctly?



  • 5.  Re: How to integrate Jaspersoft reports in portlets

    Posted Mar 27, 2015 10:07 AM

    Hi Dale,

     

    yes, your understanding is correct . Being optimistic, I assume that CA will get this done before removing CABI.



  • 6.  Re: How to integrate Jaspersoft reports in portlets

    Broadcom Employee
    Posted Mar 27, 2015 10:08 AM

    Hi Dale,

     

    With 14.2  BO is also supported along jaspersoft, however I don't see any action links for jaspersoft reports yet. May be we will have in future.

     

    Regards

    Suman Pramanik



  • 7.  Re: How to integrate Jaspersoft reports in portlets

    Posted Mar 27, 2015 10:16 AM

    Hi Suman,

     

    is there a way to build our own makeshift integration of the Jaspersoft reporting?

    From the browser log, I can see that CA PPM uses the REST API of Jaspersoft to open the Advanced Reporting page.

     

    It should be possible somehow to open a parametrized report in Jaspersoft.

     

    Any hints?



  • 8.  Re: How to integrate Jaspersoft reports in portlets

    Broadcom Employee
    Posted Mar 27, 2015 10:46 AM

    Hi GeorgSchmid2014,

     

    I need to check if we can, I am sorry I don't have the answer yet.

     

    Regards

    Suman Pramanik



  • 9.  Re: How to integrate Jaspersoft reports in portlets
    Best Answer

    Posted Mar 27, 2015 10:53 AM

    Hello

               In current release we do not have a facility to execute Jaspersoft reports from CA PPM using Object Actions links. However, this item is in the backlog.

     

    Thanks,

    Namita



  • 10.  Re: How to integrate Jaspersoft reports in portlets

    Posted Mar 27, 2015 11:14 AM

    Thank you, Namita - good to see that this is/was already in the delivery plan.

     

    I should expect to see it as an agenda point in End of Sprint demos of the next release, then, so that progress can be tracked.

     

    Happy-happy.



  • 11.  Re: How to integrate Jaspersoft reports in portlets

    Posted Mar 27, 2015 12:36 PM

    You are welcome Dale!!!

     

    Thanks,

    Namita



  • 12.  Re: How to integrate Jaspersoft reports in portlets

    Posted Mar 28, 2015 10:21 PM

    just an FYI

    iFrames became impossible in Clarity 13, not sure if they are possible in 14.x either, so even an iFrame may not be feasible.



  • 13.  Re: How to integrate Jaspersoft reports in portlets

    Posted Mar 30, 2015 03:18 AM

    Hi Paul,

     

    iFrames are possible in 14.x, that's not the problem. What is more challenging is to enable SSO by passing the user session in CA PPM to Japsersoft as it is done when opening the Advanced Reporting page.

    Also, the parameters from the CA PPM URL have to be made available to Jaspersoft.

     

    I really hope that CA gets this done quickly or at least provides some information on how to hook into the current standard functionality implemented for the integration already.



  • 14.  Re: How to integrate Jaspersoft reports in portlets

    Posted Aug 06, 2015 09:35 AM

    Hi George,

     

    When you said "IFrames are possible" does that mean it's also possible to embed an external web application (outside the domain) into an iframe in an html portet as well? That is, of course, without having to disable it in options for Clarity. If it is possible, how would I go about doing that?

     

    Regards,

     

    Tim



  • 15.  Re: How to integrate Jaspersoft reports in portlets

    Posted Aug 06, 2015 03:21 PM

    Are talking about something like the DHL portlet that comes with Clarity (eg 14.2. and earlier versions)



  • 16.  Re: How to integrate Jaspersoft reports in portlets

    Posted Aug 10, 2015 02:43 PM

    Hi Tim,

     

    I am not sure if I unterstand what you mean with "external web application", but of course you can display any HTML content, being static, internal or external in an ifram in CA PPM.

     

    Regards

    Georg



  • 17.  Re: How to integrate Jaspersoft reports in portlets

    Posted May 06, 2016 09:05 AM

    As per my knowledge, we can run jasper reports through action items (without having to navigate to advanced reporting page) by following below steps:

     

    1. Create HTML Portlet containing code to make a call to respective report.

    2. Create Portlet page for above HTML portlet.

    3. Add an internal link to that portlet page within an clarity object (project, idea, issue etc.) for which the report needs to be generated.

    4. Create new action for that link.

    5. Select that link in view layout of that object.

     

    I can provide more details if required.

     

    Attached is a sample report generated through action item.



  • 18.  Re: How to integrate Jaspersoft reports in portlets

    Posted May 06, 2016 09:21 AM

    I think that the detail of the "1.Create HTML Portlet containing code to make a call to respective report" is the important (complicated) part of this?



  • 19.  Re: How to integrate Jaspersoft reports in portlets

    Posted May 06, 2016 09:26 AM

    No, its not that complex. I can provide the sample code if required. Only limitation is that, it doesn't work in case of sub-objects. I'm currently figuring out the solution to make that work.



  • 20.  Re: How to integrate Jaspersoft reports in portlets

    Posted May 06, 2016 09:31 AM

    Ok then, I think that the detail of the "1.Create HTML Portlet containing code to make a call to respective report" is the important (interesting) part of this?

     

    ;-)



  • 21.  Re: How to integrate Jaspersoft reports in portlets

    Posted May 12, 2016 02:29 AM

    Hi Divyanshu,

    Can you please share sample code and Did you get any luck with sub-object?



  • 22.  Re: How to integrate Jaspersoft reports in portlets

    Posted May 12, 2016 02:41 AM

    For sub-objects, I've implemented following solution:

    1. Created copy of a particular report.

    2. Selected object's id on the basis of sub-object id within the query. For instance, my report runs on the basis of "Project ID" & I want to run that report for action item created for "Status Report" sub-object as well. So, the url for a particular status report will provide the sub-object id & that Id will be passed to my parameter which is expecting Project ID. In my query, I've used "Select odf_parent_id from tablename where id=parametername" for getting the project id.

    3. Rest process is same.

     

    Sample Code of HTML Portlet:

     

    <head>

    <style
    type="text/css">

       html, body, div, iframe { margin:0;
    padding:0;}

       iframe { display:block; width:100%;
    border:none; }

    </style>

    <head>

    <div>

      <iframe id="myiframe"
    frameborder="0" border="0"
    height="600"></iframe>

    </div>

    <script>

    var url1 =
    window.location.href;

    var str1=
    “/reportservice/flow.html?_flowId=viewReportFlow&_flowId=viewReportFlow&standAlone=true
    &reportUnit=/Customer_Custom/Action_Item/CSK_PRJ_ProjectStatusDetail&projectKey_1=";

    var location1 =
    url1.indexOf("id=");

    var projectid =
    url1.substring(location1 + 3, location1 + 10)

    var myiframe =
    document.getElementById('myiframe');

    1. myiframe.src = str1
      + projectid;

    </script>

    Key HTML Code
    Concepts

     

    HTML Reference

    Description

    Derived Location

    reportservice/flow.html

    Application
      page reference

     

    &_flowId=viewReportFlow

    Execution
      action. (report,ad-hoc view,dashboard, etc…)

    Object
      type to be executed

    &reportUnit=/Customer_C…%

    Path
      to report location

    Repository
      location with report id appended. The final value in the string is the report
      id. Can be copied from url when directly logged into JasperReports Server.

    &projectKey_1

    Parameter
      id associated with report parameter

    Report
      input control reference.

    Var location1

    Variable
      storing identifier for substring locations

    Set
      the index based on value in url

    Var projectid

    Substring
      to pull id from url based on location index

    Modify
      based on start and end locations of key field in the url

    Var myiframe =

    Leverage
      ‘myiframe’ technology

     

    1. Myiframe.src=

    Concatenate
      the url ‘str1 variable with projectid variable

     

    &decorate=no

    Hide
      JasperReports Server Main Menu bar

     

    &output=

    Dictates
      report output. (pdf, html, excel, etc…)