Jim Harvey wrote: > I'm using it at the end of the report, and it is a total of the distinct > headers. > > > -----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). >> > ------------------
If I understand you correctly, you simply need to create a Report Variable in the Report, set the calculation type to COUNT, and for your purposes, reset the value based on report. Set the value to store to one, then initialize it (I can never remember if it's to zero or one, but a few seconds experimentation will show you.) _______________________________________________ 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.