Topic
  • 2 replies
  • Latest Post - ‏2014-03-05T07:40:22Z by Trude
StuartG
StuartG
3 Posts

Pinned topic Report Integration to SSRS

‏2014-02-04T13:43:50Z | eri ssrs

Has anybody got a step by step guide to integrating SQL Service Reporting Service reports to Maximo v7.5? I've read all of the IBM ERI documentation going and spent a while trawling the web, but I don't quite understand what I need to do.

I have working reports is SSRS that I can launch from Maximo from a toolbar icon using 'Launch In Context', so the report basically works. What I want to achieve is to register my reports in Report Admin and access these from the applications and also have access to the 'where' clause (and other parameters).

Reading the ERI document, it talks of using the 'customreports.jsp' file for Integration. I've configured the 'mxe.report.custom.ServerURL to point to this file and when I launch my registered report I get the JSP page showing you all the parameters passed. That's Nice. Clearly, the parameters are included as a html form post ; I'm more familiar with URL parameters passes to the Report URL, but hey I can go with that.  Is this customreports.jsp just an example to show you what's available or are you supposed to write some jsp to invoke the report from there?  It's how to get to my SSRS report and access these parameters that is lacking in the documentation I've read.

Guidance gratefully received.

Stuart

  • StuartG
    StuartG
    3 Posts

    Re: Report Integration to SSRS

    ‏2014-02-06T08:31:23Z  

    Getting there. From what I've pieced together so far, yes you are supposed to use the 'customreport.jsp' as a way of invoking your SSRS report and converting the HTTP POST to a GET call with URL parameters.

    There's an example here from the Actuate developers site :

    http://developer.actuate.com/community/devshare/_/designing-birt-reports/1606-running-reports-on-the-birt-iserver-from-within-maximo75-using-eri

    There's more work to do get to a slick solution.

  • Trude
    Trude
    1 Post

    Re: Report Integration to SSRS

    ‏2014-03-05T07:40:22Z  
    • StuartG
    • ‏2014-02-06T08:31:23Z

    Getting there. From what I've pieced together so far, yes you are supposed to use the 'customreport.jsp' as a way of invoking your SSRS report and converting the HTTP POST to a GET call with URL parameters.

    There's an example here from the Actuate developers site :

    http://developer.actuate.com/community/devshare/_/designing-birt-reports/1606-running-reports-on-the-birt-iserver-from-within-maximo75-using-eri

    There's more work to do get to a slick solution.

    We trying to integrate SQL Server Reporting Service reports to Maximo 6.2.7. Did your integration succeed?

    Please can you provide more info on which URL on the SSRS side to use so that can receive the information from maximo. Any other information will be greatly appreciated.