Skip to main content
Question

Report Designer

  • March 25, 2021
  • 2 replies
  • 124 views
M
Do Gooder (Customer)
Forum|alt.badge.img+1

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 replies.

    2 replies

    dhlelk
    Superhero
    Forum|alt.badge.img+15
    • dhlelk
    • Superhero
    • March 25, 2021

    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.

    https://www.linkedin.com/in/kludl/
    pwlm
    JohannesKnust
    Hero (Partner)
    Forum|alt.badge.img+12
    • JohannesKnust
    • Hero (Partner)
    • March 25, 2021

    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 settingsAccessibility statement