Answer / guest

& physical page no.

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.

List system variables available in forms 4.0, and not available in forms ?

1 Answers  

---

Explain how can you use the same lov for 2 columns?

0 Answers  

---

What triggers are associated with the radio group?

1 Answers  

---

What is the difference between formula column and place holder?

3 Answers  

---

What is the sequence the Report triggers will fires while running a report ?

1 Answers   FCS, GE,

---

what are difference between post database commit and post-form commit?

2 Answers  

---

What is a canvas-view?

1 Answers  

---

Please tell me what is wrong in the below query: (Very Urgent) ================================================= function BeforePForm return boolean is begin if :from_invoice_date is null OR :to_invoice_date is null then aiv.PERIOD_NMAE:=:gl_period elsif :gl_period is null then aiv.INVOICE_DATE between :from_invoice_date and :to_invoice_date end if; return (TRUE); end;

2 Answers   TCS,

---

When is PRE-QUERY trigger executed ?

3 Answers  

---

What is lexical reference?How can it be created?

1 Answers  

---

What is a Trigger ?

1 Answers  

---

HI in report builder am creating paramters.for that i have taken emp table from scott user . in deptnum am displaying distinct deptno.if i select dept 10 ,empnum drop down should display empno's of deptno 10. .if i select dept 20 ,empnum drop down should display empno's of deptno 20.for this wat i have to do.

2 Answers  

---