we can get the sequence number directly in SSRS report directly by below code in text box expression. it's basically depends on row number so you can get it from expression - Common Function -Miscellaneous - row Number.
=RowNumber(Nothing)
The challange to use this expression is when we will use grouping in same table. Sequesnce of the number can be disturb by grouping. We can handle it by below code.
=Runningvalue(Fields!Name.value,countdistinct,"Dataset1")
** Here field name is the actual field which we are using in grouping with database name.
=RowNumber(Nothing)
The challange to use this expression is when we will use grouping in same table. Sequesnce of the number can be disturb by grouping. We can handle it by below code.
=Runningvalue(Fields!Name.value,countdistinct,"Dataset1")
** Here field name is the actual field which we are using in grouping with database name.
No comments:
Post a Comment