Hi
You can use below text as column in your sql stored procedure to prduce serial no in out put of sql server stored procedure.
ROW_NUMBER() Over (order by id) as SrNo
You need to change your identity columns name instead of "id" column in above syntax.
Now you can use SrNo column in crystal report to show srNo. in report.
Please mark as answer if you will get as you want.
Thanks,
Vipul