Add a new column as 'S.No.' in SSRS report. Open Expression window of the column and enter below text:
=RowNumber("<Datasetname>")
E.g., If my dataset name is "MyData"
then the command will be:
=RowNumber("MyData")
=RowNumber("<Datasetname>")
E.g., If my dataset name is "MyData"
then the command will be:
=RowNumber("MyData")
Thanks dude...It works...
ReplyDeleteHi
ReplyDeleteMy requirement is.. If Previous Row (Consumer Name) is same don't repeat SrlNo.
Srl No. | Consumer Name | Testing Date | Sample No.
============================================================
1. ABCD Sarkar 10-Jan-2013 Smp/10/11
15-Jan-2013 Smp/11/11
------------------------------------------------------------
2. PQRS Ghosh 10-Jan-2013 Smp/12/11
------------------------------------------------------------
Thanks - Jayanta
drgdfhgfhg
ReplyDeleteIt is working. Thanks for sharing...
ReplyDeleteGood please review my article also.
ReplyDeletehttp://www.microsoft-sql-ssis.com/2016/07/how-to-show-serial-number-in-reports.html
I am getting 1 3 4 6 7
ReplyDelete2 and 5 missing can u help me out