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.
Hi @Eric_Daniel_Martinez
Welcome to the community !
This doesn’t work ?
[_ROWNUMBER]
or
[_THISROW].[_ROWNUMBER]
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
There is no built-in way to get line numbers in a report.
Thanks! I stop looking then.
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
Has there been any update to this?
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]))))
