Serial number on detail level can be achieved by
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")
OR if nothing to used and need normal number count as 1,2,3,4....n used:
=RowNumber(nothing);
Serial Number in Report Group SSRS Dynamics Ax 2012
=Runningvalue(Fields!FieldName.Value,countdistinct,”Dataset1″)
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")
OR if nothing to used and need normal number count as 1,2,3,4....n used:
=RowNumber(nothing);
Serial Number in Report Group SSRS Dynamics Ax 2012
But serial number shown on Group level is tricky because RowNumber not works there. For example in above mention scenario, Client wants serial number on Customer Group instead of Customer at detail level.
I used following single line SSRS expression helps me to achieve this.=Runningvalue(Fields!FieldName.Value,countdistinct,”Dataset1″)
No comments:
Post a Comment