Rampraas

 Profile Answers by Rampraas Questions by Rampraas

• Jun 8th, 2008

 

Dear anishajain,

Define a Summary Column in Data Model with source of any driving column. Add a boilerplate text with "NO Records Found".

Defin code in Format trigger for the same as follows

function B_TEXT FormatTrigger return boolean is
begin
  if v_rec_count is not null then
  return (TRUE);
else
return(FALSE);
end if;
end;

Compile the Report and run it if its standalone report(if its Apps Registered Report, copy the rdf into proper TOP and submit the request).

if the Query fetches 0 records, "No Records Found" messages will be displayed otherwise Output will be displayed.

Your Problem will be solved...

-Ramprasad Korrapati