OraFAQ Forum: Reports & Discoverer » IMAGE IN REPORT (3 merged)

Home » Developer & Programmer » Reports & Discoverer » IMAGE IN REPORT (3 merged)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

IMAGE IN REPORT (3 merged) [message #690066]

Wed, 02 October 2024 02:36

Mr Rj
Messages: 3
Registered: September 2024

Junior Member

I WANT TO DISPLAY THE PICTURE IN THE REPORT IF THE PICTURE EXISTS IN THAT PATH THEN SHOW IF IT DOES NOT EXIST THEN SHOW A DUMMY PICTURE WHEN I RUN THE REPORT THEN SHOW AN ERROR
REP-0108 FILE C\EMPPIC\.JPG NOT FOUND I WANT IF NOT FOUND THEN SHOW DUMMY

Report message to a moderator

Re: IMAGE IN REPORT (3 merged) [message #690199 is a reply to message #690066]

Fri, 29 November 2024 04:49

shahzad-ul-hasan
Messages: 643
Registered: August 2002

Senior Member

Create a formula coulmn and put this code in that. set its "File Format" to "Image".

function CF_1Formula return Char is
 DIRX VARCHAR2(60) :='D:\Photo\';
 PIC VARCHAR2(85);
BEGIN
 PIC:=DIRX ||:stuid||'.JPG';
  return pic;
  if length(pic) < 28 then 
   pic:=null;
   return pic;
  end if;
end;

Report message to a moderator

Re: IMAGE IN REPORT (3 merged) [message #690200 is a reply to message #690199]

Fri, 29 November 2024 06:15

Michel Cadot
Messages: 68776
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

I don't know if this is correct in Forms or not but I can say that this part:

  if length(pic) < 28 then 
   pic:=null;
   return pic;
  end if;

will never be executed.

Report message to a moderator

Previous Topic:	count student
Next Topic:	dense_rank() in formula column

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Jun 19 00:54:30 CDT 2026