Max Grouping

[informer30]

Hi All
I am using crystal reports xi rel2 and remember how to
formulate...I have sales id, sales type and
transaction date.

I have inserted group 1 as sales type, now I want to only
see the last transaction date for this sales type.

Note: A sales id can have many sales type and I am only interested
in the last transaction date record per sale type

Many Thanks

 

[lbass]

Are you looking for the most recent transaction per sales type for each sales ID? You would need a group #1 on sales ID, group #2 on sales type, and then go to report->selection formula->GROUP and enter:

{sales.date} = maximum({sales.date},{sales.saletype})

-LB