At 03:51 PM 6/20/2008 +1200, Sytze de Boer wrote: >In my application, client can choose a raft of things to print on a report >He wants the ability to SORT the report on 7 different criteria >So far no problem > >How do I sub total on the report without creating 7 different reports >(FRX/FRT) >The subtotal needs nothng more than a straight line
I suggest looking into the "Group by" feature of the Report Designer. I'm not sure if that directly addresses your issue, but you can define groups based on all kinds of criteria, from a simple field (e.g. group all "A's", "B's", etc, or on a complex criteria - like IIF(MOD(recno()+1, 41)=0, 1, 2)....). Then, then you can define your report variables to sum values in the groups and reset when group changes, etc. Place those variables in the group footer, and so on -Charlie _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
