1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

How to Display a Logo Dynamically?

Discussion in 'Oracle Apps Technical' started by jagadekara, Jan 29, 2014.

  1. jagadekara

    jagadekara Forum Guru

    Messages:
    1,126
    Likes Received:
    145
    Trophy Points:
    1,805
    Location:
    Pulivendula
    Hi all,

    Can anyone know How to Display a Logo Dynamically in Oracle Reports?
     
  2. Subba

    Subba Guest

    HI Jagadekara,
    Are you looking for XML publisher report or Oracle Report?

    Regards,
    Subba
     
  3. Ecor

    Ecor Active Member

    Messages:
    20
    Likes Received:
    3
    Trophy Points:
    90
    Insert a image in your RTF , then add alternate text to taht image
    url:{'${OA_MEDIA}/imagename.fileextension'}
     
    SAADIQ and jagadekara like this.
  4. jagadekara

    jagadekara Forum Guru

    Messages:
    1,126
    Likes Received:
    145
    Trophy Points:
    1,805
    Location:
    Pulivendula
    Thanks Ecor....

    It's working fine.
     
  5. SAADIQ

    SAADIQ Active Member

    Messages:
    21
    Likes Received:
    0
    Trophy Points:
    100
    for example i have a xml report depending on the org_id i need to change the logo dynamically then how to achive that?

    thank u
    saadiq.
     
  6. jagadekara

    jagadekara Forum Guru

    Messages:
    1,126
    Likes Received:
    145
    Trophy Points:
    1,805
    Location:
    Pulivendula
    Hi,

    You can use if condition in rtf for this.

    if org_id=201 then logo1 else logo 2 end if ... like this you can display.
     
    SAADIQ likes this.
  7. yowancristo

    yowancristo Forum Advisor

    Messages:
    103
    Likes Received:
    10
    Trophy Points:
    305
    Location:
    Bangalore
    Hi,

    If the number of operating unit is more, then you can use logic as shown below.

    Store all the logos in $OA_MEDIA and follow naming convention like Logo_101, Logo_102,...Logo_190.

    In the report write code

    l_org_id := FND_PROFILE.VALUE('ORG_ID');
    l_logo_name := 'Logo_' || l_org_id;