Home » Developer & Programmer » Reports & Discoverer » rdf report (oracle 6i)
rdf report [message #611212] Sun, 30 March 2014 08:45 Go to next message
IRFANMBAIG
Messages: 14
Registered: August 2013
Location: uae
Junior Member

Dear All,

I made a rdf report with columns( item code,item image,item description etc),here image is coming through a link,If there is no image for any item code report showing error,output cannot be displayed.
please suggest can I run a report even image is not present.
Re: rdf report [message #611220 is a reply to message #611212] Sun, 30 March 2014 15:13 Go to previous messageGo to next message
Littlefoot
Messages: 21806
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
How exactly do you retrieve image into the report? Is it within report's query? Or, is it a (formula?) column? Would exception handling, such as
when no_data_found then 
  return (null);
do any good?

Or, would maybe image's Format Trigger help, such as
  return (:image_link is not null);
which returns FALSE if :IMAGE_LINK column is NULL?

Anyway: some more info might help solving the problem.
Re: rdf report [message #611248 is a reply to message #611220] Mon, 31 March 2014 06:13 Go to previous messageGo to next message
IRFANMBAIG
Messages: 14
Registered: August 2013
Location: uae
Junior Member

query for image there is a flexifield in table abc from that flexifield image is link

ex: select itemcode,itemdesc,itemqty,image from table abc,if there is no image in flexifield report generates an output with message saying no image.
Re: rdf report [message #611279 is a reply to message #611248] Tue, 01 April 2014 02:02 Go to previous messageGo to next message
Littlefoot
Messages: 21806
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
So, did you try any of two options I suggested?
Re: rdf report [message #611283 is a reply to message #611279] Tue, 01 April 2014 02:14 Go to previous message
IRFANMBAIG
Messages: 14
Registered: August 2013
Location: uae
Junior Member

Dear ,

I did but not working ,Thanks for your support.
Previous Topic: rep-0069 internal error in oracle reports and rep-57054
Next Topic: Order by Clause
Goto Forum:
  


Current Time: Thu Mar 28 10:52:12 CDT 2024