Change Sort Order

[treed]

Yes works the same way for me. And yes this seems like a bug. This also now works on the date field by changing the field name.
I see a bunch of sortby statements in that section of the JSON, are they for multiple levels of sorting or for sorting the different sections?

[treed]

Yes works the same way for me. And yes this seems like a bug. This also now works on the date field by changing the field name. After getting the report working the way I wanted, I went back into the designer and changed the SQL to see if saving it would overwrite my "hack", it didn't.

I see a bunch of sortby statements in that section of the JSON, are they for multiple levels of sorting or for sorting the different sections?

[kev1n]

I see a bunch of sortby statements in that section of the JSON, are they for multiple levels of sorting or for sorting the different sections?

Multiple groups can be added and each of them can be sorted in either ascending or descending order.

It's well described in the nuBuilder 3 wiki (it's also valid for v4

https://wiki.nubuilder.net/nubuilderv3/ ... Properties

The group properties pop-up will already have the default groups at fixed positions within it. It is possible to add up to 8 extra groups. This allows you to group fields in the details group by other fields. The name of the group must be the name of a field in the database table #TABLE_ID#.

Any groups you add can be sorted in either ascending or descending order. It is possible to establish a hierarchy within groups by using the move group up and move group down buttons.

You can set properties of each section within a group such as: section name, height, background colour, and if it goes to a new page at the end of the section.

If the height of a section within a group is set to 0, then that section is not displayed. This is useful if you only require the header (or footer) of a particular section within a group.

[kev1n]

@Steven: Are you able to reproduce it on your end?

Is that a bug? https://streamable.com/6d9ojf

[treed]

Found some info on this subject in the code section of the forum. It looks like the grouping option does Sorting and Grouping. Setting what the sort option there does allow changing the report sort. And you can sort within a group. https://forums.nubuilder.cloud/viewtopic.php?f=20&t=10396

[vario]

I have the same problem with a report I want to order a group "descending" but the report designer just ignores the change and it always comes back as "ascending". Will there be a fix as I don't want to have to edit the zzzzsys_report table in case I mess it up!

[kev1n]

This should be fixed now.