OraFAQ Forum: Reports & Discoverer » Dynamic Image in report without using BLOB

Home » Developer & Programmer » Reports & Discoverer » Dynamic Image in report without using BLOB (

) 1 Vote

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

Dynamic Image in report without using BLOB [message #155853]

Wed, 18 January 2006 23:06

rzkhan
Messages: 370
Registered: March 2005

Senior Member

hi.. I have students pics in a folder. I want to display it in report using studentID.)I searched the forum but this cant help me..any solution.. please..

Riaz

Report message to a moderator

Re: Dynamic Image in report without using BLOB [message #157010 is a reply to message #155853]

Mon, 30 January 2006 12:29

dude4084
Messages: 222
Registered: March 2005
Location: Mux

Senior Member

HI

I try to help you by guiding through an example. Just learn from it and modify it according to you needs.

Step-1) Create a table and insert a sample row as follow

 Create table test (ID varchar2(3), filename varchar2(255));

 insert into test values ('123', '123.tif');

step-2) Make a simple report with the help of report wizard and using following SQL command

Select ID, filename from test;

Step-3) In layout mode, expand the field filename to make it a big square and change its properties in property palette.
Change >>>> Read from file = Yes
Change >>>> File format = Image

Step-4) Save ur report file in a folder

Step-5) Place 123.tif, the picture file, in the same folder where u have saved the report.

Thats all.
Now run the report and u will see the result.

I am attaching the sample report too.

Bye
Dude

Attachment: image_report.RDF
(Size: 72.00KB, Downloaded 2652 times)

Report message to a moderator

Re: Dynamic Image in report without using BLOB [message #157131 is a reply to message #157010]

Tue, 31 January 2006 08:22

Shaila.Mehra
Messages: 88
Registered: July 2005
Location: mumbai

Member

19:24:40 Oracle>create table image(id varchar2(5),filename varchar2(255));

Table created.
19:38:42 Oracle>insert into image
19:38:47 2 values(1,'20.tif');

1 row created.

19:38:54 Oracle>commit;

Commit complete.

I put the image and report files in the same folder
but it is giving message when i run it. The message is
Rep-0108 File 20.tif not found

Here i am attaching my report.

Please have a look .

Thanks

Shaila.

Attachment: image.rdf
(Size: 56.00KB, Downloaded 2105 times)

Report message to a moderator

Re: Dynamic Image in report without using BLOB [message #157162 is a reply to message #155853]

Tue, 31 January 2006 12:05

dude4084
Messages: 222
Registered: March 2005
Location: Mux

Senior Member

Hi

On reading post of Shaila.Mehra, i tried to run my created report (image_report.RDF) and to my big surprise it gave me the error.

In order to find the solution, i compiled it with short cut key CTRL+ T (or File > admininstartion > compile-file). Then i ran the REP file and WOW it was working.

I am also able to run succesfully image.REP (the complied version).

So, though, i got the solution but dont know the reason that why definition file (RDF) is not working but compilied (REP).

Any comments on it from experts are welcomed.

Dude

Report message to a moderator

Re: Dynamic Image in report without using BLOB [message #157175 is a reply to message #157162]

Tue, 31 January 2006 13:49

developer2006
Messages: 3
Registered: January 2006

Junior Member

you can't see images on live previewer. you have to run REP file to see the images.The same with buttons.

Report message to a moderator

Re: Dynamic Image in report without using BLOB [message #400257 is a reply to message #157175]

Mon, 27 April 2009 06:22

ht_maya
Messages: 16
Registered: April 2009
Location: ORISSA, INDIA

Junior Member

Hi,

I have also same type of problem.
I did same everything same as per the procedure. But when i am running the report from menu, error message is coming like "Unable to read link file '123.tif'. Check link file format".
Please see the attached screen shot.

Regards,
M Behera

Attachment: image.pdf
(Size: 68.53KB, Downloaded 2989 times)

Report message to a moderator

Re: Dynamic Image in report without using BLOB [message #505006 is a reply to message #400257]

Thu, 28 April 2011 14:56

babsoni
Messages: 3
Registered: May 2010
Location: Bamako - Mali

Junior Member

In my case the procedure is correct only if i precise the complete name of the file. Example : c:\photos\123.tif

Report message to a moderator

Previous Topic:	using webutil to print reports in client
Next Topic:	Using orarrp

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Jan 09 15:40:44 CST 2025