Row Counting from second or third line

[nizam_babayev]

Hi dear colleagues , My report starts counting rows from 3-rd , how i can fix it? maybe with some formula?

Thanks in advance !

[DellSC]

Are you suppressing any sections or data?

[nizam_babayev]

Yes, i have 2 suppressed sections of details but, they do not affect anything

[DellSC · Accepted solution]

If RecordNumber doesn't work, you could configure a running total that does a distinct count of "Belegnr." and only evaluates if there is a non-null, non-empty value for that field. Put that on the report and it should increment for every row, assuming that Belegnr is unique for every record you're displaying.

-Dell

[ThorstenHoefer]

Hi Nizam,

to determine the row number in HANA, you can use sql like this:

select ROW_NUMBER() OVER (ORDER BY table_name ) as no, table_name  from tables

[Mazzucco]

Good afternoon,

What is your "LINE" field? Is it the LineNum of the document in question? Normally it works correctly, if you run this report query directly in the database, how does it return?

[nizam_babayev]

this report not based on query , this report based on xml (Template of CR - Converted from PLD )

, and here it has 2 rows without any data , but they are not visible. and it starts to calculate row number from 3-rd line

[Mazzucco]

Okay, you can try to create a formula with the code "RecordNumber" and put it in your report to check if it starts counting correctly.