You can go about this 2 different ways. #1. If you are building the data before the report, add an extra field to the data called "SortBy" and have it be the data that they chose to sort by. Create a data group on the report using "SortBy" as the expression.
#2. If you are printing from data already created and you don't want to manipulate it, create a variable in your code such as "cSortExpr". Create a data group on the report with an expression of EVALUATE(cSortExpr). For example, say they picked "CustNo" as the field to sort by, do this: Local lcSortExpr lcSortExpr = 'CUSTNO' REPORT FORM MyReport The data group will now "break" on the CustNo field. Cathy Pountney -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Sytze de Boer Sent: Thursday, June 19, 2008 11:51 PM To: [email protected] Subject: VFP9 S/totals on report 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 -- Regards Sytze de Boer Kiss Systems Ph: 64-7-8391670, Mob:021 937611, Skype: kissman2 www.kiss.co.nz --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- [excessive quoting removed by server] _______________________________________________ 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.
