I'm using it at the end of the report, and it is a total of the distinct headers.
James E Harvey Hanover Shoe Farms, Inc. M.I.S./Corresponding Officer Off: 717-637-8931 fax: 717-637-6766 email: [EMAIL PROTECTED] -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Stephen Russell Sent: Tuesday, December 09, 2008 2:50 PM To: ProFox Email List Subject: Re: Counting groups in report designer On Tue, Dec 9, 2008 at 6:31 AM, Jim Harvey <[EMAIL PROTECTED]> wrote: > Yes, I'm trying to get the count of the group headers (the number of > distinct groups in the resultant cursor created by the select statement). ------------------ do you need the total in the header or in the footer? Customer: ABC Total Invoices 8 inv 1234 inv 1344 or in the footer? Customer ABC inv 1234 inv 1344 ......... --------------------------------------------------------------------------- Total Invoices 8 Cathy has given the way to get the total to a var and use it in your footer. If you need the total in the Header of the group like a treeview type of pres, -- Stephen Russell Sr. Production Systems Programmer Mimeo.com Memphis TN 901.246-0159 [excessive quoting removed by server] _______________________________________________ Post Messages to: ProFox@leafe.com 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.
