generate serial_no automatically when report run

[meem77]

• 
  

Hi ,I have a report and there is a 2 table emp(emp_id,person_id),exit_seq(srl_no,person_id)
· I want to make srl_no when I generate a letter report its generate automatically depend by person_id its mean for person_id one srl_no in a day that’s mean when I generate a report for this person_id in same day it must give me same number but in other day take the sequence (max(srl)+1)
· when arrive to year2005 in 1st if jan it must start with 1 that’s mean in 1st of jan in each year start with 1when report run but if 1st Jan in holiday and no body make run for this report it must 1st time in this year start with 1

[meem77]

لاأحد يستطيع الرد على سؤالي ؟؟؟؟؟؟؟؟؟؟؟؟؟

[engahmed383]

to create serial for the report follow this steps

function CF_3Formula return Number is
begin
if R_G_CHEKED1FormatTrigger then
:x:=nvl(:x,0)+1;
end if;
return :x;
end;

R_G_CHEKED1FormatTrigger --- the name of the format tirgger of the repeating frame that contains the serialed data
x ----user

serial.txt