You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register
Skip to content
  • Register

    • Presentation variable based on another presentation variable

    edited May 2, 2025 5:27PM in Reporting and Analytics for SCM 1 comment

    Summary:

    I would like to print the Negotiation Title of the selected Negotiation Number in the Header.

    I have the Negotiation number in a presentation variable (pb_negotiation).

    How can I print the Title of this selected Negotiation .

    I tried with a presentation variable (pv_title) with Default Selection as an SQL (SELECT "- Supplier List Detail"."Negotiation Header Negotiation Title" FROM "Sourcing - Supplier Negotiations Real Time" WHERE "- Supplier List Detail"."Negotiation Header Negotiation Number" = '@{pv_negotiation}') but not getting any results.

    I tried the same SQL at Choice List Values as well without any results.

    Tagged:

    Howdy, Stranger!

    Log In

    To view full details, sign in.

    Register

    Don't have an account? Click here to get started!