Create a Group

[aj3221]

I have a field in my report called Invoice Date. It comes in as a string field. The date looks like this 20090925 (YYYYMMDD). I want to group the 2008 data then the 2009 data. I am running this by customer #, then by item. So I would want it to look like:

Customer# 123456

Item# Item Desc Inv Date Inv# Price
BAY123 Towel 20090108 123123 $125.00
Cont'd

Item# Item Desc Inv Date Inv# Price
BAY123 Towel 20080212 145623 $127.00
Con'td

Customer# 456123
same as above

I don't know how to tell it to use the last 4 of the Inv Date field and group based on that. So all the 2008 invoices are in one group and all the 2009's are in another group under that customer.

 

[lbass]

You want the first four:

left({table.stringdate},4)

Insert a group on this. From your sample, it looks like you want group #1 on custID, group #2 on the year formula, and group #3 on item #.

-LB