Add row number in pdf report

[Eric_Daniel_Mar]

Hello. I have the following question, if you could help me please. In a report created with BOT, when printing a table with data from the query, I want the column number to be printed in the Item column. This number should increase as the rows increase depending on the type of query.

Basically, the report reads the row number and prints it on each one.

[Aurelien]

Hi @Eric_Daniel_Martinez

Welcome to the community !

This doesn’t work ?
[_ROWNUMBER]
or
[_THISROW].[_ROWNUMBER]

[Eric_Daniel_Mar]

Hi @Aurelien Thanks your answer. But, [_ROWNUMBER] prints the number of the related table, and [_THISROW].[_ROWNUMBER] that of the main table.
The report is built by taking elements from each related table, and what I want is that in this new table, each row has a number.

Here is a screenshot of my table

[mauandre]

I had the same issue for an assistance record. the way i tinkered was creating a VIRTUAL COLUMN which stores a count number for every condicion I needed (event, date) and then print that virtual column in the template

[j62]

Thanks! This worked for me to create visual line sequence by expense report id for pdf report
=1+count(filter("T3 Tx Header",and(([createdatetime]<[_thisrow].[createdatetime]),([expensereportid]=[_THISROW].[expensereportid]))))

[Steve · Accepted solution]

There is no built-in way to get line numbers in a report.

[Eric_Daniel_Mar]

Thanks! I stop looking then.

[Justin_Walker]

Has there been any update to this?