To display the page no. for each page on a report what would
be the source & logical page no. or & of physical page no.?

Answer Posted / sudipta santra

This is the way how to display the page number.

SRW.GET_PAGE_NUM (page_num);

Description: This Function returns the current page number.
This is useful when you want to use the page number in the
field's Format Trigger property.
Syntax:
SRW.GET_PAGE_NUM (page_num);
Parameters:
page_num: Is the variable in which you want to place the
current page number.
Returns: The current page number variable into the boiler
plate text item in the report.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what is tripstop report?

1352


how do u place it in required folder

1470


Have you come across the error ?Failed while printing ?. Why it is happened and How to solve that?

1546


all steps of bitmap report?

1906


Can we invoke one form from another in a multi-forms application?

631






What is an oracle report?

599


HI Friends I m new dev(forms & report). can anyone tell me how we upload a document on form 11g.??

1089


List out the oracle forms configuration files?

558


what are bind variables?

589


in user parameter property we have list of values.can we write select query for binding? for example:: select empno from emp where deptno=:deptnum :deptnum is first parameter it displays distinct dept nos. if i do like this it is giving error:: bind variables are not allowed in the select statement

1287


why the Ctl file u put only in bin folder why not in other folder

1594


In oracle forms report, what is the maximum length of record group column? What are the different types of record groups?

808


hi,dis is Shasi.I'm searhing on cognos.1 want realtime scenarios with solutions.persons having hands on experience in real time plz help me out.and iwant one project with explanation please help me...

1661


What is an SQL FORMS ?

2306


what is a package n what r the packages availbla in report

1606