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?
This topic has been closed for comments
Userlevel 6
+15
Hi
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.
Userlevel 4
+11
hi there,
i suggest the pl sql developer quick search instead of a long query but the output will be the same as
hint - RMB view spec and body you wanna click.
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.