I have these cheat notes
Here is a trick that worked for me.Let's say you have [Name] which is the text you want in the report, but you want to sort it by another field [Name Sort Ordinal]. Create a Formal - Rich Text field [Display] like this and use it instead of [Name]:"<span data-ord='" & [Name Sort Ordinal] & "'>" & [Name] & "</span>"You might need to pad the ordinal with spaces or zeros if you have numbers with more than 9 values etc. because this will be sorted as text, not as numbers.This works because the attribute in the span tag is not displayed, but it will be part of the text that Quick Base sorts for the report, and the attribute comes before the actual display text. Only the text part between the <span></span> tags will actually be displayed.
So the trick would be to contrive a field that sorts correctly, given that you want descending, so you might need to have a zero padded number which ends up being low for near dates and high for old dates.
like
PadLeft(
Todays(AdjustYear(Today(),10) - [my date field]),6,"0")
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com------------------------------
Original Message:
Sent: 03-21-2022 19:28
From: Mike Tamoush
Subject: Sorting a Summary Report
Date field trying to sort descending.
------------------------------
Mike Tamoush
Original Message:
Sent: 03-21-2022 19:22
From: Mark Shnier (YQC)
Subject: Sorting a Summary Report
If you are willing to be a contortionist there might be a way. The summary report is still going to sort alphabetically on the first column. It might be possible to create a field using HTML where the HTML will sort properly but to the naked eye, users will just see words.
So for example if you wanted to start on a numeric field you would have to can drive some heading HTML that would have a correct sort. Is it a numeric field you wanna sort on? Do you wanna sort ascending or descending?
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
Original Message:
Sent: 03-21-2022 17:20
From: Mike Tamoush
Subject: Sorting a Summary Report
Anyone ever come up with a work around for this? Sorting Descending when using the group by columns?
------------------------------
Mike Tamoush
Original Message:
Sent: 07-28-2021 11:51
From: Kevin Gullickson
Subject: Sorting a Summary Report
I have the same question.
------------------------------
Kevin BP
Original Message:
Sent: 07-25-2018 07:50
From: Max Allen
Subject: Sorting a Summary Report
Are there any work-arounds for this?