A young Oracle Expert to help you in learning and solving Oracle related queries!!

Wednesday, June 18, 2014

How to write format trigger on report based on page number

we can decide what to hide and display in report based on the page number:-
function F_4FormatTrigger return boolean is
 pagenum   number;
begin
  srw.get_page_num(pagenum);
  if pagenum = 1  then
    return (TRUE);
  else
    return (FALSE);
  end if;

end;
Posted by Priyanka at 11:31 AM No comments:
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest
Newer Posts Older Posts Home
Subscribe to: Posts (Atom)

Blog Archive

  • ►  2015 (1)
    • ►  April (1)
  • ▼  2014 (8)
    • ►  August (1)
    • ►  July (1)
    • ▼  June (1)
      • How to write format trigger on report based on pag...
    • ►  May (2)
    • ►  April (1)
    • ►  March (1)
    • ►  February (1)
  • ►  2013 (24)
    • ►  November (1)
    • ►  October (3)
    • ►  September (1)
    • ►  July (8)
    • ►  June (3)
    • ►  March (4)
    • ►  February (3)
    • ►  January (1)
  • ►  2012 (6)
    • ►  August (6)

About Me

Priyanka
View my complete profile
Picture Window theme. Powered by Blogger.