Hello Dude4084

Thank you for coming to the rescue
.I have used your code as below and it compiled successful .Unfortunately no display and i'm getting error REP-1401 for employees having PICS.BUt when I enter identification_number of which the employee doesn't have pic the report runs. Thank you.


function CF_imageFormula return Char is


l_filename text_io.file_type;
BEGIN
l_filename := text_io.fopen ('C:\DMSS-C\KIDS\' || :identification_number ||'.jpg', 'r');
text_io.fclose (l_filename);
RETURN 'C:\DMSS-C\KIDS\' || :identification_number ||'.jpg' ;

EXCEPTION
-- the report photo doesn't exist
WHEN OTHERS THEN
BEGIN
l_filename := text_io.fopen ('C:\DMSS-C\KIDS\0.JPG', 'r');
text_io.fclose (l_filename);
RETURN 'C:\DMSS-C\KIDS\0.jpg';
EXCEPTION
-- the report photo 'default_image.jpg' doesn't exist
WHEN OTHERS THEN
RETURN NULL;


END;
end;