Home » Developer & Programmer » Reports & Discoverer » How to display image in a oracle 10g reports? (Oracle 10g Reports, Win XP)
How to display image in a oracle 10g reports? [message #605096] Tue, 07 January 2014 05:45 Go to next message
stalin4d
Messages: 226
Registered: May 2010
Location: Chennai, Tamil Nadu, Indi...
Senior Member
How to display image in a oracle 10g reports?
Re: How to display image in a oracle 10g reports? [message #605097 is a reply to message #605096] Tue, 07 January 2014 05:48 Go to previous messageGo to next message
mist598
Messages: 1195
Registered: February 2013
Location: Hyderabad
Senior Member
Hi stalin4u,

Create a simple report based on your image table.

if you do not see the BLOB column image.

go to the property pallet of the BLOB column under Data model.

Data model -> Properties

change the file format field to IMAGE

re execute the report.

And also Set the property "Read from file" to Yes for the item in the datemodel, and additionally set the filetype to "Image" (also in the properties of the item)


Regards,
Mist
Hope this will solve your problem

[Updated on: Tue, 07 January 2014 05:53]

Report message to a moderator

Re: How to display image in a oracle 10g reports? [message #605098 is a reply to message #605097] Tue, 07 January 2014 06:20 Go to previous messageGo to next message
stalin4d
Messages: 226
Registered: May 2010
Location: Chennai, Tamil Nadu, Indi...
Senior Member
i dont have any table for the image? is there any method without a table?


[EDITED by LF: removed unnecessary quote of the whole previous message]

[Updated on: Tue, 07 January 2014 09:11] by Moderator

Report message to a moderator

Re: How to display image in a oracle 10g reports? [message #605099 is a reply to message #605098] Tue, 07 January 2014 06:27 Go to previous messageGo to next message
mist598
Messages: 1195
Registered: February 2013
Location: Hyderabad
Senior Member
Quote:
i dont have any table for the image? is there any method without a table?

Yes.
Add a picture (download any picture from the web, save 
in in C:\\temp, then go to Edit, Import)

Otherwise
Just check ithttp://www.cob.unt.edu/itds/courses/bcis5420/lectures/oracledevelopertutorialapr10_w_o_designer.pdf
Re: How to display image in a oracle 10g reports? [message #605101 is a reply to message #605098] Tue, 07 January 2014 06:50 Go to previous messageGo to next message
mist598
Messages: 1195
Registered: February 2013
Location: Hyderabad
Senior Member
1) First, download and save in any directory
2) click on the Paper layout and click on the Insert(Mani Menu)->Image
3) Here you have to import the images

Re: How to display image in a oracle 10g reports? [message #605104 is a reply to message #605099] Tue, 07 January 2014 07:00 Go to previous messageGo to next message
stalin4d
Messages: 226
Registered: May 2010
Location: Chennai, Tamil Nadu, Indi...
Senior Member
mist598 wrote on Tue, 07 January 2014 17:57
Quote:
i dont have any table for the image? is there any method without a table?

Yes.
Add a picture (download any picture from the web, save 
in in C:\\temp, then go to Edit, Import)

Otherwise
Just check ithttp://www.cob.unt.edu/itds/courses/bcis5420/lectures/oracledevelopertutorialapr10_w_o_designer.pdf


Hello mist i am not saying to display an image in a Form!
My image should be displayed in a Report see the Forum this is for Reports only...

your link is also dealing with forms only.
thanks for the tutorial its very good.
so please give an idea for displaying in reports!

[Updated on: Tue, 07 January 2014 07:01]

Report message to a moderator

Re: How to display image in a oracle 10g reports? [message #605105 is a reply to message #605104] Tue, 07 January 2014 07:03 Go to previous messageGo to next message
mist598
Messages: 1195
Registered: February 2013
Location: Hyderabad
Senior Member
sorry wrong post,

1) First, download and save in any directory or if u have the image file
2) click on the Paper layout and click on the Insert(Mani Menu)->Image
3) Here you have to import the images

Thank You!!
Re: How to display image in a oracle 10g reports? [message #605107 is a reply to message #605105] Tue, 07 January 2014 07:19 Go to previous messageGo to next message
stalin4d
Messages: 226
Registered: May 2010
Location: Chennai, Tamil Nadu, Indi...
Senior Member
Already i have done this process, the image displaying empty!
mist this is not working so, there is another option!

anybody please answer!!!

[Updated on: Tue, 07 January 2014 07:20]

Report message to a moderator

Re: How to display image in a oracle 10g reports? [message #605108 is a reply to message #605107] Tue, 07 January 2014 07:31 Go to previous messageGo to next message
mist598
Messages: 1195
Registered: February 2013
Location: Hyderabad
Senior Member
1)click on the paper design view-->File Link is there Click and drag a rectangle.
2)Double-click the file link object to display the Property Inspector.
3)Under File Link Boilerplate:
Set the Source File Format property to Image.
Set the Source Filename property to the name of the file containing the image

