DATA REPORT: grouping problem (redundant printing)
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:
VB 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...
Re: DATA REPORT: grouping problem (redundant printing)
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...