Hi all!

     I am in need of assistance...URGENTLY. I have bound my data report at
     run time to an ADO recordset (Below and works perfectly), but now need
     to group the report on three fields in the recordset (Directorate,
     Department, Team). How can I do this?????

     Code:

     Option Explicit

     Private oRS As New ADODB.Recordset

     Private Sub DataReport_Initialize()

         Dim strSQL as String

         strSQL = "Extremley Long SQL statement!"

         'goConn is a gloabl connection object for ease throughout the
         'project

         oRS.Open strSQL, goConn, adOpenForwardOnly, adLockReadOnly, _
                adCmdText

         With DataReport1
             Set .DataSource = oRS
             .Orientation = rptOrientLandscape
             .Caption = "Agreement Expenditure 2001 - 2001"
             .WindowState = 2
             .Show
         End With

     End Sub

     It couldn't be much more than this to make it group?!?! I hope!

     Thanks in Advance

     Rossco
     :-}

Deke