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
aslme
Messages: 25
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 175 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
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
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: Fri Dec 09 19:16:20 CST 2016

Total time taken to generate the page: 0.12536 seconds