Many times we requires the serial number column in Sql Server Reporting Services (SSRS). Here is the solution:-
In ssrs there is a inbuild function : RowNumber(Nothing)
Select your text box and wirte the function "=RowNumber(Nothing)" in Expression popup, it will generate the serial number.
If you requires Group wise serial number Then just add the group name instead of "Nothing". Suppose the group name is "GroupABC" then the expression would be "=RowNumber(GroupABC)".
The above expression can be used for nested data regions, Simple use the name of the data region instead of "Nothing".
With the help of the above expression we can generate numbered rows such as Serial Number Column and also used to insert Page breaks based on number of rows