Search code examples
oracleoracle10greportoraclereports

Oracle Reports: Can I Use Multiple Image According to Query in One Report?


I want to use 4 different images according to where statement of my query. Is it possible in Oracle Reports?


Solution

  • I used formula column (in comment of @MichaelBroughton).

    1. I added a formula column to my Data Model.
    2. In property of column I choose Datatype = Character, Read from File = Yes and File Format = Image
    3. This is PL/SQL Formula:
    function CF_1Formula return Char is
    begin
        null;
        if :column_a  = 1 then
          return 'c:\dir\image1.jpg';
        elsif :column_a  = 2 then 
          return 'c:\dir\image2.jpg';     
      end if; 
    end;