Discussions

Expand all | Collapse all

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

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

    Posted 04-02-2017 15:49
    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());~


  • 2.  RE: Sort a report inserted in an exact form after being grouped.

    Posted 04-02-2017 19:12
    try adding 13 to your slist
    slist=11.13
    then add either A or D to the sortorder A-ascending D-descending
    sortorder-AA


  • 3.  RE: Sort a report inserted in an exact form after being grouped.

    Posted 04-02-2017 19:20
    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


  • 4.  RE: Sort a report inserted in an exact form after being grouped.

    Posted 04-03-2017 23:36
    Thanks.  It worked.