Show Row Number for each group in RDLC Report

Today I need to show row number for each group in RDLC Report of Dynamics NAV 2015. I tried to search in Google and found the function “RowNumber” and “RunningValue”. But, both of them did not work for me. So, I try to make my own function to achieve my goal to show row number for each group like below.

Show Row Number in RDLC Report

I want to share my finding to all of you.

  • Go to Layout of report.
  • In “Report Properties”, click “Code”.
  • In “Code”, type code like below to show row number for each group in your report.
Dim IntCountGroup1 as integer = 0
Dim IntCountGroup2 as integer = 0

Public Function GetRowNoGroup1()
 IntCountGroup1 = IntCountGroup1 + 1
 Return IntCountGroup1
End Function

Public Function GetRowNoGroup2()
 IntCountGroup2 = IntCountGroup2 + 1
 Return IntCountGroup2
End Function
  • In cell of group 1 in your tablix report, use expression like below.
=Code.GetRowNoGroup1()

  • In cell of group 2 in your tablix report, use expression like below.
=Code.GetRowNoGroup2()

I hope it helps you to show row number for each group in your RDLC Report.

Please correct me if I am wrong.

God bless you all 🙂

65 total views, 4 views today

Leave a Reply

%d bloggers like this: