Auto numbering report rows
Hello,
Can a simple incremental row number be added to the report? Regardless of how the report is sorted, I want to see a record number starting from the top of the current sort order. Any help is...
Forum Discussion
Does [Record ID#] suit your need?
------------------------------
Adam Krzyzanek
------------------------------
No, because Record IDs are permanent. I am trying to add a sort order number.
------------------------------
Sam Rozenfeld
------------------------------
This would give you a row number.
var text Query = "{3.LTE.'" & [Record ID#] & "'}";Size(GetRecords($Query))
------------------------------
Allan S
------------------------------- MarkShnier__You
Qrew Legend
I'm pretty sure there's not a way to number rows on a report where the Sort and filters are unknown in advance. There are ways to number rows on the report but we would have to understand the filters and the sort on the report.
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------Any solution would be DOA once users start playing with the report. In theory you could have a formula query that mimics the same filters as your report and ranks it in some fashion with those filters/sort behavior, but then if a user were to apply a dynamic filter or re-sort the report in another format, the values of that column would not re-shuffle since those aren't data binding to the actual row you'd have mis-aligned numbers.
------------------------------
Chayce Duncan
------------------------------
