Hello Guys
I tried searching a solution within 2 days on how to solve my problem in reporting.. and now my choice is to post here where i need your help as one of member for me to be benefited.

rs=select * from tbldata order by code

in the report form.. it display like that..
-----------------------------------
tbldata:
---------------------------
code          data            
01               a
01                b
01               c
02               d
03               a
04               k
04               l
04               m



how can i do like this output

code          data            
----------------------
01               a
                  a
                  c
02              d
03              a
04               k
                  l
                 m


the duplicate entry removed.. no need other external report i use the built in reporter of vb6..

i wish your help guys.. i really appreciated you..
thanks

Did you try BUILD QUERY in datareport instead of loading the records directly? From there, you can set filter and condition on loading your records.

HTH



[Edited by TJ_01 on 08-03-2007 at 05:02 AM GMT]

____________________________
Im JAMES