Sorting of Records in A Summary Report
Is there an alternative way to sort records in a summary report rather than resorting to additional formula field. As an example my depts are currently alpha sorted and I need a certain order.
Forum Discussion
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]:
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.
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.