OraFAQ Forum: Reports & Discoverer » Reading Image in the Reports.

Home » Developer & Programmer » Reports & Discoverer » Reading Image in the Reports. (6 i )

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

Reading Image in the Reports. [message #679589]

Tue, 10 March 2020 09:52

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 ?

Report message to a moderator

Re: Reading Image in the Reports. [message #679592 is a reply to message #679589]

Tue, 10 March 2020 10:07

cookiemonster
Messages: 13963
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.

Report message to a moderator

Re: Reading Image in the Reports. [message #679593 is a reply to message #679592]

Tue, 10 March 2020 10:08

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.

Report message to a moderator

Re: Reading Image in the Reports. [message #679594 is a reply to message #679592]

Tue, 10 March 2020 10:12

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.

Report message to a moderator

Re: Reading Image in the Reports. [message #679595 is a reply to message #679594]

Tue, 10 March 2020 10:14

cookiemonster
Messages: 13963
Registered: September 2008
Location: Rainy Manchester

Senior Member

Have you specified the path correctly?
Is the folder on the reports server?

Report message to a moderator

Re: Reading Image in the Reports. [message #679597 is a reply to message #679595]

Tue, 10 March 2020 10:27

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.

Report message to a moderator

Re: Reading Image in the Reports. [message #679603 is a reply to message #679597]

Tue, 10 March 2020 11:44

cookiemonster
Messages: 13963
Registered: September 2008
Location: Rainy Manchester

Senior Member

how large are the files?
A quick google suggests reports can't cope with anything large

Report message to a moderator

Re: Reading Image in the Reports. [message #679604 is a reply to message #679603]

Tue, 10 March 2020 12:10

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?

Report message to a moderator

Re: Reading Image in the Reports. [message #679611 is a reply to message #679604]

Tue, 10 March 2020 16:17

Littlefoot
Messages: 21823
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.

Report message to a moderator

Previous Topic:	Report output to network location
Next Topic:	call Function in oracle Report

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Feb 06 22:52:28 CST 2025