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.
Solved! Go to Solution.
There is no built-in way to get line numbers in a report.
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.
User | Count |
---|---|
43 | |
30 | |
24 | |
23 | |
13 |