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...

[jeanette_db]

here's the output:
----
0001
jack 1123
jill 1124
jake 1125

0001
jack 1123
jill 1124
jake 1125
-----
in the report, batch '0001' is supposed to be printed only once.. ='(
but i got that result.. can anybody help me with this...
i really need it... thanks in advance...