Group selection formula in SSRS

[Cnnx]

I am trying to rewrite some Crystal 9.0 reports in SSRS 2005

My Select query is as follows:

SELECT Table1.Client_Ref, Table2.DateStart, 
FROM Table1 LEFT OUTER JOIN Table2 ON Table1.Client_Ref = Table2.Client_Ref
WHERE (TABLE2.DateStart <= '2008-11-30')

I then want to group by Client_Ref and show the record with the latest DateStart. In Crystal I grouped by Client_Ref and then defined a group selection formula:

{DateStart}= Maximum ({DateStart},{Table1.Client_Ref})

thus returning only one line for each client (the record with the latest DateStart).

I cannot see how to do this in SSRS. Any help gratefully received.

 

[RiverGuy]

Put this in the expression for the data column's textbox in the header of footer. =MAX(Fields!DateField.Value)

 

[Cnnx]

Many thanks RiverGuy. I realise it was probably a fairly basic question but you have saved me a great deal of time.
Thanks again