Hello All,

I'm building a summary report. The break field has 5 values, Cash, Cashier Check, Money Order, Mastercard or Visa. The summary report breaks these values down into a total dollar amount for each. I now would like to add the summary values of Cash, Cashier Check and Money Order, then add the summary values of Mastercard and Visa.

I tried the GetSummary function, but it doesn't get me what I want, or I'm not using it correctly. Any thoughts?

Thanks in advance,

Lisa

Here's one way: Add another calc to the file to determine the Payment Class, "Funds" or "Credit" (there may be better names.)

Payment Class (calculation, text result) =

Case( Payment Type = "Cash" or Payment Type = "Cashier Check" or Payment Type = "Money Order", "Funds",

Payment Type = "Mastercard" or Payment Type = "Visa", "Credit",

"Unspecified" )

Then add a part to the layout "Sub-Summary by Payment Class". Add your Total field to this part, and the Payment Class if needed. Then sort by Payment Class (instead or in addition to your current sort, just make sure this is above the Payment Type criteria in the sort order.)

The GetSummary should work but you will need to use it 4 times for the first sum and 2 times for the second. A sort is required just as for the summary.

It took me awhile to get back to my post. Your script works like a charm. Thanks so much.

Lisa