[RESOLVED] How to arrange the data in CR8.5

[girl81]

hi someone can help me.im a new developer.i don't know how to arrange the data in CR8.5.im using vb 6.0.this is my data from access 2000 (query).


D.O NO | Location | Lorry_No | Item |Description
001000 | Singapore |abc123 | 01 | Pipe 0.1m
001000 | Singapore |abc123 | 02 | Pipe 10 m
001000 | Singapore |abc123 | 03 | Pipe 30 m

I want to arrange the data above as below.

D.O NO| Location | Lorry_No | Item |Description
001000 | Singapore| abc123 | 01 |Pipe 0.1m
.......................................| 02 |Pipe 10 m
.......................................|03 | Pipe 30 m

i've group (D.O NO,Location and Lorry_NO).but i'v got the output like below.Item and Description not coming at the first line as other data.

D.O NO| Location | Lorry_No | Item |Description
001000 | Singapore| abc123
.......................................| 01 |Pipe 0.1m
.......................................| 02 |Pipe 10 m
.......................................|03 | Pipe 30 m

i dont know what the coding should i put in formula fields.hope anyone can help me.