Home » Developer & Programmer » Reports & Discoverer » Get total pages (Report 6i)
Get total pages [message #396110] Sat, 04 April 2009 00:52 Go to next message
snsiddiqui
Messages: 172
Registered: December 2008
Senior Member
Dear All

How can I get the total number of pages in report6i because I have some values which I want to show according to page number like
If report contain only one page then value display otherwise it should be displayed in page#2.

Re: Get total pages [message #396484 is a reply to message #396110] Mon, 06 April 2009 22:59 Go to previous messageGo to next message
swayamji
Messages: 15
Registered: March 2009
Location: Washington DC
Junior Member
Hi,
in the Report builder one options is there
Paper Layout-->Insert Page Numbers
after creating this field write the format trigger on this filed.

regards
swayam
Re: Get total pages [message #398841 is a reply to message #396484] Sat, 18 April 2009 04:13 Go to previous message
snsiddiqui
Messages: 172
Registered: December 2008
Senior Member
How to use field in report? my code is...

function F_POM_FREIGHT3FormatTrigger return boolean is
val number;
begin
If f_6 > 1 And f_7 = 2 then
return (TRUE);
Else
return (FALSE);
End If;
end;

Field f_6 contains totalphysicalpages and f_7 contains physicalpagenumber.
Previous Topic: Placeholder Column
Next Topic: exporting report to excel from forms 10g
Goto Forum:
  


Current Time: Fri Apr 19 17:53:22 CDT 2024