ordinal additional column only at the report level

0

Hi Radek,

I have a sample solution for a calculated column that will return a ordinal number, but it is not perfect (it works in most cases, but it has its problems).

1) You need to add a calculated column of decimal number type on the report.
2) Enter "ROW_NUMBER() OVER (ORDER BY (select null))" as the formula.
3) Set "Number of decimal places" to 0

In this solution, this column should always number all rows from 1, no matter what the report returns.
Unfortunately, you cannot filter values after this column - the report will return an error.

I hope this solves your problem.
Regards.

Ok thanks, it works, limited to filtering, but works.
Is it possible to disable filtering on this new column?

Hi Radek,

I'm glad that the solution worked. At the moment there is no way to disable filtering on a column.
It is possible that in the future there will be such an option.

Regards.