Ranking On Reports

The solution is to build this report using a Summary Report instead of a Table Report.  Include a field which is called Ranking, which is a formula field of a formula of 1, and show it as a running total down the report.

That I don't understand Mark.  In a summary report, can I show multiple fields of the same record?  Example, I have the players name, their score for each hole (18 fields) possibly their front 9, back 9 totals and gross score? and then sort based on their gross score and individual hole scores (to break ties via retrogression)?

Yes you can do this with script:

Counting Daisy Petals
https://haversineconsulting.quickbase.com/db/bj2vba44z

The default report shows the image onload field [Index] as empty:

Default Report
https://haversineconsulting.quickbase.com/db/bj2vba46e?a=td

But on the List All report the image onload field [Index] is dynamically filled in:

List All
https://haversineconsulting.quickbase.com/db/bj2vba46e?a=q&qid=1

Normally the image onload field is named [-] but since we only want it to show up on reports it is used as the column header we named it [Index].

Pastie Database
https://haversineconsulting.quickbase.com/db/bgcwm2m4g?a=dr&rid=393


Notes:

(1) this is a very green solution as we recycle the space taken up by the image onload field to display actual index data:

[iol] & "module.js" & [/iol]
&
"<span class="QBU_Count"></span>

(2) Note that Index is not saved in the table as it will change depending on which report is displayed. Compare the List All report to this one focusing on the delta and epsilon records:

Contains Letter "l"
https://haversineconsulting.quickbase.com/db/bj2vba46e?a=q&qid=5

I will look back on my emails with you.  At the time I did believe it was possible to do.

Way way way, above my expertise.

look at tis link too  https://quickbase-community.intuit.com/questions/985608-auto-numbering-using-caluclated-report-column?jump_to=comment_2205946

Nonsense. I will do it for you if you want and it will take 10 minutes.

Your notes on me must be extensive Mark....  I actually did query who I thought was a Quickbase staff a while back about the same issue, because I wanted to know why in a report, you couldn't build a counter as a calculated field (for goodness sake, it was one of the first thing we did as kids learning to program in basic) and she agreed it would be a great feature, but could not be done as a calculated field.

It can only be done with script and script can do everything!

Yup, same issue I am trying to solve, and find it funny that you still have that particular issue noted (and yes, I am still angry at the world).  I re-read your thought about devising fields to manage "hole to date scores" to sort and I guess you thought was this would create a ranking within the table? versus just letting the report break ties, sort and report?  But even if we did devise the hole to date scenario, how do we create a dynamic ranking?  Plus it would rank all records in the field against one another, when a event may have several divisions, each requiring its own ranked report?  (You must get tired of me ... )