Nice paul but how can I group that display? What I mean is that for those who have the same source i want to display one row only....Like for example since the they have the same source my itemcode will display only the first and on the description i want to display various item...i want them to merge at one row since they have the same source..How can I do that?


Code:
Instead of this...

Source    ItemCode    Date      Qty  Description
123         ABC       1/11/05     1     TV
123         DEF       1/11/05     1     VCD
123         GHI       1/11/05     1     TVRACK


It will become like this:

Source    ItemCode    Date      Qty  Description
123         ABC       1/11/05     1     Various Item