OraFAQ Forum: Reports & Discoverer » Pictures in a Report from Database

Home » Developer & Programmer » Reports & Discoverer » Pictures in a Report from Database

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

Pictures in a Report from Database [message #246183]

Wed, 20 June 2007 03:57

aslme
Messages: 26
Registered: May 2006
Location: Pakistan

Junior Member

Dear
I have report in which i call a Picture in a Report from Database which is based on Employee Id their is a little problem is that when their is no picture of any employee the message comes

'REP-0108: File not found'

but if their is picture report runs successfully i want if their is no picture then their is a text message shows on a picture of 'Picture Not available' and report run as on.

please tell what can i do.
if any one want to see the Practically See the Attachement.

Thanks

Cheers

----------------------------------------------------------------
Najm

Attachment: Scott.zip
(Size: 19.22KB, Downloaded 1086 times)

Report message to a moderator

Re: Pictures in a Report from Database [message #246190 is a reply to message #246183]

Wed, 20 June 2007 04:16

kamran.it
Messages: 265
Registered: September 2005
Location: Karachi

Senior Member

try this query in your report and plz chang the path as per your path.

SELECT EMPNO, ENAME, empno, 'E:\My Documents\Scott\Scott\'||empno||'.jpg' as picture from emp
--|| '' || EMPNO ||'.JPG'   PHOTO_LOC FROM EMP
WHERE EMPNO = :eno

Report message to a moderator

Previous Topic:	add calendar to report runtime parameter form
Next Topic:	how to run a form in report 6i at runtime

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Jul 05 08:19:21 CDT 2024