number sereis

hi to all

i want the number series as ssuch when a report is executed it should display

s.no invoice

1 0000001

1 0000002

1 0000003

when it is second time executed

2 0000004

2 0000005

2 0000006

like this

how to get this series

thanks in advance

kiran kumar