Maximo Open Forum

HELLO,

I CREATE TWO REPORTS  WITH HYPERLINK TO ANOTHER REPORT.

THE FIRST REPORT BASED ON THE PIE CHART. I GET THIS ISSUE "Error 401: SRVE0295E: Error reported: 401 "

THE SECOND REPORT BASE ON A ROW I GET THIS ISSUE "Missing required parameter: __report."

SOMEONE CAN HELP ME??

Hello Koffi,

Have you seen the Work Order Detail report (out of the box)?

If you open the report file (in Eclipse for example) and look at the 'Hyperlink' option within Properties, you'll notice a few parameters necessary for this to work. Pay attention to the parameter 'where' and ensure your syntax is correct, e.g., (" recordtable.recordid=" + row["recordid"] + " "). If you can't edit these parameters in your report, you'll want to consider updating the XML code inserting the piece of code related to the parameters. 

I hope this helps

Fulgence, two different errors usually mean two different root causes:

The 401 error (from the pie chart hyperlink) is an authentication issue. When BIRT tries to call a sub-report via hyperlink, it makes a new HTTP request to the Maximo server. If your session cookie isn't being passed along, Maximo rejects it with a 401. Check that your hyperlink URL is using a relative path (not an absolute URL with a different hostname or port) and that your IHS/WebSphere configuration isn't stripping the session on the redirect.

The "Missing required parameter: __report" error means the hyperlink isn't passing the report file path correctly. As Jhonatan mentioned, look at the Hyperlink properties in Eclipse. You need both:

• The __report parameter pointing to the .rptdesign file path
• The where parameter with correct syntax, e.g., "yourtable.columnname=" + row["columnvalue"]

A quick way to debug: open the OOTB Work Order Detail report (woprint.rptdesign) in Eclipse and look at how its drill-down hyperlinks are configured - it's the best working reference for getting the parameter syntax right.

Did you get this resolved?