Home » Developer & Programmer » Reports & Discoverer » rep-0108 (Dev6i)
rep-0108 [message #544814] Thu, 23 February 2012 23:55 Go to next message
nmd_group
Messages: 15
Registered: February 2012
Location: Dhaka,Bangladesh
Junior Member
Every consumers have a record field containing picture path.
all consumers pictures are not available.
certificate.rdf returns rep-0108 error message.
please,help.
Re: rep-0108 [message #544926 is a reply to message #544814] Sat, 25 February 2012 00:28 Go to previous messageGo to next message
ranamirfan
Messages: 529
Registered: January 2006
Location: Pakistan / Saudi Arabia
Senior Member

Please read this post it'll help you.

http://www.orafaq.com/forum/t/70841/2/

Regards,
Irfan
Re: rep-0108 [message #545014 is a reply to message #544926] Sun, 26 February 2012 08:30 Go to previous messageGo to next message
nmd_group
Messages: 15
Registered: February 2012
Location: Dhaka,Bangladesh
Junior Member
I Read all those before, sir.
Could not understand, So i upload my RDF.
This report returns error rep-0108 while going to next which record have no picture.
could you kindly correct my RDF & upload please.
Re: rep-0108 [message #545021 is a reply to message #545014] Sun, 26 February 2012 14:19 Go to previous messageGo to next message
Littlefoot
Messages: 19331
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Which program unit returns REP-0108?
Re: rep-0108 [message #545331 is a reply to message #545021] Tue, 28 February 2012 07:38 Go to previous messageGo to next message
nmd_group
Messages: 15
Registered: February 2012
Location: Dhaka,Bangladesh
Junior Member
function CF_2Formula return Char is
v varchar2(500);
begin
select picture into v
from consumerappliedform where bookno=:bookno and accno=:accno;
return v;

--IF v IS NULL THEN return 'H:\Billing\NMD\Consumer_Picture\no_image.jpg';
exception when no_data_found then return 'H:\Billing\NMD\Consumer_Picture\no_image.jpg';
--end if;
end;
Re: rep-0108 [message #545359 is a reply to message #545331] Tue, 28 February 2012 15:04 Go to previous messageGo to next message
Littlefoot
Messages: 19331
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
So, does the no_image.jpg file exist in that directory? Where is the directory, anyway? Your own PC or application server?

Try to use such a code:
function CF_2Formula return Char is
  v varchar2(500);
begin
  select picture 
  into v
  from consumerappliedform 
  where bookno = :bookno 
    and accno = :accno;
    
  srw.message(1, 'After SELECT PICTURE');

  return v;

exception 
  when no_data_found then
    srw.message(2, 'Exception - NO DATA FOUND');
    return 'H:\Billing\NMD\Consumer_Picture\no_image.jpg';
end;

It will display an alert showing you where the execution really is (and which statement raised an error).
Re: rep-0108 [message #545456 is a reply to message #545359] Wed, 29 February 2012 09:40 Go to previous messageGo to next message
nmd_group
Messages: 15
Registered: February 2012
Location: Dhaka,Bangladesh
Junior Member
no_image is on my own pc. I am testing it.
all records have a picture path on consumerappliedform table,column name photo.
if any consumers picture is not available on( H:\Billing\NMD\Consumer_Picture)folder ,the reports show no_image.jpg for all consumer.
Re: rep-0108 [message #545460 is a reply to message #545456] Wed, 29 February 2012 09:47 Go to previous messageGo to next message
nmd_group
Messages: 15
Registered: February 2012
Location: Dhaka,Bangladesh
Junior Member
I tried your code.
I dont want to see any message,because no_image.jpg will tell me that which consumer dont have picture.
just need to run the report and showing picture which are available.
Re: rep-0108 [message #545487 is a reply to message #545460] Wed, 29 February 2012 14:09 Go to previous messageGo to next message
Littlefoot
Messages: 19331
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
On a second thought: your SELECT most probably won't return NO-DATA-FOUND so EXCEPTION handler was in vain. The fact is, PICTURE column might be NULL and that's what a function returns - nothing.

If that's so, how about this:
function CF_2Formula return Char is
  v varchar2(500);
begin
  select nvl(picture, ''H:\Billing\NMD\Consumer_Picture\no_image.jpg')
  into v
  from consumerappliedform 
  where bookno = :bookno 
    and accno = :accno;

  return (v);
end;


As of the messages - of course you don't want to see them once you fix the problem. These were just my attempt to help (not very successful, though).
old discuss bul unsolved [message #563946 is a reply to message #545487] Sat, 18 August 2012 13:10 Go to previous message
nmd_group
Messages: 15
Registered: February 2012
Location: Dhaka,Bangladesh
Junior Member
This is an old discuss but actually many others like me didn't get any solution, till now.
So kindly have a look please.

Database have 3 columns bookno(number),accno (number),picture(varchar2)
-------------------------------------------------------------------------
Bookno Accno Picture
514 1000 D:\Consumer_picture\514_1000.jpg
514 1001 D:\Consumer_picture\514_1001.jpg
514 1002 D:\Consumer_picture\514_1002.jpg
514 1003 D:\Consumer_picture\514_1003.jpg
514 1004 D:\Consumer_picture\514_1004.jpg
----------------------------------------------------------------------------------

Report have three fields bookno,accno,picture.
514_1001.jpg is not available on the location (D:\Consumer_picture\514_1001.jpg) deleted or was not available

How to run the report showing with available picture without error (rep-0108).
Please test,check all page of the report can make preview or not....and then suggest pls
pls no hypotheses

Upload RDF For me Please.
  • Attachment: EXplain.txt
    (Size: 0.96KB, Downloaded 53 times)
Previous Topic: frames/borders do not print when empty
Next Topic: Detail and Summary in One report (2 merged)
Goto Forum:
  


Current Time: Wed Jul 30 03:00:23 CDT 2014

Total time taken to generate the page: 0.11449 seconds