Add row number in Report

(0) Share

Report

Posted on by pawar.rajendra88@gm...

172

Hi All,

I have create the report where I want serial number for each row. I have used the rowNumber(nothing) function but row number not coming in series. Can any one suggest?

*This post is locked for comments

I have the same question (0)

All responses (4)

Answers (0)

Suggested answer

Suresh Kulla 50,243 Super User 2025 Season 2 on at

Like (0)

Report

IF you are adding that to a group you need to use the GroupName instead of Nothing, or you can add an integer on NAV side and increment it OnafterGetRecord of the dataitem and use that integer as column or create a function in Report using VB and call that function

Was this reply helpful? Yes No
RockwithNav 8,637 Super User 2025 Season 2 on at

Like (0)

Report

Hey Pawar,

RowNumber("Nothing") only works if you have a straight forward Report with no grouping or a grouping with a very simple design. If you want to want to add serial number then there are two ways either you do it via passing the exact group name based on which you want the Serial No increment or else easiest way is to write the code on Data Item triggers for the increment with the logic and put it on the Dataset and then pass it to the Visual studio.

Thanks

Blog - rockwithnav.wordpress.com

Was this reply helpful? Yes No
Suggested answer

pawar.rajendra88@gm... 172 on at

Like (1)

Report

Thanks all.

I used the code on report properties.

Dim private count as integer = 0

Dim private iniRow as integer = 0

Dim private iniGrp as Object = ""

Public function MatrixRow(Byval rowNum as integer,Byval rowGrp as Object) as integer

if iniGrp = "" then

iniGrp = rowGrp

end if

if rowGrp <> iniGrp then

iniRow = 0

count = 0

iniGrp = rowGrp

end if

if iniRow = 0 then

iniRow = rowNum

end if

if rowNum = iniRow then

count = 0

end if

count = count + 1

Return count

End function

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi . Thanks for the code above . It works but it does not resets the row numbers for next page.Can you please suggest how to reset row numbers for each page.

Was this reply helpful? Yes No