Order / Rank results

[fatherjack]

Hi,

i want to create a report so that a list of the top 30 records are returned to the report user. In the report i want to have the records position in the list shown (ie the first row should have 1. and the second should be 2. right on down to the 30th having 30.)

how do i achieve this please?


many thanks
FatherJack

[fatherjack]

OK, much hunting on microsoft site gets two functions:

RunningValue
This accepts 3 parameters (column to use, action to take, scope to 'run' over)
so ... a textbox on a report with an expression of this:
RunningValue(mysalevalue,sum,Nothing)
will give a running sum of the mysalesvalue column over the whole report (odd why Nothing is the whole report but hey!)

however (this is what i was actually after ...)

RowNumber
This accepts 1 parameter (scope to 'run' over)
so ... a textbox on a report with an expression of this:
RowNumber(Nothing)
will give a row number for every row in the whole report (odd why Nothing is the whole report ... )


sorted