Home » Developer & Programmer » Reports & Discoverer » Dynamic Image in report without using BLOB  () 1 Vote
Dynamic Image in report without using BLOB [message #155853] Wed, 18 January 2006 23:06 Go to next message
rzkhan
Messages: 345
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
Re: Dynamic Image in report without using BLOB [message #157010 is a reply to message #155853] Mon, 30 January 2006 12:29 Go to previous messageGo to next message
dude4084
Messages: 221
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




Re: Dynamic Image in report without using BLOB [message #157131 is a reply to message #157010] Tue, 31 January 2006 08:22 Go to previous messageGo to next message
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 662 times)
Re: Dynamic Image in report without using BLOB [message #157162 is a reply to message #155853] Tue, 31 January 2006 12:05 Go to previous messageGo to next message
dude4084
Messages: 221
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
Re: Dynamic Image in report without using BLOB [message #157175 is a reply to message #157162] Tue, 31 January 2006 13:49 Go to previous messageGo to next message
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.
Re: Dynamic Image in report without using BLOB [message #400257 is a reply to message #157175] Mon, 27 April 2009 06:22 Go to previous messageGo to next message
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 1332 times)
Re: Dynamic Image in report without using BLOB [message #505006 is a reply to message #400257] Thu, 28 April 2011 14:56 Go to previous message
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
Previous Topic: using webutil to print reports in client
Next Topic: Using orarrp
Goto Forum:
  


Current Time: Sun Dec 04 04:49:37 CST 2016

Total time taken to generate the page: 0.06486 seconds