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