Yes descending i s in v9.0. Except without pre-computing the total in a view/table the report has no way of ordering according the total.
Jim Bentley American Celiac Society [email protected] tel: 1-504-737-3293 ________________________________ From: jan johansen <[email protected]> To: RBASE-L Mailing List <[email protected]> Sent: Wed, January 13, 2010 5:26:23 PM Subject: [RBASE-L] - Re: ORDER BY (A SubTotal Report Break) Matthew, Descending Breaks are a new feature introduced in V9. Jan -----Original >Message----- >>From: "Matthew Burke" <[email protected]> >>To: [email protected] (RBASE-L Mailing List) >>Date: Wed, 13 Jan 2010 16:22:46 -0700 >>Subject: [RBASE-L] - ORDER BY (A SubTotal Report Break) > > >Greetings all, > >I’ve created a report containing a single >break. Each break has a sum total in the break footer. >I want to organize the report in such a way that the >sum total is what is ordered in a descending fashion. > >IE > >111 >test111-1 >400 >111 >test111-2 >100 >>111 >test111-3 >50 >111 >Total: >550 > >222 >test222-1 >300 >>222 >test222-2 >400 >222 >Total: >700 > >In this example I want the 222 break to be listed >first because it has the greater total value. > >I’ve thought of doing this with a script, and >creating a temporary table with an added column for a computed total of each >group. >But I’m wondering if there is an easier… >R:Way …to accomplish this >J > >Thanks! > >Matthew Burke > >Pioneer Bank - IT Department >Computer Systems Technician > >575-627-4415 Office > >[email protected] > >3000 N Main >Roswell NM 88201 >