Hope it will helps you..
Re: How to display image in a oracle 10g reports? [message #605110 is a reply to message #605108] Tue, 07 January 2014 07:45 Go to previous messageGo to next message
stalin4d
Messages: 226
Registered: May 2010
Location: Chennai, Tamil Nadu, Indi...
Senior Member
Yes thats right i checked its working fine in bitmap or default, but, my report is a character mode so
this option not working in Character mode Report!

any other option to display image in a character mode report?
Re: How to display image in a oracle 10g reports? [message #605111 is a reply to message #605110] Tue, 07 January 2014 07:52 Go to previous messageGo to next message
mist598
Messages: 1195
Registered: February 2013
Location: Hyderabad
Senior Member
The property sheet values for 'Report Width 'and 'Report Height under Layout Model Node, 'Character Mode',
for 'Header Section',
Main Section'
and 'Trailer Section' all matched in the original version of the report.
Report Width: 126
Report Height: 50

Report height was modified to 45 while making other changes.

Hope this help you!!
Re: How to display image in a oracle 10g reports? [message #605112 is a reply to message #605110] Tue, 07 January 2014 07:52 Go to previous messageGo to next message
cookiemonster
Messages: 13917
Registered: September 2008
Location: Rainy Manchester
Senior Member
The whole point of character mode reports is that they designed to be displayed/printed by programs/printers that can't cope with graphics.
So no, there is no way to include an image in a character mode report.
Re: How to display image in a oracle 10g reports? [message #605114 is a reply to message #605112] Tue, 07 January 2014 07:57 Go to previous messageGo to next message
stalin4d
Messages: 226
Registered: May 2010
Location: Chennai, Tamil Nadu, Indi...
Senior Member
I hope cookiemonster is right mr.mist!, but what to do? i need to draw lines and rectangle to display.
but its very tedious to display in a character mode report!


[EDITED by LF: removed unnecessary quote of the whole previous message]

[Updated on: Tue, 07 January 2014 09:12] by Moderator

Report message to a moderator

Re: How to display image in a oracle 10g reports? [message #605116 is a reply to message #605114] Tue, 07 January 2014 08:07 Go to previous messageGo to next message
mist598
Messages: 1195
Registered: February 2013
Location: Hyderabad
Senior Member
Setting properties for an ASCII (character-mode)

Hope help you.. Smile




CM: replaced lengthy cut and paste from the documentation with link to relevant bit of the documentation.

[Updated on: Tue, 07 January 2014 08:15] by Moderator

Report message to a moderator

Re: How to display image in a oracle 10g reports? [message #605118 is a reply to message #605116] Tue, 07 January 2014 08:21 Go to previous messageGo to next message
stalin4d
Messages: 226
Registered: May 2010
Location: Chennai, Tamil Nadu, Indi...
Senior Member
I Heartily Appreciate your intention of answering,
but you are instructing me for setting a report to a character mode,
this is already done by me...

please read my previous post which i answered to cookie,

I salute your Curiosity of replying but please give an ideal answer which is relevant and helpful
thank you...


[EDITED by LF: removed unnecessary quote of the whole previous message]

[Updated on: Tue, 07 January 2014 09:13] by Moderator

Report message to a moderator

Re: How to display image in a oracle 10g reports? [message #605119 is a reply to message #605118] Tue, 07 January 2014 08:29 Go to previous messageGo to next message
mist598
Messages: 1195
Registered: February 2013
Location: Hyderabad
Senior Member
Ok Thank You , I will try to send you answer..Smile

if You have problem with printing your report (on a printer ) in character mode, check DESFORMAT system parameter. This parameter - name of the printer definition file(.PRT file). (Look oraclehome\report25\printers\). In this file are specified height and width of your printed report. You can change or delete this values.


Regards,
Mist

[Updated on: Tue, 07 January 2014 08:32]

Report message to a moderator

Re: How to display image in a oracle 10g reports? [message #605125 is a reply to message #605118] Tue, 07 January 2014 08:46 Go to previous messageGo to next message
mist598
Messages: 1195
Registered: February 2013
Location: Hyderabad
Senior Member
Hi stalin,

Could you try this..

In oracle Reports click on the report module.
In properties palette go to character mode and change Design in Character units to 'Y'.
Your reports will now print in Character mode

Thank You..:0
Re: How to display image in a oracle 10g reports? [message #605126 is a reply to message #605119] Tue, 07 January 2014 08:49 Go to previous messageGo to next message
shahzad-ul-hasan
Messages: 615
Registered: August 2002
Senior Member
create a formula column and put that code into it. and call that on that field(picture).
function CF_1Formula return Char is
 DIRX VARCHAR2(60) :='D:\Photo\';
 PIC VARCHAR2(85);
BEGIN
 PIC:=DIRX ||:stuid||'.JPG';
  return pic;
  if length(pic) < 28 then 
   pic:=null;
   return pic;
  end if;
end;

/forum/fa/11580/0/

[Updated on: Tue, 07 January 2014 08:50]

Report message to a moderator

Re: How to display image in a oracle 10g reports? [message #605135 is a reply to message #605125] Tue, 07 January 2014 09:19 Go to previous messageGo to next message
cookiemonster
Messages: 13917
Registered: September 2008
Location: Rainy Manchester
Senior Member
mist598 wrote on Tue, 07 January 2014 14:46
Hi stalin,

Could you try this..

In oracle Reports click on the report module.
In properties palette go to character mode and change Design in Character units to 'Y'.
Your reports will now print in Character mode

Thank You..:0


I'm pretty sure Stalin can print character mode reports, he's having trouble adding graphics to them.

@Stalin - I think (from vague memory) that frames will appear in character mode reports. If you want something else then you need to clarify what.
Re: How to display image in a oracle 10g reports? [message #605137 is a reply to message #605126] Tue, 07 January 2014 09:24 Go to previous messageGo to next message
cookiemonster
Messages: 13917
Registered: September 2008
Location: Rainy Manchester
Senior Member
shahzad-ul-hasan wrote on Tue, 07 January 2014 14:49
create a formula column and put that code into it. and call that on that field(picture).
function CF_1Formula return Char is
 DIRX VARCHAR2(60) :='D:\Photo\';
 PIC VARCHAR2(85);
BEGIN
 PIC:=DIRX ||:stuid||'.JPG';
  return pic;
  if length(pic) < 28 then 
   pic:=null;
   return pic;
  end if;
end;



You seem to have missed where I pointed out that character mode reports can never include images. A formula column is not going to fix that.
In addition the above code is at least 4 lines longer than it needs to be.
I have no idea what you're trying to achieve with the length check, but it'll never execute since it follows a return statement.
Re: How to display image in a oracle 10g reports? [message #605141 is a reply to message #605137] Tue, 07 January 2014 10:02 Go to previous messageGo to next message
Littlefoot
Messages: 21806
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
cookiemonster

You seem to have missed where I pointed out that character mode reports can never include images.


Oh, yes, they can.
Re: How to display image in a oracle 10g reports? [message #605143 is a reply to message #605141] Tue, 07 January 2014 10:03 Go to previous messageGo to next message
cookiemonster
Messages: 13917
Registered: September 2008
Location: Rainy Manchester
Senior Member
Razz
Re: How to display image in a oracle 10g reports? [message #605195 is a reply to message #605141] Tue, 07 January 2014 23:33 Go to previous messageGo to next message
stalin4d
Messages: 226
Registered: May 2010
Location: Chennai, Tamil Nadu, Indi...
Senior Member
Littlefoot wrote on Tue, 07 January 2014 21:32
cookiemonster

You seem to have missed where I pointed out that character mode reports can never include images.


Oh, yes, they can.


ok i tried with that but its not working, simply i need to do is
actually what i need is i need to print ifsc code or Account no for that i tried
to draw a rectangle box and vertical lines inside that but i cant able to adjust that
so i tried to add an image for that but that too not working.

below is the format i need:

Account Number :  -----------------
                  |6|0|0|1|1|2|1|5|                
                  -----------------


Just a box with inverted lines to write or print account number or anything.

pls check the report i am attaching with this and any idea to achieve my requirement.
  • Attachment: TEST.rdf
    (Size: 40.00KB, Downloaded 1934 times)

[Updated on: Tue, 07 January 2014 23:41]

Report message to a moderator

Re: How to display image in a oracle 10g reports? [message #605242 is a reply to message #605195] Wed, 08 January 2014 04:26 Go to previous message
Littlefoot
Messages: 21806
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Man, I was just kidding, ASCII art can't solve your problem (unless you want to print A4-size Che Guevaras).

As you were told, character-mode reports can't display any image. The best you can hope for is exactly what you posted:
Account Number :  -----------------
                  |6|0|0|1|1|2|1|5|                
                  -----------------

If you want to play with it, go ahead - there's no real problem in creating such an output if it satisfies your needs.
Previous Topic: Heading should print only in Main Section
Next Topic: barcode print in oracle report 6i
Goto Forum:
  


Current Time: Thu Mar 28 14:39:06 CDT 2024