Cathy, thank you I did everything you said (option 2) except EVALUATE(cSortExpr) I just had cSortExpr, without the "Evaluate"
Thank you again By the way, did you spot my earlier question to do with XFRX and maximnising the screen. I had hopes you might have steered me. On Sat, Jun 21, 2008 at 12:15 AM, Cathy Pountney <[EMAIL PROTECTED]> wrote: > 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.
