Skip to main content

Hi,

I have a report (OutsideOpDeliveryNoteRep.rdl) that get the information from a table that I can’t find in IFS just in SQL (outside_op_delivery_note_rep) is it possible to get a value from a table that the report does not use?

 

Hi @Magnus Karlsson,

 

You need to find the report method to drill down to the underlying logic.

SELECT t.method --Output: OUTSIDE_OP_DELIVERY_NOTE_RPI.Execute_Report
FROM   report_sys_tab t
WHERE  t.report_id = 'OUTSIDE_OP_DELIVERY_NOTE_REP' --Report ID as per "Report Definitions" window
;

 

Thereafter you could view spec and body of the above extracted package (OUTSIDE_OP_DELIVERY_NOTE_RPI) and navigate to the PROCEDURE (Execute_Report) to find the logic.

 

Cheers !
Dhananjaya.

hi there,

i suggest the pl sql developer quick search instead of a long query but the output will be the same as @dhlelk mentioned.

hint - RMB view spec and body you wanna click.

Terms & ConditionsCookie settings