Page 2 of 2
Re: Change Sort Order
Posted: Fri Aug 14, 2020 9:04 pm
by 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?
Re: Change Sort Order
Posted: Fri Aug 14, 2020 9:11 pm
by 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?
Re: Change Sort Order
Posted: Fri Aug 14, 2020 9:52 pm
by kev1n
treed wrote:
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.
Re: Change Sort Order
Posted: Mon Aug 17, 2020 6:15 am
by kev1n
@Steven: Are you able to reproduce it on your end?
Is that a bug?
https://streamable.com/6d9ojf
Re: Change Sort Order
Posted: Thu Aug 20, 2020 11:06 pm
by 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
Re: Change Sort Order
Posted: Thu Mar 17, 2022 1:11 pm
by 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!
Re: Change Sort Order
Posted: Wed Mar 29, 2023 8:06 am
by kev1n
This should be fixed now.