sequentail counter by a group

[eoggb]

i have a report that groups by company name, transaction id and order date. all the data is printed in the deatils. i would like to know how to create a counter that prints in the deatils and reset it self by the order id.


data below:

ACME INC. AKV878 mar-04-06 Counter: T1
ACME INC. AMC254 jan-02-06 T2
ACME INC. AMC254 apr-09-06 T2

thanks..

 

[lbass]

Create a running total {#yourrt} that does a count of any recurring field, evaluates for each record, and resets on change of order ID (is the same as the transaction ID? If so, use on change of group; otherwise use on change of field: Order ID, and sort the report on Order ID).

Then create a formula:

"T"+totext({#yourrt},0,"")

Place this in the detail section.

-LB

 

[eoggb]

perfect......thanks!