1. Home
  2. Point-Of-Sale Software
  3. Group methods

Group methods

I?m writing some custom reports for RMS Headquarters, and I?m trying to figure out what group methods are available. The most common ones I see are groupmethodNone - no group totals. Field will appear blank in the group header. groupmethodSum ? summary of group totals. Field must be a numeric.

What other group method options are available?

I have some fields which I want to appear in my group header, but do not necessarily need any grouping functions performed on them.

Example: A customer sales report Fields include customer account number, name, city, state, transaction number, transaction date, transaction total Group by account number Transaction total should be summed in the group header However, I also want the customer?s name and address in the group header.

What sort of grouping method can I put on the Customer.Name, Customer.City, and Customer.State fields in my .QRP file to have them appear in my group header for Customer.AccountNumber?

Bill Yater The Worth Collection, Ltd.

10585 N. Meridian St Suite 240 Indianapolis, IN 46290 snipped-for-privacy@worthltd.com
Reply to
Bill Yater
Loading thread data ...

groupmethodNone groupmethodSum groupmethodPercent groupmethodCount groupmethodAverage groupmethodMax groupmethodMin

Rob

Reply to
Rob

Rob,

Thanks for the quick response. These group methods will be helpful in future reports.

However, I don't think they will give me the desired result.

My customer name and state are character fields. These group methods are expecting numeric data, so they will either put 0 in the gorup header, or in the case of a ZIP code, will do an intrinsic converstion to a numeric and act accordingly.

All I'm trying to do is to take the character data for my customer and put in my group header, so each group header contains one grouping field and several non-grouping fields. I'd like to avoid writing this in Crystal Reports, since I am not familiar with that tool.

Bill Yater

"Rob" wrote:

Reply to
Bill Yater

use groupmethodMAX for the text fields.

Reply to
Glenn Adams [MVP - Retail Mgmt]

Nope. When I use GroupMethodMax, the field in the group method just displays

0 (if I am grouping by that column), or displays nothing at all.

Bill Yater

"Glenn Adams [MVP - Retail Mgmt]" wrote:

Reply to
Bill Yater

BeanSmart website is not affiliated with any of the manufacturers or service providers discussed here. All logos and trade names are the property of their respective owners.