I have developed a report in Developer 6i.The report output is like that,-
There are 100 units and each unit contains numbers of employees.Now I have developed the report in Group above format to get the output like the all employees details corrosponding to that unit code will come under that unit code.So, employee details will be a repeating group under unit code repeating group.
Now, I want to create a serial no which will give like starting from 1 to no. of employees in that group and again reset at next unit code.This will continue until the last employee of the last group comes.
I have tried with rownum but the row num is comming randomly.