Home » Developer & Programmer » Reports & Discoverer » Reading Image in the Reports. (6 i )
Reading Image in the Reports. [message #679589] Tue, 10 March 2020 09:52 Go to next message
amjad_alahdal
Messages: 102
Registered: October 2013
Location: Saudi Arabia
Senior Member
Hello,
I am creating a report that uses the employee_id to get the Image from the server.
What I have done so far is :

I created a new report with the simple select statement as :
select 
'\\172.15.10.25\departments\Interfaces\employee_Images\'||
employee_id ||'.jpg' Image 
from
employees ; 
Then I set the field to be :
Character.
Read from File : Yes.
File Format : Image.

I always get this error :

REP-0606: Unable to read link file \\***********.jpg  Check link file format
I have read that oracle developer 6i supports reading files such as jpg, bmp , etc.
My problem seems that the developer can't read the file, but the question is why ?
Do I have to modify anything ?
Any clue ?
Re: Reading Image in the Reports. [message #679592 is a reply to message #679589] Tue, 10 March 2020 10:07 Go to previous messageGo to next message
cookiemonster
Messages: 13894
Registered: September 2008
Location: Rainy Manchester
Senior Member
It can certainly read files from the file system it's running on.
But you appear to be trying to read the file from somewhere else.
I'm not sure it supports paths like that.
Re: Reading Image in the Reports. [message #679593 is a reply to message #679592] Tue, 10 March 2020 10:08 Go to previous messageGo to next message
amjad_alahdal
Messages: 102
Registered: October 2013
Location: Saudi Arabia
Senior Member
I will try to use a local directory and check if it works.
Re: Reading Image in the Reports. [message #679594 is a reply to message #679592] Tue, 10 March 2020 10:12 Go to previous messageGo to next message
amjad_alahdal
Messages: 102
Registered: October 2013
Location: Saudi Arabia
Senior Member
cookiemonster wrote on Tue, 10 March 2020 18:07
It can certainly read files from the file system it's running on.
But you appear to be trying to read the file from somewhere else.
I'm not sure it supports paths like that.
I have tried to set the folder in D: and modified the directory. The same problem occurred.
Re: Reading Image in the Reports. [message #679595 is a reply to message #679594] Tue, 10 March 2020 10:14 Go to previous messageGo to next message
cookiemonster
Messages: 13894
Registered: September 2008
Location: Rainy Manchester
Senior Member
Have you specified the path correctly?
Is the folder on the reports server?
Re: Reading Image in the Reports. [message #679597 is a reply to message #679595] Tue, 10 March 2020 10:27 Go to previous messageGo to next message
amjad_alahdal
Messages: 102
Registered: October 2013
Location: Saudi Arabia
Senior Member
cookiemonster wrote on Tue, 10 March 2020 18:14
Have you specified the path correctly?
Is the folder on the reports server?
I have rechecked it. The path works fine.
Re: Reading Image in the Reports. [message #679603 is a reply to message #679597] Tue, 10 March 2020 11:44 Go to previous messageGo to next message
cookiemonster
Messages: 13894
Registered: September 2008
Location: Rainy Manchester
Senior Member
how large are the files?
A quick google suggests reports can't cope with anything large
Re: Reading Image in the Reports. [message #679604 is a reply to message #679603] Tue, 10 March 2020 12:10 Go to previous messageGo to next message
amjad_alahdal
Messages: 102
Registered: October 2013
Location: Saudi Arabia
Senior Member
Yeah, Right.
I minimize the size of some pictures. The images which are greater than 2 MB couldn't be displayed. Small sizes pictures were displayed. A question came on to my mind. What is the maximum size of the image to be displayed in such a report?
Re: Reading Image in the Reports. [message #679611 is a reply to message #679604] Tue, 10 March 2020 16:17 Go to previous message
Littlefoot
Messages: 21592
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
From my own experience, it is not about one image size, but total size.

For example, I had to display manager's signature at the bottom of each page in the report which produced e.g. 1000 pages. It failed. But, when I reduced scanned signature's image size from 100 KB to 5 KB, everything was OK.

So ... it just depends.
Previous Topic: Report output to network location
Next Topic: call Function in oracle Report
Goto Forum:
  


Current Time: Sat Sep 19 19:49:16 CDT 2020