Interested to Buy Any Domain ? << Click Here >> for more details...
To display the page no. for each page on a report what would
be the source & logical page no. or & of physical page no.?
- 2 Answers
- 6227 Views
- I also Faced
- E-Mail Answers
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
Can any one send me oracle form and reports tutorials from which i may get help.contact me on my mail cse_kashif@hotmail.com.
Explain the various types of oracle report?
Is it possible to have multiple layouts in a report?
What do you understand by lov and how can it be used?
what is the difference between call_form, new_form and open_form?
i want to print the employee details on department wise with group above report with the fields DEPTNO------group above ENAME ------ SAL-------- COMM------ I WANT OUTPUT LIKE THIS ---------------------------------------------------------- 1)FIRST DEPTNO=10 EMPLOYEES DISPLAYED IN FIRST PAGE AND DEPTNO=20 EMPLOYEES DISPLAYED IN 2ND PAGE WHAT I HAVE TO DO OUTPUT ------- --FIRST_PAGE ----------- DEPTNO:10 ENAME SAL COMM KING 5000 A 2000 2222 ---- =- -- SECONDPAGE DEPTNO:20 ENAME SAL COMM MILLER 220 22 D 45 23 -- - - LIKE THE ABOVE PROCDURE REPORTS HOW MANY DEPARTMENTS ARE EXISITING IN EMP TABLE
all steps of bitmap report?
in after report trigger if you don't write Srw.user_exit(Fnd_user exit) what it will do it will stop report execution or it will just not free the memory
if u want to delete all these detail block etc what will happen in form
List the different types of columns in oracle reports.
What is a canvas in oracle forms?
Name the different triggers supported by oracle reports and their firing order.
how to use buttons,check boxes in paper layout,paper design and paper parameter form in oracle report developer 10g
can you convert or reverse engineer a fmx back to a fmb file?
Explain master-detail relationship with some examples.
