select e1.ename, e2.job
from emp e1, emp e2

if page_number = last_page then
   paint(ename, dark red);
end if;

package pkg_page_num is
  p_tpn number;     -- "tpn" stands for "total pages number"
end;

function F_total_pagesFormatTrigger return boolean is
  l_page_num number;
begin
  srw.get_page_num(l_page_num);
  
  pkg_page_num.p_tpn := nvl(pkg_page_num.p_tpn, l_page_num);
  
  return (TRUE);
end;

• create a local variable (l_page_num) which will contain page number
  
• Page number will be retrieved with SRW built-in package and its GET_PAGE_NUM function
  
• Store page number into the package variable.
  NVL function differs from Metalink description; if NVL is not used, total number of pages is wrong and it appears that „page number" is never equal to „total number of pages". I've checked what was going on (using the SRW.MESSAGE), and total number of pages was changing its value when scrolling through report pages, but was never (except for the first report run) correct.
  On the other hand, if a table was used, we'd store „total number of pages" into that table and select MAX value from a table. If that was the case, NVL wouldn't be necessary. Another option might be use of the GREATEST function. Obviously, there are variations to the solution, which is marvelous! It would be a shame if there was none.
  

function F_enameFormatTrigger return boolean is
  l_page_num number;
begin
  srw.get_page_num(l_page_num);
  
  if l_page_num = pkg_page_num.p_tpn then
     srw.set_text_color('darkred');
  end if;
  
  return (TRUE);
end;

• create a local variable (l_page_num) which will contain page number
  
• if it is equal to the „last page number" (which is now stored in the package variable, "pkg_page_num.p_tpn"), do „something" (for example, paint values red)

[EDITED by LF: modified topic title. The original was "Oracle Report Developer 6i (urgent Help)"]

congrats.
Thanks for the feedback.

sriram

I HAVE SUCCESSFULLY DONE MY SELF FROM MY PROBLEM