Skip to main content
Planview Customer Success Center

How can line count or row number be calculated in report?

QUESTION:
How can line count or row number be calculated in report?
The SQL Count() function does not give the expected result.


ANSWER:
For calculating line numbers, use the ROW_NUMBER function in SQL.

For further information please refer to http://msdn.microsoft.com/en-us/library/ms186734.aspx