To display the page no. for each page on a report what would
be the source & logical page no. or & of physical page no.?
Answers were Sorted based on User's Feedback
Answer / 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 |
What is coordination Event?
Can a property clause itself be based on a property clause?
I am using oracle developer suit(form 10g), On used ole2 objects to initialize excel and worksheet and on "BEFORE REPORT" i am printing report heading in excel using OLE2 objects only. if i run report from developer suit report builder it give output in excel normally and what expected but when ever i put same report on server and run report from application it gives error : " Terminated with error : <br> REP-1401 'before report': FATAL pl/sql error occured. ORA-43356; message 43356 not found; Product=RDBMS; facility = ORA." Please reply it is urgent
Can we use GO-BLOCK package in a pre-field trigger ?
Is it possible to disable the parameter from while running the report?
What is the difference between a Function Key Trigger and Key Function Trigger ?
What is AppCore and AppCore2 ?
Name the different triggers supported by oracle reports and their firing order.
Where we can use the placeholder columns?
If the valueset if of type –TABLE then how many tables can we attach in the valueset ?
What is a record Group?
What is the remove on exit property?