|
|
| Re: How to display image in a oracle 10g reports? [message #605097 is a reply to message #605096] |
Tue, 07 January 2014 05:48   |
 |
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 #605118 is a reply to message #605116] |
Tue, 07 January 2014 08:21 |
 |
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 |
|
mist598
Messages: 1195
Registered: February 2013
Location: Hyderabad
|
Senior Member |
|
|
Ok Thank You , I will try to send you answer..
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 #605135 is a reply to message #605125] |
Tue, 07 January 2014 09:19 |
cookiemonster
Messages: 13962
Registered: September 2008
Location: Rainy Manchester
|
Senior Member |
|
|
mist598 wrote on Tue, 07 January 2014 14:46Hi 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 |
cookiemonster
Messages: 13962
Registered: September 2008
Location: Rainy Manchester
|
Senior Member |
|
|
shahzad-ul-hasan wrote on Tue, 07 January 2014 14:49create 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 #605195 is a reply to message #605141] |
Tue, 07 January 2014 23:33 |
|
stalin4d
Messages: 226
Registered: May 2010
Location: Chennai, Tamil Nadu, Indi...
|
Senior Member |
|
|
Littlefoot wrote on Tue, 07 January 2014 21:32cookiemonster
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 2775 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 |
 |
Littlefoot
Messages: 21823
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.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
