Skip to main content
Question

Sort a report inserted in an exact form after being grouped.


I have a report inserted in an exact form which is grouped by the field [index][11]. But once it is grouped, I need it sorted by the date [filed][13]. The grouping works [11], but the subsequent sort of the grouped items [13] does not. Help!

~=qdb.GetURL("bmm6tc3xp",
"API_GenResultsTable^query={'14'.EX.'"+ field["Record
ID#"]+"'}^clist=7.8.9.13.10^options=nvw.ned.phd.nfg.sortorder-A.groupby-V^slist=11.sortorder-A^slist=13^ts="+
new Date().getTime());~
This topic has been closed for replies.

KeithJusas
Forum|alt.badge.img+7
try adding 13 to your slist
slist=11.13
then add either A or D to the sortorder A-ascending D-descending
sortorder-AA

KeithJusas
Forum|alt.badge.img+7
and when you want more advanced grouping capabilities try this using Exact Forms Plus
https://juicedtech.quickbase.com/db/b...
just click the EF+ Grouping tab and then try the 3 buttons to see some ways to group

Thanks.  It worked.