Question Re: Row Counting from second or third line in Technology Q&A

Row Counting from second or third line

nizam_babayev — Tue, 28 Jun 2022 15:05:49 GMT

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

Thanks in advance !

Re: Row Counting from second or third line

Mazzucco — Tue, 28 Jun 2022 16:30:23 GMT

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?

Re: Row Counting from second or third line

DellSC — Tue, 28 Jun 2022 17:59:16 GMT

Are you suppressing any sections or data?

Re: Row Counting from second or third line

nizam_babayev — Tue, 28 Jun 2022 18:15:01 GMT

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

Re: Row Counting from second or third line

nizam_babayev — Tue, 28 Jun 2022 18:18:01 GMT

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

Re: Row Counting from second or third line

Mazzucco — Tue, 28 Jun 2022 18:32:19 GMT

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.

Re: Row Counting from second or third line

DellSC — Tue, 28 Jun 2022 21:41:32 GMT

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

Re: Row Counting from second or third line

ThorstenHoefer — Wed, 29 Jun 2022 06:23:08 GMT

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