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
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.
how report can be generated if we have the database designed in oracle 10g?
What are the Features of Forms 6i over 4.5? What are the Features of Forms 10g? What are the Features of Reports 6i? What are the Features of Reports 10g ?
Explain the various types of oracle report?
can you convert or reverse engineer a fmx back to a fmb file?
a text item is there what r the different types of triggers associated with it
Explain master-detail relationship with some examples.
what is oracle forms?
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
what is the difference between call_form, new_form and open_form?
where do u put the report file
how to use buttons,check boxes in paper layout,paper design and paper parameter form in oracle report developer 10g
if u want to delete all these detail block etc what will happen in form
How to create Drill down report?
What do we mean by record group in oracle forms?