Numbering Rows 1

[AtlPayroll]

Is there a way to have a Derived Field sequentially number rows starting at a fixed number, such as 101, and increase by 1 for each row of data displayed?

 

[RSHelp]

Create a Derived field as such

rownum + 100

That will take the rownum of the output and add 100 so your first row will show 101 then 102 etc.

Hope that helps.

 

[RSHelp]

Note, this will only work with an Oracle database.

 

[RSHelp]

If you are using an SQLBase database then use this Macro Derived Field:

Sub row()
r=current() + 100
derivedfield r
End Sub