How to generate Sequence Number for all the Records in SSRS Report - SQL Server Reporting Services(SSRS) Interview Questions and Answers

You can use RowNumber function to do that. Add a new Empty Column to your tablix and then click on Cell and go to Expressions and write expressions as shown below.


Notice that I have used "DataSet1", that is the scope. That means we would like to generate sequence number or row number for all the records in our Dataset.

If you want to start a new row number sequence for your each group, you can provide Group Name in your scope.

How to use RowNumber Function in SSRS Report - SSRS Interview Questions and Answers

You can see the sequence number is generated for our all the records in our SSRS Report.


  1. Soviet-style five-year planning application does not seem to fit, the best approach is a new process of electronic marketing strategy is a continuous improvement. Check fee (2002) pointed out that e-commerce or e-marketing strategy process models tend to agree with the following features: Leadgeneration

  2. Excellent .. Amazing .. I’ll bookmark your blog and take the feeds also…I’m happy to find so many useful info here in the post, we need work out more techniques in this regard, thanks for sharing. TheFitBay