DATA REPORT: grouping problem (redundant printing)

[jeanette_db]

i am creating a report wherein i need to group by "batches"..
but when i viewed the Report, the same data are printed repeatedly.

here's my code:

Set table_1 = New ADODB.Recordset
table_1.CursorLocation = adUseClient
table_1.Open "Shape {select btch_no from table_cdl} append ({select * from table_cdl} relate btch_no to btch_no) As ChildRecord", mycon1, adOpenStatic, adLockReadOnly, adCmdText
        Set a10999a.DataSource = table_1
        Set table_1.ActiveConnection = Nothing

please help...