Group methods

Feb 21, 2006 4 Replies

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

groupmethodNone groupmethodSum groupmethodPercent groupmethodCount groupmethodAverage groupmethodMax groupmethodMin

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:

use groupmethodMAX for the text fields.

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:

Join the Discussion

Have something to add? Share your thoughts — no account required.

Didn't find your answer?

Ask the community — no account required