Group by Text Field

rbuser

I want to group a report by a payment type but I need to set a
variable with a value based on the payment type, in other words if
payment type is AP then I set the variable to 'AP / DRAFT' and if the
first two characters of payment type are CK then I set the variable to
'CHECK' and I want to group the report on this variable. This
variaible will change throughout the report so is there an easy way to
group this way?

David Looney

rbuser

Create a group report over the field as usual and in the OnPrint event of
the field change the value to the one you want displayed.

digitalmetaphors

Usually, to create a group based on a TppVariable, you won't want to use the
OnCalc event, but rather, the OnGetText event should be used to set the
value of the variable.


Cheers,

Jim Bennett
Digital Metaphors