Search

Join this Blog for direct reference of any post into your inbox. To join just click on "Join this Site" under "Follower" then Login with your Email.*** DECLARATION: I Maintain this Blog for Helping Myself While at Work and Welcome any body Needing Help!!!.*** CAUTION: Using any of the script from this Blog may contain at Own Risk. These scripts May or May not have been Tested.***

Tuesday, 18 June 2013

How to display logo in oracle Report from base Table

Sometimes you need to display the desired logo or customize log in the oracle report generally the company logo. In that case you have to keep the logo destination into the base table and create a function get_logo (formula column) and write the query to access the logo. Do not forget to design the layout of logo on the top of the report and to keep the logo.jpg file on the related destination derive.
Select logo from logo;
LOGO
-------------------------------------------------
\\192.168.14.17\e\mujaz_logo.jpg
Create get_logo Fromula column
Column Type: Formula
Datatype: Character – 250
Read from File: Yes
File Format: Image
function get_logoFormula return Char is
  logo varchar2(250);
begin
      select logo into logo
      from   logo;
      return (logo);
exception
      when no_data_found then
      return (null);
      when others then
      return (sqlerrm);
end;
Design Layout of logo:
Name: F_1
Source: get_logo
Column Type: Formula
Datatype: Character – 250
Read from File: Yes
File Format: Image

0 comments:

Post a Comment