We have created a quarterly SUTA report that needs to be sent in as a .csv 
file to the state.  We have had no problems generating this data in Report 
Writer using the Payroll Master, Payroll Transaction History, and Payroll 
Check History tables.  However, one requirement of the file is to have a 
column with a Sequence Number that starts at 1 for the first employee and 
increments by 1 for each new employee on each line.

I believe that since the Social Security number is unique on each line, that 
we could somehow use this to number the rows.  Does anyone know if there are 
any functions or ways to create a calculated field to do this?

Thanks!

Take a look to David's article below, he included an example on such case:
http://blogs.msdn.com/b/developingfordynamicsgp/archive/2008/07/21/rw-adding-line-numbers-to-sop-documents-example.aspx
-- 
Regards,
-- 
Mohammad R. Daoud
MVP, MCP, MCBMSP, MCTS, MCBMSS
Mob: +962 - 79 -999 65 85
mohdaoud@gmail.com
http://mohdaoud.blogspot.com/

"djr03" <djr03@discussions.microsoft.com> wrote in message 
news:E2EE7C20-2193-4A56-9443-388F411E6297@microsoft.com...
> We have created a quarterly SUTA report that needs to be sent in as a .csv
> file to the state.  We have had no problems generating this data in Report
> Writer using the Payroll Master, Payroll Transaction History, and Payroll
> Check History tables.  However, one requirement of the file is to have a
> column with a Sequence Number that starts at 1 for the first employee and
> increments by 1 for each new employee on each line.
>
> I believe that since the Social Security number is unique on each line, 
> that
> we could somehow use this to number the rows.  Does anyone know if there 
> are
> any functions or ways to create a calculated field to do this?
>
> Thanks!