Home » Developer & Programmer » Reports & Discoverer » Pictures in a Report from Database
Pictures in a Report from Database [message #246183] Wed, 20 June 2007 03:57 Go to next message
Messages: 25
Registered: May 2006
Location: Pakistan
Junior Member

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.



  • Attachment: Scott.zip
    (Size: 19.22KB, Downloaded 172 times)
Re: Pictures in a Report from Database [message #246190 is a reply to message #246183] Wed, 20 June 2007 04:16 Go to previous message
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
Previous Topic: add calendar to report runtime parameter form
Next Topic: how to run a form in report 6i at runtime
Goto Forum:

Current Time: Wed Oct 26 18:12:15 CDT 2016

Total time taken to generate the page: 0.09507 seconds