OraFAQ Forum: Reports & Discoverer

Home » Developer & Programmer » Reports & Discoverer » rdf report (oracle 6i)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

rdf report [message #611212]

Sun, 30 March 2014 08:45

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.

Report message to a moderator

Re: rdf report [message #611220 is a reply to message #611212]

Sun, 30 March 2014 15:13

Littlefoot
Messages: 21823
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.

Report message to a moderator

Re: rdf report [message #611248 is a reply to message #611220]

Mon, 31 March 2014 06:13

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.

Report message to a moderator